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-driven applications. It simplifies the integration between Excel files and backend systems, enabling dynamic, metadata-centric solutions that scale effectively in real-world enterprise environments.

Below demonstrates how to modify the metadata of an Excel file using IronXL in C#:

// Load the Excel file into a WorkBook object
var workBook = WorkBook.Load("sample.xlsx");

// Update the Title metadata property
workBook.Metadata.Title = "Updated Title";

// Update the Author metadata property
workBook.Metadata.Author = "John Doe";

// Update the Subject metadata property
workBook.Metadata.Subject = "Financial Report";

// Save the modified workbook with updated metadata to a new file
workBook.SaveAs("UpdatedSample.xlsx");

// Load the Excel file into a WorkBook object
var workBook = WorkBook.Load("sample.xlsx");

// Update the Title metadata property
workBook.Metadata.Title = "Updated Title";

// Update the Author metadata property
workBook.Metadata.Author = "John Doe";

// Update the Subject metadata property
workBook.Metadata.Subject = "Financial Report";

// Save the modified workbook with updated metadata to a new file
workBook.SaveAs("UpdatedSample.xlsx");

' Load the Excel file into a WorkBook object
Dim workBook = WorkBook.Load("sample.xlsx")

' Update the Title metadata property
workBook.Metadata.Title = "Updated Title"

' Update the Author metadata property
workBook.Metadata.Author = "John Doe"

' Update the Subject metadata property
workBook.Metadata.Subject = "Financial Report"

' Save the modified workbook with updated metadata to a new file
workBook.SaveAs("UpdatedSample.xlsx")

The above code demonstrates how to modify the metadata of an Excel file using IronXL in C#. The first step involves loading the Excel file sample.xlsx into a WorkBook object using the WorkBook.Load method. This allows access to the workbook’s metadata, which can include properties such as the title, author, and subject. These properties are typically used for organizing and categorizing files, and they can be modified programmatically to reflect updated or relevant information.

Once the workbook is loaded, the Metadata property of the WorkBook object is accessed to update specific metadata fields like Title, Author, and Subject. After making the desired changes, the SaveAs method is used to save the modified workbook as a new file, UpdatedSample.xlsx, ensuring that the updated metadata is preserved. This method allows developers to automate the process of editing and saving metadata for multiple Excel files, which is particularly useful in data processing and reporting workflows.

Click here to view the How-to Guide, including examples, sample code, and files