如何管理工作表
This article was translated from English: Does it need improvement?
TranslatedView the article in English
IronXL**库简化了使用C#代码管理工作表的过程。使用 IronXL，您可以在 Excel 文件中执行创建和删除工作表、更改工作表位置和设置活动工作表等操作，而无需进行 Office Interop。
开始在您的项目中使用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 方法可以更改或移动工作表的位置。它需要两个参数：工作表名称（字符串）和索引位置（整数）。
: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
