Use `RemoveWorkSheet` method along with index position of the worksheet. # Remove Worksheet Removing the worksheet can also be done with IronXL. To achieve this use `SetActiveTab` method with the index position of the worksheet. # Set Active Worksheet Set active worksheet means to set which worksheet to be opened by default when the workbook is opened. The worksheet name as String and its index position as Integer. # Set Worksheet Position `SetSheetPosition` method can be used to change or move worksheet position. It requires the worksheet name as the only parameter. # Create Worksheet The `CreateWorkSheet` method allows creating worksheet possible. The actions of create & delete worksheet, change worksheets position, set active worksheet in Excel file can be achieved without using Office Interop. `IronXL` library makes controlling worksheet using C# code as easy as possible. WorkBook.SetSheetPosition("workSheet2", 0) ' Set worksheet position (workSheet2, workSheet1, workSheet3) Private workSheet3 As WorkSheet = workBook.CreateWorkSheet("workSheet3") Private workSheet2 As WorkSheet = workBook.CreateWorkSheet("workSheet2") Private workSheet1 As WorkSheet = workBook.CreateWorkSheet("workSheet1") ' Create worksheets (workSheet1, workSheet2, workSheet3)
Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX) WorkBook.SaveAs("manageWorkSheet.xlsx") Imports IronXL Set worksheet position (workSheet2, workSheet1, workSheet3)
WorkSheet workSheet3 = workBook.CreateWorkSheet("workSheet3") WorkSheet workSheet2 = workBook.CreateWorkSheet("workSheet2") WorkSheet workSheet1 = workBook.CreateWorkSheet("workSheet1") Create worksheets (workSheet1, workSheet2, workSheet3)
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX)
0 kommentar(er)
