如何使用C#在Excel中新增命名表格
要使用C#在Excel中添加命名表,請使用IronXL的AddNamedTable方法,並提供表名、範圍和可選樣式的參數——這使得使用單一方法調用能夠進行結構化資料管理。
命名表也常被稱為 Excel 表,它指的是一種特定類型的區域,該區域已指定名稱,並具有與之關聯的附加功能和屬性。 具名表格提供增強的數據組織能力、自動格式化、內建篩選及與Excel公式的簡單整合 - 在Excel自動化工作流程中,這使其成為管理結構化數據集的必要工具。
快速入門:用一行程式碼建立並命名表格
這個範例展示了您如何輕鬆地在您的工作表中使用IronXL新增具名表格 - 定義名稱、範圍、篩選器可見性和樣式,所有操作都在一個清晰的方法呼叫中完成。
-
1使用 IronXL 安裝 NuGet Package Manager
-
2複製並運行這段程式碼。
var table = workSheet.AddNamedTable("MyTable", workSheet.GetRange("A1:B5"), showFilter: true, tableStyle: IronXL.Styles.TableStyle.TableStyleMedium2);Dim table = workSheet.AddNamedTable("MyTable", workSheet.GetRange("A1:B5"), showFilter:=True, tableStyle:=IronXL.Styles.TableStyle.TableStyleMedium2)Dim table = workSheet.AddNamedTable("MyTable", workSheet.GetRange("A1:B5"), showFilter:=True, tableStyle:=IronXL.Styles.TableStyle.TableStyleMedium2) -
3部署到您的生產環境進行測試
立即在您的項目中開始使用 IronXL,並使用 免費試用
最小工作流程(5 個步驟)
- 下載C#函式庫以新增具名表格
- 選擇目標區域workSheet["A1:A5"]
- 使用
AddNamedTable方法新增命名表 - 以各種方式檢索命名表
- 以各種格式匯出編輯後的 Excel 文件
如何在我的Excel工作表中新增具名表格?
要新增具名表格,使用AddNamedTable方法。 此方法需要以字串形式提供表名,以及範圍物件。 您也可以選擇指定表格樣式以及是否顯示篩選器。 當處理DataSet和DataTable導入時,這項功能特別有用,因為結構化資料需要適當組織。
// Example code to add a named table using IronXL
using IronXL;
using IronXL.Styles;
using System.Linq;
// Load the Excel workbook
var workbook = WorkBook.Load("example.xlsx");
// Select the worksheet
var workSheet = workbook.WorkSheets.First();
// Define the range for the named table
var range = workSheet["A1:B10"];
// Add a named table with the specified name and range
// Optionally, set table style and visibility of the filter
workSheet.AddNamedTable("MyTable", range, showFilter: true, tableStyle: TableStyle.TableStyleDark10);
// Save the modified workbook
workbook.SaveAs("modified_example.xlsx");// Example code to add a named table using IronXL
using IronXL;
using IronXL.Styles;
using System.Linq;
// Load the Excel workbook
var workbook = WorkBook.Load("example.xlsx");
// Select the worksheet
var workSheet = workbook.WorkSheets.First();
// Define the range for the named table
var range = workSheet["A1:B10"];
// Add a named table with the specified name and range
// Optionally, set table style and visibility of the filter
workSheet.AddNamedTable("MyTable", range, showFilter: true, tableStyle: TableStyle.TableStyleDark10);
// Save the modified workbook
workbook.SaveAs("modified_example.xlsx");' Example code to add a named table using IronXL
Imports IronXL
Imports IronXL.Styles
Imports System.Linq
' Load the Excel workbook
Dim workbook = WorkBook.Load("example.xlsx")
' Select the worksheet
Dim workSheet = workbook.WorkSheets.First()
' Define the range for the named table
Dim range = workSheet("A1:B10")
' Add a named table with the specified name and range
' Optionally, set table style and visibility of the filter
workSheet.AddNamedTable("MyTable", range, showFilter:=True, tableStyle:=TableStyle.TableStyleDark10)
' Save the modified workbook
workbook.SaveAs("modified_example.xlsx")' Example code to add a named table using IronXL
Imports IronXL
Imports IronXL.Styles
Imports System.Linq
' Load the Excel workbook
Dim workbook = WorkBook.Load("example.xlsx")
' Select the worksheet
Dim workSheet = workbook.WorkSheets.First()
' Define the range for the named table
Dim range = workSheet("A1:B10")
' Add a named table with the specified name and range
' Optionally, set table style and visibility of the filter
workSheet.AddNamedTable("MyTable", range, showFilter:=True, tableStyle:=TableStyle.TableStyleDark10)
' Save the modified workbook
workbook.SaveAs("modified_example.xlsx")具名表格透過TableStyle類別支援各種樣式選項。 您可以立即套用專業格式化,這可輔助其他格式化功能,如儲存格樣式和邊框。 以下是示範不同表格樣式應用程式的範例:
// Example: Creating multiple styled named tables
using IronXL;
using IronXL.Styles;
var workbook = WorkBook.Create();
var sheet = workbook.CreateWorkSheet("SalesData");
// Add sample data
sheet["A1"].Value = "Product";
sheet["B1"].Value = "Sales";
sheet["C1"].Value = "Revenue";
// Populate data rows
for (int i = 2; i <= 10; i++)
{
sheet[$"A{i}"].Value = $"Product {i-1}";
sheet[$"B{i}"].IntValue = i * 100;
sheet[$"C{i}"].DecimalValue = i * 250.50m;
}
// Create a light-styled table
var salesTable = sheet.AddNamedTable("SalesTable", sheet["A1:C10"],
showFilter: true,
tableStyle: TableStyle.TableStyleLight15);
// Create another table with dark styling
sheet["E1"].Value = "Region";
sheet["F1"].Value = "Performance";
var regionTable = sheet.AddNamedTable("RegionData", sheet["E1:F5"],
showFilter: false,
tableStyle: TableStyle.TableStyleDark3);
workbook.SaveAs("styled_tables.xlsx");// Example: Creating multiple styled named tables
using IronXL;
using IronXL.Styles;
var workbook = WorkBook.Create();
var sheet = workbook.CreateWorkSheet("SalesData");
// Add sample data
sheet["A1"].Value = "Product";
sheet["B1"].Value = "Sales";
sheet["C1"].Value = "Revenue";
// Populate data rows
for (int i = 2; i <= 10; i++)
{
sheet[$"A{i}"].Value = $"Product {i-1}";
sheet[$"B{i}"].IntValue = i * 100;
sheet[$"C{i}"].DecimalValue = i * 250.50m;
}
// Create a light-styled table
var salesTable = sheet.AddNamedTable("SalesTable", sheet["A1:C10"],
showFilter: true,
tableStyle: TableStyle.TableStyleLight15);
// Create another table with dark styling
sheet["E1"].Value = "Region";
sheet["F1"].Value = "Performance";
var regionTable = sheet.AddNamedTable("RegionData", sheet["E1:F5"],
showFilter: false,
tableStyle: TableStyle.TableStyleDark3);
workbook.SaveAs("styled_tables.xlsx");Imports IronXL
Imports IronXL.Styles
Dim workbook = WorkBook.Create()
Dim sheet = workbook.CreateWorkSheet("SalesData")
' Add sample data
sheet("A1").Value = "Product"
sheet("B1").Value = "Sales"
sheet("C1").Value = "Revenue"
' Populate data rows
For i As Integer = 2 To 10
sheet($"A{i}").Value = $"Product {i - 1}"
sheet($"B{i}").IntValue = i * 100
sheet($"C{i}").DecimalValue = i * 250.5D
Next
' Create a light-styled table
Dim salesTable = sheet.AddNamedTable("SalesTable", sheet("A1:C10"),
showFilter:=True,
tableStyle:=TableStyle.TableStyleLight15)
' Create another table with dark styling
sheet("E1").Value = "Region"
sheet("F1").Value = "Performance"
Dim regionTable = sheet.AddNamedTable("RegionData", sheet("E1:F5"),
showFilter:=False,
tableStyle:=TableStyle.TableStyleDark3)
workbook.SaveAs("styled_tables.xlsx")Imports IronXL
Imports IronXL.Styles
Dim workbook = WorkBook.Create()
Dim sheet = workbook.CreateWorkSheet("SalesData")
' Add sample data
sheet("A1").Value = "Product"
sheet("B1").Value = "Sales"
sheet("C1").Value = "Revenue"
' Populate data rows
For i As Integer = 2 To 10
sheet($"A{i}").Value = $"Product {i - 1}"
sheet($"B{i}").IntValue = i * 100
sheet($"C{i}").DecimalValue = i * 250.5D
Next
' Create a light-styled table
Dim salesTable = sheet.AddNamedTable("SalesTable", sheet("A1:C10"),
showFilter:=True,
tableStyle:=TableStyle.TableStyleLight15)
' Create another table with dark styling
sheet("E1").Value = "Region"
sheet("F1").Value = "Performance"
Dim regionTable = sheet.AddNamedTable("RegionData", sheet("E1:F5"),
showFilter:=False,
tableStyle:=TableStyle.TableStyleDark3)
workbook.SaveAs("styled_tables.xlsx")
我該如何從工作表檢索具名表格?
什麼方法會返回工作表中的所有具名表格?
GetNamedTableNames方法會將工作表中所有具名表格以字串列表返回。 在處理包含多個表格的活頁簿或管理具有動態數據結構的工作表時,這特別有用。
// Example code to retrieve all named table names using IronXL
using IronXL;
using System;
using System.Linq;
// Load the Excel workbook
var workbook = WorkBook.Load("example.xlsx");
// Select the worksheet
var workSheet = workbook.WorkSheets.First();
// Retrieve all named table names
var tableNames = workSheet.GetNamedTableNames();
// Output each table name
foreach (var name in tableNames)
{
Console.WriteLine("Named Table: " + name);
}// Example code to retrieve all named table names using IronXL
using IronXL;
using System;
using System.Linq;
// Load the Excel workbook
var workbook = WorkBook.Load("example.xlsx");
// Select the worksheet
var workSheet = workbook.WorkSheets.First();
// Retrieve all named table names
var tableNames = workSheet.GetNamedTableNames();
// Output each table name
foreach (var name in tableNames)
{
Console.WriteLine("Named Table: " + name);
}' Example code to retrieve all named table names using IronXL
Imports IronXL
Imports System
Imports System.Linq
' Load the Excel workbook
Dim workbook = WorkBook.Load("example.xlsx")
' Select the worksheet
Dim workSheet = workbook.WorkSheets.First()
' Retrieve all named table names
Dim tableNames = workSheet.GetNamedTableNames()
' Output each table name
For Each name In tableNames
Console.WriteLine("Named Table: " & name)
Next name' Example code to retrieve all named table names using IronXL
Imports IronXL
Imports System
Imports System.Linq
' Load the Excel workbook
Dim workbook = WorkBook.Load("example.xlsx")
' Select the worksheet
Dim workSheet = workbook.WorkSheets.First()
' Retrieve all named table names
Dim tableNames = workSheet.GetNamedTableNames()
' Output each table name
For Each name In tableNames
Console.WriteLine("Named Table: " & name)
Next name如何依名稱存取特定的具名表格?
使用GetNamedTable方法檢索工作表中的特定具名表格。 一旦檢索,您可以存取各種屬性並執行操作,比如排序儲存格範圍或套用條件格式化。
// Example code to retrieve a specific named table using IronXL
using IronXL;
using System;
using System.Linq;
// Load the Excel workbook
var workbook = WorkBook.Load("example.xlsx");
// Select the worksheet
var workSheet = workbook.WorkSheets.First();
// Retrieve a specific named table
var namedTable = workSheet.GetNamedTable("MyTable");
// Output some information about the table
Console.WriteLine("Table range: " + namedTable.RangeAddressAsString);
Console.WriteLine("Rows: " + namedTable.RowCount);// Example code to retrieve a specific named table using IronXL
using IronXL;
using System;
using System.Linq;
// Load the Excel workbook
var workbook = WorkBook.Load("example.xlsx");
// Select the worksheet
var workSheet = workbook.WorkSheets.First();
// Retrieve a specific named table
var namedTable = workSheet.GetNamedTable("MyTable");
// Output some information about the table
Console.WriteLine("Table range: " + namedTable.RangeAddressAsString);
Console.WriteLine("Rows: " + namedTable.RowCount);' Example code to retrieve a specific named table using IronXL
Imports IronXL
Imports System
Imports System.Linq
' Load the Excel workbook
Dim workbook = WorkBook.Load("example.xlsx")
' Select the worksheet
Dim workSheet = workbook.WorkSheets.First()
' Retrieve a specific named table
Dim namedTable = workSheet.GetNamedTable("MyTable")
' Output some information about the table
Console.WriteLine("Table range: " & namedTable.RangeAddressAsString)
Console.WriteLine("Rows: " & namedTable.RowCount)' Example code to retrieve a specific named table using IronXL
Imports IronXL
Imports System
Imports System.Linq
' Load the Excel workbook
Dim workbook = WorkBook.Load("example.xlsx")
' Select the worksheet
Dim workSheet = workbook.WorkSheets.First()
' Retrieve a specific named table
Dim namedTable = workSheet.GetNamedTable("MyTable")
' Output some information about the table
Console.WriteLine("Table range: " & namedTable.RangeAddressAsString)
Console.WriteLine("Rows: " & namedTable.RowCount)處理表格數據
命名表格提供強大的資料處理功能。 以下是一個綜合範例,展示如何處理表格資料:
// Advanced named table operations
using IronXL;
using System.Linq;
var workbook = WorkBook.Load("sales_data.xlsx");
var sheet = workbook.DefaultWorkSheet;
// Create a named table from existing data
var dataRange = sheet["A1:D20"];
var salesTable = sheet.AddNamedTable("MonthlySales", dataRange, true);
// Access table data for calculations
var tableRange = salesTable.TableRange;
// Sum values in a specific column (assuming column C contains numeric data)
decimal totalSales = 0;
for (int row = 2; row <= tableRange.RowCount; row++)
{
var cellValue = sheet[$"C{row}"].DecimalValue;
totalSales += cellValue;
}
// Add summary row
var summaryRow = tableRange.RowCount + 1;
sheet[$"B{summaryRow}"].Value = "Total:";
sheet[$"C{summaryRow}"].Value = totalSales;
// Apply formatting to the summary row
sheet[$"B{summaryRow}:D{summaryRow}"].Style.Font.Bold = true;
sheet[$"B{summaryRow}:D{summaryRow}"].Style.SetBackgroundColor("#FFE599");
workbook.SaveAs("sales_with_summary.xlsx");// Advanced named table operations
using IronXL;
using System.Linq;
var workbook = WorkBook.Load("sales_data.xlsx");
var sheet = workbook.DefaultWorkSheet;
// Create a named table from existing data
var dataRange = sheet["A1:D20"];
var salesTable = sheet.AddNamedTable("MonthlySales", dataRange, true);
// Access table data for calculations
var tableRange = salesTable.TableRange;
// Sum values in a specific column (assuming column C contains numeric data)
decimal totalSales = 0;
for (int row = 2; row <= tableRange.RowCount; row++)
{
var cellValue = sheet[$"C{row}"].DecimalValue;
totalSales += cellValue;
}
// Add summary row
var summaryRow = tableRange.RowCount + 1;
sheet[$"B{summaryRow}"].Value = "Total:";
sheet[$"C{summaryRow}"].Value = totalSales;
// Apply formatting to the summary row
sheet[$"B{summaryRow}:D{summaryRow}"].Style.Font.Bold = true;
sheet[$"B{summaryRow}:D{summaryRow}"].Style.SetBackgroundColor("#FFE599");
workbook.SaveAs("sales_with_summary.xlsx");Imports IronXL
Imports System.Linq
Dim workbook = WorkBook.Load("sales_data.xlsx")
Dim sheet = workbook.DefaultWorkSheet
' Create a named table from existing data
Dim dataRange = sheet("A1:D20")
Dim salesTable = sheet.AddNamedTable("MonthlySales", dataRange, True)
' Access table data for calculations
Dim tableRange = salesTable.TableRange
' Sum values in a specific column (assuming column C contains numeric data)
Dim totalSales As Decimal = 0
For row As Integer = 2 To tableRange.RowCount
Dim cellValue = sheet($"C{row}").DecimalValue
totalSales += cellValue
Next
' Add summary row
Dim summaryRow = tableRange.RowCount + 1
sheet($"B{summaryRow}").Value = "Total:"
sheet($"C{summaryRow}").Value = totalSales
' Apply formatting to the summary row
sheet($"B{summaryRow}:D{summaryRow}").Style.Font.Bold = True
sheet($"B{summaryRow}:D{summaryRow}").Style.SetBackgroundColor("#FFE599")
workbook.SaveAs("sales_with_summary.xlsx")Imports IronXL
Imports System.Linq
Dim workbook = WorkBook.Load("sales_data.xlsx")
Dim sheet = workbook.DefaultWorkSheet
' Create a named table from existing data
Dim dataRange = sheet("A1:D20")
Dim salesTable = sheet.AddNamedTable("MonthlySales", dataRange, True)
' Access table data for calculations
Dim tableRange = salesTable.TableRange
' Sum values in a specific column (assuming column C contains numeric data)
Dim totalSales As Decimal = 0
For row As Integer = 2 To tableRange.RowCount
Dim cellValue = sheet($"C{row}").DecimalValue
totalSales += cellValue
Next
' Add summary row
Dim summaryRow = tableRange.RowCount + 1
sheet($"B{summaryRow}").Value = "Total:"
sheet($"C{summaryRow}").Value = totalSales
' Apply formatting to the summary row
sheet($"B{summaryRow}:D{summaryRow}").Style.Font.Bold = True
sheet($"B{summaryRow}:D{summaryRow}").Style.SetBackgroundColor("#FFE599")
workbook.SaveAs("sales_with_summary.xlsx")與其他IronXL功能的整合
具名表格可與其他IronXL功能一起使用。 您可以將它們與公式結合使用以進行動態計算,或在創建圖表時將其用作數據來源。 它們也是在導出為不同格式之前組織數據的優良工具。
// Example: Named table with formulas
using IronXL;
using IronXL.Styles;
var workbook = WorkBook.Create();
var sheet = workbook.CreateWorkSheet("Analysis");
// Create data structure
sheet["A1"].Value = "Item";
sheet["B1"].Value = "Quantity";
sheet["C1"].Value = "Price";
sheet["D1"].Value = "Total";
// Add sample data
for (int i = 2; i <= 6; i++)
{
sheet[$"A{i}"].Value = $"Item {i-1}";
sheet[$"B{i}"].IntValue = i * 10;
sheet[$"C{i}"].DecimalValue = i * 15.99m;
// Add formula to calculate total
sheet[$"D{i}"].Formula = $"=B{i}*C{i}";
}
// Create named table including the formula column
var priceTable = sheet.AddNamedTable("PriceCalculations", sheet["A1:D6"],
showFilter: true,
tableStyle: TableStyle.TableStyleMedium9);
// Add a grand total formula
sheet["C7"].Value = "Grand Total:";
sheet["D7"].Formula = "=SUM(D2:D6)";
sheet["D7"].Style.Font.Bold = true;
workbook.SaveAs("table_with_formulas.xlsx");// Example: Named table with formulas
using IronXL;
using IronXL.Styles;
var workbook = WorkBook.Create();
var sheet = workbook.CreateWorkSheet("Analysis");
// Create data structure
sheet["A1"].Value = "Item";
sheet["B1"].Value = "Quantity";
sheet["C1"].Value = "Price";
sheet["D1"].Value = "Total";
// Add sample data
for (int i = 2; i <= 6; i++)
{
sheet[$"A{i}"].Value = $"Item {i-1}";
sheet[$"B{i}"].IntValue = i * 10;
sheet[$"C{i}"].DecimalValue = i * 15.99m;
// Add formula to calculate total
sheet[$"D{i}"].Formula = $"=B{i}*C{i}";
}
// Create named table including the formula column
var priceTable = sheet.AddNamedTable("PriceCalculations", sheet["A1:D6"],
showFilter: true,
tableStyle: TableStyle.TableStyleMedium9);
// Add a grand total formula
sheet["C7"].Value = "Grand Total:";
sheet["D7"].Formula = "=SUM(D2:D6)";
sheet["D7"].Style.Font.Bold = true;
workbook.SaveAs("table_with_formulas.xlsx");Imports IronXL
Imports IronXL.Styles
Dim workbook = WorkBook.Create()
Dim sheet = workbook.CreateWorkSheet("Analysis")
' Create data structure
sheet("A1").Value = "Item"
sheet("B1").Value = "Quantity"
sheet("C1").Value = "Price"
sheet("D1").Value = "Total"
' Add sample data
For i As Integer = 2 To 6
sheet($"A{i}").Value = $"Item {i - 1}"
sheet($"B{i}").IntValue = i * 10
sheet($"C{i}").DecimalValue = i * 15.99D
' Add formula to calculate total
sheet($"D{i}").Formula = $"=B{i}*C{i}"
Next
' Create named table including the formula column
Dim priceTable = sheet.AddNamedTable("PriceCalculations", sheet("A1:D6"), True, TableStyle.TableStyleMedium9)
' Add a grand total formula
sheet("C7").Value = "Grand Total:"
sheet("D7").Formula = "=SUM(D2:D6)"
sheet("D7").Style.Font.Bold = True
workbook.SaveAs("table_with_formulas.xlsx")Imports IronXL
Imports IronXL.Styles
Dim workbook = WorkBook.Create()
Dim sheet = workbook.CreateWorkSheet("Analysis")
' Create data structure
sheet("A1").Value = "Item"
sheet("B1").Value = "Quantity"
sheet("C1").Value = "Price"
sheet("D1").Value = "Total"
' Add sample data
For i As Integer = 2 To 6
sheet($"A{i}").Value = $"Item {i - 1}"
sheet($"B{i}").IntValue = i * 10
sheet($"C{i}").DecimalValue = i * 15.99D
' Add formula to calculate total
sheet($"D{i}").Formula = $"=B{i}*C{i}"
Next
' Create named table including the formula column
Dim priceTable = sheet.AddNamedTable("PriceCalculations", sheet("A1:D6"), True, TableStyle.TableStyleMedium9)
' Add a grand total formula
sheet("C7").Value = "Grand Total:"
sheet("D7").Formula = "=SUM(D2:D6)"
sheet("D7").Style.Font.Bold = True
workbook.SaveAs("table_with_formulas.xlsx")IronXL還可以新增具名範圍。 在如何新增具名範圍中了解更多。
常見問題
如何使用C#與IronXL在Excel中建立命名表格?
您可以通過利用IronXL的AddNamedTable方法,使用C#在Excel中建立命名表格。此方法允許您定義表名稱、範圍和可選樣式等參數,從而通過單一方法調用實現結構化數據管理。
Excel中的命名表格是什麼,為什麼有用?
Excel中的命名表格,也被稱為Excel表格,是已經被指定名稱的範圍,提供自動格式化、內建過濾和便於使用Excel公式等功能。它增強了數據組織和管理,特別對於結構化資料集在Excel自動化工作流程中非常有用。
使用IronXL在C#項目中管理命名表格有哪些優點?
IronXL為管理命名表格提供了簡單和高效的方法。通過如AddNamedTable的方法,開發者可以快速創建具有自定義樣式和過濾的表格,管理結構化數據,並與Excel的其他特性(如公式和數據匯出)整合。
我可以使用IronXL為命名表格應用不同的樣式嗎?
是的,IronXL允許您通過TableStyle類為命名表格應用各種樣式。您可以立即為表格設置專業格式,包括淺色與深色樣式,這些樣式與其他格式化特性(如單元格樣式和邊框)互補。
如何使用IronXL從工作表中檢索所有命名表格?
要從工作表中檢索所有命名表格,請使用IronXL的GetNamedTableNames方法。它返回表示所有存在的命名表格名稱的字串列表,這對於管理具有多個表格或動態數據結構的工作簿非常有用。
在IronXL中,是否可以按名稱訪問和操作特定的命名表格?
是的,您可以使用IronXL的GetNamedTable方法來訪問特定的命名表格。訪問後,您可以操作其屬性或執行例如排序或格式化的操作。
IronXL中的命名表格如何增強數據操作能力?
IronXL中的命名表格提供強大的數據操作能力。它們允許進行高級操作,如以程式化的方式對欄值求和、添加摘要列以及應用條件格式,這使得其在全面的Excel數據管理中非常有價值。
我可以將命名表格整合到IronXL的其他特性中嗎?
是的,命名表格可整合到IronXL的其他特性中。您可以將它們與公式結合進行動態計算、作為創建圖表的數據來源,或在匯出為不同格式之前作為有組織的數據結構。
如何在IronXL中在命名表格中包括公式?
在使用IronXL添加命名表格時,您可以包含具有公式的欄。例如,您可以根據其他欄的值計算每列的總計,然後在數據列下方添加總合計公式以進行全面的數據分析。
我可以去哪裡學習有關使用IronXL添加命名範圍的更多資訊?
您可以訪問IronXL的文件頁面了解有關添加命名範圍的更多資訊。此部分提供有關在Excel工作簿中以程式方式建立和管理命名範圍的洞察。
Curtis Chau 擁有卡爾頓大學計算機科學學士學位,專注於前端開發,擅長於 Node.js、TypeScript、JavaScript 和 React。Curtis 熱衷於創建直觀且美觀的用戶界面,喜歡使用現代框架並打造結構良好、視覺吸引人的手冊。