Edit Excel Metadata in C#
Read and Write Excel file metadata in C# including:
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()
