This project is read-only.

How To Create Worksheets in the Workbook

Jul 8, 2012 at 6:46 AM

I just came across your library and it looks great.  I am not sure how to add a worksheet to the workbook I am working with though.  Would you mind enlightening me?

Thanks,

David

Jul 13, 2012 at 10:27 AM

You are right, I miss this feature; I thoght I have it. I will add it soon.

Thanks for the tipp.

Sep 4, 2012 at 7:30 PM
Edited Sep 4, 2012 at 7:32 PM

I've just added a new method in ExcelHelper called InsertSheet, which allows you to clone a "template sheet" and insert it right after the current-sheet (settable by CurrentSheetName); in case you set the CurrentSheetName to null, then it will be inserted in front. After inserting the new sheet, this will become the current sheet.