如何管理工作表
This article was translated from English: Does it need improvement?
TranslatedView the article in English
IronXL 函式庫透過 C# 程式碼簡化了工作表的管理。使用 IronXL，您可以執行創建和刪除工作表、更改工作表位置以及設置 Excel 文件中的活動工作表等操作，全部無需使用 Office Interop。
如何管理 Excel 活頁簿
立即開始在您的專案中使用IronPDF，並享受免費試用。
查看 IronXL 上 Nuget 快速安裝和部署。已被下載超過800萬次，它正用C#改變Excel。
請考慮安裝 IronXL DLL 直接下載並手動安裝到您的專案或GAC表單： IronXL.zip
管理工作表範例
管理工作表需要能夠創建、移動和刪除工作表。IronXL 允許您只需一行代碼即可完成這些操作。
請注意
以下提到的所有索引位置均為零基索引
建立工作表
CreateWorksheet 方法可以建立新的工作表。這個方法只需要工作表名稱作為參數。該方法還會返回建立的工作表對象，這樣你可以進行額外的操作，例如何例如： 合併 在創建後立即儲存格。
:path=/static-assets/excel/content-code-examples/how-to/manage-worksheet-create-worksheet.csusing IronXL;
// Create new Excel spreadsheet
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);
// Create worksheets
WorkSheet workSheet1 = workBook.CreateWorkSheet("workSheet1");
WorkSheet workSheet2 = workBook.CreateWorkSheet("workSheet2");
WorkSheet workSheet3 = workBook.CreateWorkSheet("workSheet3");
WorkSheet workSheet4 = workBook.CreateWorkSheet("workSheet4");
workBook.SaveAs("createNewWorkSheets.xlsx");Imports IronXL
' Create new Excel spreadsheet
Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
' Create worksheets
Private workSheet1 As WorkSheet = workBook.CreateWorkSheet("workSheet1")
Private workSheet2 As WorkSheet = workBook.CreateWorkSheet("workSheet2")
Private workSheet3 As WorkSheet = workBook.CreateWorkSheet("workSheet3")
Private workSheet4 As WorkSheet = workBook.CreateWorkSheet("workSheet4")
workBook.SaveAs("createNewWorkSheets.xlsx")VB C#
設定工作表位置
SetSheetPosition 方法允許您更改或移動工作表的位置。它需要兩個參數：工作表名稱作為 String 和其索引位置作為 Integer。
:path=/static-assets/excel/content-code-examples/how-to/manage-worksheet-set-sheet-position.csusing IronXL;
WorkBook workBook = WorkBook.Load("createNewWorkSheets.xlsx");
// Set worksheet position
workBook.SetSheetPosition("workSheet2", 0);
workBook.SaveAs("setWorksheetPosition.xlsx");Imports IronXL
Private workBook As WorkBook = WorkBook.Load("createNewWorkSheets.xlsx")
' Set worksheet position
workBook.SetSheetPosition("workSheet2", 0)
workBook.SaveAs("setWorksheetPosition.xlsx")VB C#
設定活動工作表
設定活動工作表意味著指定在其他數據視覺化工具（如 Excel）中第一次打開工作簿時應該默認打開哪個工作表。要實現此操作，請使用工作表的索引位置來調用 SetActiveTab 方法。
:path=/static-assets/excel/content-code-examples/how-to/manage-worksheet-set-active-tab.csusing IronXL;
WorkBook workBook = WorkBook.Load("createNewWorkSheets.xlsx");
// Set active for workSheet3
workBook.SetActiveTab(2);
workBook.SaveAs("setActiveTab.xlsx");Imports IronXL
Private workBook As WorkBook = WorkBook.Load("createNewWorkSheets.xlsx")
' Set active for workSheet3
workBook.SetActiveTab(2)
workBook.SaveAs("setActiveTab.xlsx")VB C#
刪除工作表
也可以使用 IronXL 刪除工作表。使用 RemoveWorksheet 方法以及工作表的索引位置。如果不知道工作表的位置，也可以使用工作表的名稱來刪除它。
:path=/static-assets/excel/content-code-examples/how-to/manage-worksheet-remove-worksheet.csusing IronXL;
WorkBook workBook = WorkBook.Load("createNewWorkSheets.xlsx");
// Remove workSheet1
workBook.RemoveWorkSheet(1);
// Remove workSheet2
workBook.RemoveWorkSheet("workSheet2");
workBook.SaveAs("removeWorksheet.xlsx");Imports IronXL
Private workBook As WorkBook = WorkBook.Load("createNewWorkSheets.xlsx")
' Remove workSheet1
workBook.RemoveWorkSheet(1)
' Remove workSheet2
workBook.RemoveWorkSheet("workSheet2")
workBook.SaveAs("removeWorksheet.xlsx")VB C#
複製工作表
可以在相同的工作簿內或跨不同的工作簿複製工作表。要在相同的工作簿內複製工作表，請使用 CopySheet 方法。要將工作表複製到不同的工作簿，請使用 CopyTo 方法。
:path=/static-assets/excel/content-code-examples/how-to/manage-worksheet-copy-worksheet.csusing IronXL;
WorkBook firstBook = WorkBook.Create(ExcelFileFormat.XLSX);
WorkBook secondBook = WorkBook.Create();
// Select first worksheet in the workbook
WorkSheet workSheet = firstBook.DefaultWorkSheet;
// Duplicate the worksheet to the same workbook
workSheet.CopySheet("Copied Sheet");
// Duplicate the worksheet to another workbook with the specified name
workSheet.CopyTo(secondBook, "Copied Sheet");
firstBook.SaveAs("firstWorksheet.xlsx");
secondBook.SaveAs("secondWorksheet.xlsx");IRON VB CONVERTER ERROR developers@ironsoftware.comVB C#
firstWorksheet.xlsx
secondWorksheet.xlsx
