Edit Excel Metadata in C#

VB C#

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

Private 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")

Install-Package IronXL.Excel

Edit Excel Metadata in C#

The code example above shows how meta-data of Excel file can be set, modified, and retrieve using IronXL C# library. To add custom author name to spreadsheet file assign the name to Author property. For example, workBook.Metadata.Author = "Your Name". The meta-data properties available in Metadata property of WorkBook can be accessed and retrieved.

The properties below are available:

Set, modified, and retrieve granular meta-data such as:
- Author
- Comments
- LastPrinted
- Keywords and Category
- Created and ModifiedDate
- Subject and Title
Retrieve granular meta-data such as:
- ApplicationName
- CustomProperties
- Company
- Manager
- Template