在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

在C#中编辑Excel元数据

通过使用IronXL以编程方式编辑Excel元数据，开发者可以无缝地更新或操作工作簿属性，如作者、标题、主题或自定义元数据字段，而无需手动交互。此功能在涉及自动化工作流程、大规模数据处理或与其他系统（如 SQL 数据库）集成的场景中尤其有用。

IronXL通过支持CSV等流行的Excel格式来使这个过程高效。此功能最大限度地减少了手动工作并确保处理报告、审计或以元数据为中心的应用程序的团队的准确性。它简化了 Excel 文件与后端系统之间的集成，从而实现了动态的、以元数据为中心的解决方案，能够在真实的企业环境中有效扩展。

5 个步骤教你如何在 C# 中编辑 Excel 元数据

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

workBook.Metadata.Title = "更新的标题";

workBook.Metadata.Author="John Doe";

workBook.Metadata.Subject = "财务报告";

workBook.SaveAs("UpdatedSample.xlsx");

Explore How to Edit Workbook Metadata with IronXL

在 GitHub 上查看

准备开始了吗？

Nuget Downloads 2,237,574|版本:2026.9刚刚发布

免费 NuGet 下载

总下载量：2,237,574

查看许可证