Connecting Tech Pros Worldwide Forums | Help | Site Map

Export DataSet/ XML as Excel Sheet

Sachin Salgarkar
Guest
 
Posts: n/a
#1: Aug 4 '06
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



clickon
Guest
 
Posts: n/a
#2: Aug 4 '06

re: Export DataSet/ XML as Excel Sheet


You could try looking at the Office Web Components



"Sachin Salgarkar" wrote:
Quote:
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
>
>
>
clickon
Guest
 
Posts: n/a
#3: Aug 4 '06

re: Export DataSet/ XML as Excel Sheet


Sorry i forgot the link

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

"Sachin Salgarkar" wrote:
Quote:
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
>
>
>
Steve C. Orr [MVP, MCSD]
Guest
 
Posts: n/a
#4: Aug 4 '06

re: Export DataSet/ XML as Excel Sheet


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" <sachin@aegiscommerce.comwrote in message
news:eNMGvs7tGHA.2392@TK2MSFTNGP05.phx.gbl...
Quote:
>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
>

Closed Thread