![]() 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 Comments
Leave a Reply. |