how to export multiple resultsets to different excel sheets

Question

Hi Folks  how to export multiple resultsets to different excel sheets in java and Sql Environment.

Ravi Gaddam · Answer

i am looking in java environment not in C# source. anyway thanks a lot for your time.

alice yang · Answer

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

Bhuvanesh Mohankumar · Answer

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.

Bhuvanesh Mohankumar · Answer

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