Exporting Datasets Into Multiple Sheets In Excel

Question

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 2-Nov-10 0:43am

raghvendrapanda

Add a Solution

Comments

Henry Minute 2-Nov-10 6:57am

Yes.

2 solutions

Add a Solution

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

Arindam Tewary · Answer 1 · 2010-11-02T01:04:00

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,

thatraja · Answer 2 · 2010-11-02T02:46:00

Solution 2

Go here, also you have asked here too.
http://www.codeproject.com/Messages/3653856/Re-Exporting-Datasets-Into-Multiple-Sheets-In-Exce.aspx[^]

Posted 2-Nov-10 2:46am

thatraja

Exporting Datasets Into Multiple Sheets In Excel

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Exporting Datasets Into Multiple Sheets In Excel

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us