473,569 Members | 2,747 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Export DataSet/ XML as Excel Sheet

I have a DataSet that I need to export to Excel.

The dataset has multiple tables. I need a way to export the complete dataset
to a single Excel Workbook with sheets for each table in the dataset.

Is that possible ?
I have seen solutions that export a single table to an Excel file.

Opening the XML ( DataSet.getXML( ) ) in Excel is a little complicated for
our users. Besides , the XML mappings are on the same sheet.

Any ideas?

Thanks,
Sachin
Aug 4 '06 #1
3 2968
You could try looking at the Office Web Components

"Sachin Salgarkar" wrote:
I have a DataSet that I need to export to Excel.

The dataset has multiple tables. I need a way to export the complete dataset
to a single Excel Workbook with sheets for each table in the dataset.

Is that possible ?
I have seen solutions that export a single table to an Excel file.

Opening the XML ( DataSet.getXML( ) ) in Excel is a little complicated for
our users. Besides , the XML mappings are on the same sheet.

Any ideas?

Thanks,
Sachin
Aug 4 '06 #2
Sorry i forgot the link

http://www.microsoft.com/downloads/d...displaylang=en

"Sachin Salgarkar" wrote:
I have a DataSet that I need to export to Excel.

The dataset has multiple tables. I need a way to export the complete dataset
to a single Excel Workbook with sheets for each table in the dataset.

Is that possible ?
I have seen solutions that export a single table to an Excel file.

Opening the XML ( DataSet.getXML( ) ) in Excel is a little complicated for
our users. Besides , the XML mappings are on the same sheet.

Any ideas?

Thanks,
Sachin
Aug 4 '06 #3
For exporting in such an elaborate way you'll likely need a tool to help you
out, such as one of these:

http://SteveOrr.net/reviews/AsposeExcel.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx

You should also consider new VSTO:
http://msdn.microsoft.com/vstudio/pr...o/default.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Sachin Salgarkar" <sa****@aegisco mmerce.comwrote in message
news:eN******** ******@TK2MSFTN GP05.phx.gbl...
>I have a DataSet that I need to export to Excel.

The dataset has multiple tables. I need a way to export the complete
dataset to a single Excel Workbook with sheets for each table in the
dataset.

Is that possible ?
I have seen solutions that export a single table to an Excel file.

Opening the XML ( DataSet.getXML( ) ) in Excel is a little complicated
for our users. Besides , the XML mappings are on the same sheet.

Any ideas?

Thanks,
Sachin

Aug 4 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
8878
by: Paul | last post by:
Hi all Arggghhh........... The problem.....I want the user to be able to create an excel document and name particular cells in the document where they want the data to be placed and then save this out of an XML file or Excel Template file. Next I need to convert a dataset to xml and try and transform this data into the users xml...
1
17390
by: Steven Stewart | last post by:
I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed a database for her which is intended to make things a lot easier; however, I don't have a lot of experience with Access and I find that designing...
1
10907
by: Ugo | last post by:
Hi, I am having a problem exporting a Datagrid to excel in asp.net. For some reason I am getting a blank excel page. I set up in IIS the Mime for ..xls. My code is below any help would be appreciated.. Thanks CODE: private void ExportToExcel()
8
2832
by: DC Gringo | last post by:
I have a simple button that should open another window and export a datagrid to an Excel file. I'm getting: "Name 'window' is not declared." What do I need to declare or import? <INPUT ID="Button5" ONCLICK="Button5_Click" NAME="Button5" TYPE="button" VALUE="Export to Excel"> Sub Button5_Click()
4
14998
by: Jiro Hidaka | last post by:
Hello, I would like to know of a fast way to export data source data into an Excel sheet. I found a way from C# Corner(Query Tool to Excel using C# and .NET) which is a neat little way of exporting dataset data to an excel using the Excel COM object. This works fine but the problem is its pretty darn slow when exporting large
13
13193
by: Hemant Sipahimalani | last post by:
The following piece of code is being used to export HTML to excel. HttpContext.Current.Response.ContentType = "application/vnd.ms-excel" HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=ABC.xls") HttpContext.Current.Response.Write(strHTML) HttpContext.Current.Response.End() However when the user tries to...
5
31901
by: Simon | last post by:
Dear reader, With the export command you can export a query to Excel. By activate this command a form pop's up with the following text:
10
3882
by: bill | last post by:
I have been searching everywhere AND am a bit new to vb .net/aspx, but can't seem to find anything that works. Specifically, I need to export a dataset from a webapp written in vb .net to a new excel spreadsheet with multiple tabs (each tab would contain different rows from the dataset). Does anyone have any sample code or examples I might...
2
6395
hemantbasva
by: hemantbasva | last post by:
Note We need to have a template on server for generating report in multiple sheet as we do not had msoffice on server moreover this require a batch job to delete excel file created by the method.... it creates 6 sheets # region Namespaces using System;
0
7609
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7666
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7964
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5504
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5217
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3651
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2107
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
936
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.