Generating Excel file with some number of sheets with a single template.

Question

Hi,

i am generating an excel file with some number of sheets. I am using a template .xlt file which have one worksheet. Now I am able to generate the xl file with that template if there is only one worksheet in that excel file. But when I have to create more than one worksheet, I am unable to do that. Then the excel file do not use the template and instead use a blank worksheet. Can anyone point me to some reference where i can use the same template worksheet to create n number of worksheets in the same workbook.

Answer 1

SpreadsheetGear for .NET can do it.

See the "Worksheet with Chart to Multiple Worksheets with Charts" sample on our Excel Reporting Samples page for an example or download the free trial here to try it yourself.

Since the SpreadsheetGear API is very similar to the Excel API, you should be able to adapt the SpreadsheetGear code to work with Excel if you need to.

Disclaimer: I own SpreadsheetGear LLC