Export DataSet/ XML as Excel Sheet

[Sachin Salgarkar]

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

 

[Guest]

You could try looking at the Office Web Components

 

[Guest]

Sorry i forgot the link

http://www.microsoft.com/downloads/...2C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

 

[Steve C. Orr [MVP, MCSD]]

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/products/vsto/default.aspx

 

[ritzkandy]

Steve,
I have a similar requirement where in I have to generate a multi sheet excel workbook with the dataset results. Is there any way this can be achieved without using excel COM engine?

Thanks!