如何添加命名表
This article was translated from English: Does it need improvement?
TranslatedView the article in English
命名表通常也称为 Excel 表，指的是一种特定类型的范围，该范围已指定名称，并具有与之相关的附加功能和属性。
如何添加命名表
- 下载 C# 库以添加命名表格
- 选择目标范围 工作表 ["A1:A5"]
- 利用
添加命名表方法添加命名表格 - 以各种方式读取命名表
- 将编辑好的 Excel 文件导出为各种格式
开始在您的项目中使用IronPDF，并立即获取免费试用。
查看 IronXL 上 Nuget 用于快速安装和部署。它有超过800万次下载，正在使用C#改变Excel。
考虑安装 IronXL DLL 直接。下载并手动安装到您的项目或GAC表单中： IronXL.zip
添加命名表示例
要添加已命名表，请使用 AddNamedTable 方法。该方法要求命名表的名称为文本、范围对象。用户还可以指定表格样式以及是否显示筛选器。
:path=/static-assets/excel/content-code-examples/how-to/named-table-add-named-table.csusing IronXL;
using IronXL.Styles;
WorkBook workBook = WorkBook.Create();
WorkSheet workSheet = workBook.DefaultWorkSheet;
// Add data
workSheet["A2:C5"].StringValue = "Text";
// Configure named table
var selectedRange = workSheet["A1:C5"];
bool showFilter = false;
var tableStyle = TableStyle.TableStyleDark1;
// Add named table
workSheet.AddNamedTable("table1", selectedRange, showFilter, tableStyle);
workBook.SaveAs("addNamedTable.xlsx");Imports IronXL
Imports IronXL.Styles
Private workBook As WorkBook = WorkBook.Create()
Private workSheet As WorkSheet = workBook.DefaultWorkSheet
' Add data
Private workSheet("A2:C5").StringValue = "Text"
' Configure named table
Private selectedRange = workSheet("A1:C5")
Private showFilter As Boolean = False
Private tableStyle = TableStyle.TableStyleDark1
' Add named table
workSheet.AddNamedTable("table1", selectedRange, showFilter, tableStyle)
workBook.SaveAs("addNamedTable.xlsx")VB C#
检索命名表示例
检索所有命名表
GetNamedTableNames` 方法将以字符串列表的形式返回工作表中所有已命名的表格。
:path=/static-assets/excel/content-code-examples/how-to/named-table-retrieve-all-named-table.csusing IronXL;
WorkBook workBook = WorkBook.Load("addNamedTable.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;
// Get all named table
var namedTableList = workSheet.GetNamedTableNames();Imports IronXL
Private workBook As WorkBook = WorkBook.Load("addNamedTable.xlsx")
Private workSheet As WorkSheet = workBook.DefaultWorkSheet
' Get all named table
Private namedTableList = workSheet.GetNamedTableNames()VB C#
检索特定的命名表
使用 GetNamedTable 方法获取工作表中的特定命名表。
:path=/static-assets/excel/content-code-examples/how-to/named-table-retrieve-specific-named-table.csusing IronXL;
WorkBook workBook = WorkBook.Load("addNamedTable.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;
// Get named table
var namedRangeAddress = workSheet.GetNamedTable("table1");Imports IronXL
Private workBook As WorkBook = WorkBook.Load("addNamedTable.xlsx")
Private workSheet As WorkSheet = workBook.DefaultWorkSheet
' Get named table
Private namedRangeAddress = workSheet.GetNamedTable("table1")VB C#
IronXL 还可以添加命名范围。了解更多信息，请访问 如何添加命名范围.
