Loading

Creating More Worksheets in a Single Workbook.

Rajaraman Sahasranaman

Hi

I have a Dataset that generates 6 reports simultaneously. Instead of displaying in the Crystal Report, I just wanted to save the reports back to an excel file. How to do that? Please help me. Also in that process, there should be only one workbook, for eg. Book1.xls. It should contain all the 6 reports in seperate worksheets. Do anybody have an idea how to do it? I would appreciate if you give some sample code also. Thanks in advance.

Regards
Raja Raman S.
Bangalore.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Chand21y ago
Look at this section and learn how to add a sheet to a Book and you just have to get data from your DataSet, create a sheet, and add it to Workbook.
http://www.c-sharpcorner.com/OfficeNet.asp