Add and Remove a Worksheet
Add a Worksheet
Code Sample:
//Create a new workbook
XlsWorkbook workbook = new XlsWorkbook();
//Add a new worksheet
workbook.Worksheets.Add("newsheet");
//Save the Excel file
workbook.Save("C:\book1.xls");
'Create a new workbook
Dim workbook As Workbook = New XlsWorkbook()
'Adding a new worksheet to the Workbook object
workbook.Worksheets.Add("newsheet")
'Save the Excel file
workbook.Save("C:\book1.xls")
Remove a Worksheet
Code Sample
//Create a Workbook object
XlsWorkbook workbook = new XlsWorkbook("C:\book1.xls");
//Remove the worksheet with specified sheet name
workbook.Worksheets.Remove("sheet1");
//Save the Excel file
workbook.Save("C:\book1.xls");
'Create a Workbook object
Dim workbook As XlsWorkbook = New XlsWorkbook("C:\book1.xls")
'Remove the worksheet with specified sheet name
workbook.Worksheets.Remove("sheet1")
'Save the Excel file
workbook.Save("C:\book1.xls")