Last post Aug 23, 2011 08:36 AM by Roberto Goves
Aug 08, 2011 10:29 AM|Anurag Rawat|LINK
By default if we create an excel through code, it will create 3 sheets. In case I need to specify 5 sheets at the initial point then how should i proceed? It can be done through AddMethod, but it will add one by one sheet and again i have to move the sheet
in proper order.
Can all this be done at the time of excel creation and do not need to create the sheet one by one?
Thanks in advance!
Aug 09, 2011 03:43 AM|smirnov|LINK
If you can use NPOI library, it can do it using HSSFWorkbook.CreateSheet method. I'm doing a lot with export-import from Excel and NPOI is my preferable choice.
Aug 23, 2011 08:36 AM|Roberto Goves|LINK
So far I am using
Excel Jetcell .NET component. At their website you will find different
Excel samples on C# / VB.NET.
You can add worksheets one by one or insert them using worksheets collection of workbook object.
It is quite good because does not use Excel Interop, supports various excel formats (xls, xlsx, ods, csv)