Edit Excel Metadata in C#

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

Edit Excel Metadata in C#

Editing Excel metadata programmatically using C# and IronXL allows developers to seamlessly update or manipulate workbook properties, such as author, title, subject, or custom metadata fields, without manual interaction. This feature is particularly beneficial in scenarios involving automated workflows, large-scale data processing, or integration with other systems, such as SQL databases.

IronXL makes this process efficient by supporting popular Excel formats like XLSX, XLS, and CSV. This functionality minimizes manual effort and ensures accuracy for teams dealing with reporting, auditing, or metadata-centric applications. It simplifies the integration between Excel files and backend systems, enabling dynamic, metadata-centric solutions that scale effectively in real-world enterprise environments.