how to export multiple resultsets to different excel sheets

i am looking in java environment not in C# source.

anyway thanks a lot for your time.

0

Check:

http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html

0

I suggest you to assign the data to the dataSet,

Have a common method to supply the Datatable and File name.

Each data table will be posted to the separate excel file.

A single method take care of Spliting Dataset into Datatable and writing to a excel.

Let me know, if you need any sample.

Mark as answer, if helpful.

0

Please look at this,

http://www.codeproject.com/Articles/31516/Export-DataSet-to-Multiple-Excel-Sheets

0