Edit Excel Metadata in C#

VB C#

using IronXL;

WorkBook workbook = WorkBook.Load("test.xlsx");


//This is how we set  the author of the file
workbook.Metadata.Author = "Your Name";
//This is how we set the comments to the file
workbook.Metadata.Comments = "Monthly report";


//This is how we read the creation date of the excel file
DateTime? creationDate = workbook.Metadata.Created;

//This is how read the last printed date of the excel file
DateTime? printDate = workbook.Metadata.LastPrinted;

workbook.SaveAs();

Imports IronXL

Private workbook As WorkBook = WorkBook.Load("test.xlsx")


'This is how we set  the author of the file
workbook.Metadata.Author = "Your Name"
'This is how we set the comments to the file
workbook.Metadata.Comments = "Monthly report"


'This is how we read the creation date of the excel file
Dim creationDate? As DateTime = workbook.Metadata.Created

'This is how read the last printed date of the excel file
Dim printDate? As DateTime = workbook.Metadata.LastPrinted

workbook.SaveAs()

Install-Package IronXL.Excel

Edit Excel Metadata in C#

Read and Write Excel file metadata in C# including:

`ApplicationName` Gets the name of the application with which the file was created.

`Author` - Gets or sets the author of the file.

`Category` - Gets or sets the category of the file.

`Comments` - Gets or sets the comments field value.

`Company` - Gets the company field value.

`Created` - Gets or sets the creation time.

`CustomProperties` - Gets the custom properties of the workbook.

`Keywords` - Gets or sets the keywords field value.

`LastPrinted` - Gets or sets the last printed time.

`Manager` - Gets the manager field value.

`Modified` - Gets or sets the last modification time.

`Subject` - Gets or sets the subject of the file.

`Template` - Gets the template field value.

`Title` - Gets or sets the title of the file.

Previous Example

Next Example

Ready to get started? Version: 2022.6 just released

View Licenses >