Click here to Skip to main content
15,945,119 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I had a procedure which returns 5 result sets. Now i want to export 3 results sets in 1 excel sheet and the remaining 2 resultsets in another excel sheet. Can we do this in C#.net code

Thanks,
Ram
Posted
Comments
Henry Minute 2-Nov-10 6:57am    
Yes.

Hi,

Yes this is achievable easily using Aspose.Cells. It is a third party tool. You need to purchase lisense as I remember. :)

http://www.aspose.com/demos/.net-components/aspose.cells/csharp/quick-start/data/export-data.aspx



Otherwise, you need to loop through each excel worksheet, cells etc and need to set each cells value from each data table(which is from dataset).

Thanks
Arindam D Tewary,
 
Share this answer
 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900