using C# 編輯 Excel 元資料

VBC#

using IronXL;
using System;

WorkBook workBook = WorkBook.Load("sample.xlsx");

// Set author
workBook.Metadata.Author = "Your Name";
// Set comments
workBook.Metadata.Comments = "Monthly report";
// Set title
workBook.Metadata.Title = "July";
// Set keywords
workBook.Metadata.Keywords = "Report";

// Read the creation date of the excel file
DateTime? creationDate = workBook.Metadata.Created;

// Read the last printed date of the excel file
DateTime? printDate = workBook.Metadata.LastPrinted;

workBook.SaveAs("editedMetadata.xlsx");

Imports IronXL
Imports System

Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")

' Set author
workBook.Metadata.Author = "Your Name"
' Set comments
workBook.Metadata.Comments = "Monthly report"
' Set title
workBook.Metadata.Title = "July"
' Set keywords
workBook.Metadata.Keywords = "Report"

' Read the creation date of the excel file
Dim creationDate As DateTime? = workBook.Metadata.Created

' Read the last printed date of the excel file
Dim printDate As DateTime? = workBook.Metadata.LastPrinted

workBook.SaveAs("editedMetadata.xlsx")

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

using C# 編輯 Excel 元資料

以程式方式使用IronXL編輯Excel中繼資料允許開發人員無縫更新或操作工作簿屬性，例如作者、標題、主題或自定義中繼資料欄位，無需手動互動。此功能在涉及自動化工作流程、大規模資料處理或與其他系統（如SQL資料庫）的整合情境中特別有益。

IronXL通過支援流行的Excel格式如CSV來使此過程更高效。此功能可最大限度減少手動工作並確保準確性，特別適用於處理報告、審計或以中繼資料為中心的應用程式的團隊。它簡化了Excel檔案和後端系統之間的整合，使元資料為中心的動態解決方案能夠有效擴展於真實世界的企業環境中。

在C#中編輯Excel中繼資料的5個步驟

var workBook = WorkBook.Load("sample.xlsx");

workBook.Metadata.Title = "Updated Title";

workBook.Metadata.Author = "John Doe";

workBook.Metadata.Subject = "Financial Report";

workBook.SaveAs("UpdatedSample.xlsx");

Explore How to Edit Workbook Metadata with IronXL

在GitHub上查看

準備好開始了嗎？

Nuget Downloads 2,237,574|版本：2026.9剛剛發布

免費 NuGet 下載

總下載次數：2,237,574