How to Edit Excel Workbook Metadata in C#

Updated: August 2, 2026

Edit Excel metadata in C# using IronXL's Metadata property to programmatically set author, title, keywords, and other document properties without Microsoft Interop, enabling automated spreadsheet organization and searchability.

Metadata for an Excel spreadsheet includes information about the title, author, subject, keywords, creation date, modification date, and other relevant details. Metadata provides context and helps in organizing and categorizing spreadsheets. It simplifies file search and management, especially when working with multiple spreadsheet files. Whether you're creating new spreadsheets or loading existing workbooks, IronXL makes metadata management seamless.

Quickstart: Edit workbook metadata in one easy step

Set, modify, and save properties like Title, Author, or Keywords using IronXL's Metadata interface. No need for Interop - get started instantly with just a few lines of clean, intuitive C# code.

1Install IronXL with NuGet Package Manager
PM > Install-Package IronXL.Excel
```
Install-Package IronXL.Excel
```

2Copy and run this code snippet.

WorkBook workBook = WorkBook.Load("input.xlsx");
workBook.Metadata.Title = "Financial Summary";
// Then save your update to a new file
workBook.SaveAs("output.xlsx");

WorkBook workBook = WorkBook.Load("input.xlsx");
workBook.Metadata.Title = "Financial Summary";
// Then save your update to a new file
workBook.SaveAs("output.xlsx");

3Deploy to test on your live environment

Start using IronXL in your project today with a free trial

Minimal Workflow (5 steps)

Download the C# library to edit workbook metadata
Load an existing spreadsheet or create a brand new one
Access and modify the metadata information using the Metadata property
View and modify the spreadsheet data
Export the spreadsheet with the edited metadata properties

How Do I Edit Workbook Metadata Properties?

To edit the author name of a spreadsheet file, set the Author property with the desired string of data. For example, workBook.Metadata.Author = "Your Name". The metadata information available in the Metadata property of WorkBook class can be accessed and retrieved. This approach works seamlessly with various spreadsheet file types including XLSX, XLS, and CSV formats.

Which Properties Can I Modify Programmatically?

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

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

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

For more complex scenarios, you can combine metadata editing with other Excel operations. Here's a comprehensive example that demonstrates batch processing of multiple Excel files:

using IronXL;
using System;
using System.IO;

public class BatchMetadataProcessor
{
    public static void ProcessFinancialReports(string folderPath)
    {
        // Get all Excel files in the directory
        string[] excelFiles = Directory.GetFiles(folderPath, "*.xlsx");
        
        foreach (string filePath in excelFiles)
        {
            // Load the workbook
            WorkBook workBook = WorkBook.Load(filePath);
            
            // Update metadata based on file content
            string fileName = Path.GetFileNameWithoutExtension(filePath);
            
            // Set consistent metadata across all reports
            workBook.Metadata.Author = "Finance Department";
            workBook.Metadata.Company = "Your Company Name";
            workBook.Metadata.Category = "Financial Reports";
            
            // Set dynamic metadata based on filename
            if (fileName.Contains("Q1"))
            {
                workBook.Metadata.Title = "Q1 Financial Report";
                workBook.Metadata.Keywords = "Q1, Finance, Quarterly";
            }
            else if (fileName.Contains("Q2"))
            {
                workBook.Metadata.Title = "Q2 Financial Report";
                workBook.Metadata.Keywords = "Q2, Finance, Quarterly";
            }
            
            // Add timestamp to comments
            workBook.Metadata.Comments = $"Processed on {DateTime.Now:yyyy-MM-dd HH:mm}";
            
            // Set the subject based on worksheet content
            WorkSheet sheet = workBook.DefaultWorkSheet;
            workBook.Metadata.Subject = $"Report containing {sheet.RowCount} data rows";
            
            // Save with updated metadata
            string outputPath = Path.Combine(folderPath, "processed", fileName + "_updated.xlsx");
            workBook.SaveAs(outputPath);
        }
    }
}

using IronXL;
using System;
using System.IO;

public class BatchMetadataProcessor
{
    public static void ProcessFinancialReports(string folderPath)
    {
        // Get all Excel files in the directory
        string[] excelFiles = Directory.GetFiles(folderPath, "*.xlsx");
        
        foreach (string filePath in excelFiles)
        {
            // Load the workbook
            WorkBook workBook = WorkBook.Load(filePath);
            
            // Update metadata based on file content
            string fileName = Path.GetFileNameWithoutExtension(filePath);
            
            // Set consistent metadata across all reports
            workBook.Metadata.Author = "Finance Department";
            workBook.Metadata.Company = "Your Company Name";
            workBook.Metadata.Category = "Financial Reports";
            
            // Set dynamic metadata based on filename
            if (fileName.Contains("Q1"))
            {
                workBook.Metadata.Title = "Q1 Financial Report";
                workBook.Metadata.Keywords = "Q1, Finance, Quarterly";
            }
            else if (fileName.Contains("Q2"))
            {
                workBook.Metadata.Title = "Q2 Financial Report";
                workBook.Metadata.Keywords = "Q2, Finance, Quarterly";
            }
            
            // Add timestamp to comments
            workBook.Metadata.Comments = $"Processed on {DateTime.Now:yyyy-MM-dd HH:mm}";
            
            // Set the subject based on worksheet content
            WorkSheet sheet = workBook.DefaultWorkSheet;
            workBook.Metadata.Subject = $"Report containing {sheet.RowCount} data rows";
            
            // Save with updated metadata
            string outputPath = Path.Combine(folderPath, "processed", fileName + "_updated.xlsx");
            workBook.SaveAs(outputPath);
        }
    }
}

Imports IronXL
Imports System
Imports System.IO

Public Class BatchMetadataProcessor
    Public Shared Sub ProcessFinancialReports(folderPath As String)
        ' Get all Excel files in the directory
        Dim excelFiles As String() = Directory.GetFiles(folderPath, "*.xlsx")
        
        For Each filePath As String In excelFiles
            ' Load the workbook
            Dim workBook As WorkBook = WorkBook.Load(filePath)
            
            ' Update metadata based on file content
            Dim fileName As String = Path.GetFileNameWithoutExtension(filePath)
            
            ' Set consistent metadata across all reports
            workBook.Metadata.Author = "Finance Department"
            workBook.Metadata.Company = "Your Company Name"
            workBook.Metadata.Category = "Financial Reports"
            
            ' Set dynamic metadata based on filename
            If fileName.Contains("Q1") Then
                workBook.Metadata.Title = "Q1 Financial Report"
                workBook.Metadata.Keywords = "Q1, Finance, Quarterly"
            ElseIf fileName.Contains("Q2") Then
                workBook.Metadata.Title = "Q2 Financial Report"
                workBook.Metadata.Keywords = "Q2, Finance, Quarterly"
            End If
            
            ' Add timestamp to comments
            workBook.Metadata.Comments = $"Processed on {DateTime.Now:yyyy-MM-dd HH:mm}"
            
            ' Set the subject based on worksheet content
            Dim sheet As WorkSheet = workBook.DefaultWorkSheet
            workBook.Metadata.Subject = $"Report containing {sheet.RowCount} data rows"
            
            ' Save with updated metadata
            Dim outputPath As String = Path.Combine(folderPath, "processed", fileName & "_updated.xlsx")
            workBook.SaveAs(outputPath)
        Next
    End Sub
End Class

Imports IronXL
Imports System
Imports System.IO

Public Class BatchMetadataProcessor
    Public Shared Sub ProcessFinancialReports(folderPath As String)
        ' Get all Excel files in the directory
        Dim excelFiles As String() = Directory.GetFiles(folderPath, "*.xlsx")
        
        For Each filePath As String In excelFiles
            ' Load the workbook
            Dim workBook As WorkBook = WorkBook.Load(filePath)
            
            ' Update metadata based on file content
            Dim fileName As String = Path.GetFileNameWithoutExtension(filePath)
            
            ' Set consistent metadata across all reports
            workBook.Metadata.Author = "Finance Department"
            workBook.Metadata.Company = "Your Company Name"
            workBook.Metadata.Category = "Financial Reports"
            
            ' Set dynamic metadata based on filename
            If fileName.Contains("Q1") Then
                workBook.Metadata.Title = "Q1 Financial Report"
                workBook.Metadata.Keywords = "Q1, Finance, Quarterly"
            ElseIf fileName.Contains("Q2") Then
                workBook.Metadata.Title = "Q2 Financial Report"
                workBook.Metadata.Keywords = "Q2, Finance, Quarterly"
            End If
            
            ' Add timestamp to comments
            workBook.Metadata.Comments = $"Processed on {DateTime.Now:yyyy-MM-dd HH:mm}"
            
            ' Set the subject based on worksheet content
            Dim sheet As WorkSheet = workBook.DefaultWorkSheet
            workBook.Metadata.Subject = $"Report containing {sheet.RowCount} data rows"
            
            ' Save with updated metadata
            Dim outputPath As String = Path.Combine(folderPath, "processed", fileName & "_updated.xlsx")
            workBook.SaveAs(outputPath)
        Next
    End Sub
End Class

What Happens to Existing Metadata When I Save?

When you save or export Excel files using IronXL, any metadata properties you haven't explicitly modified retain their original values. Only the properties you've changed will be updated in the saved file. This selective update approach ensures that valuable existing metadata isn't accidentally lost during processing. The image below shows how metadata appears in Excel's document properties panel after being edited with IronXL:

Excel document properties panel showing edited metadata fields including Author, Title, Subject, and Keywords after modification with IronXL

If you need to clear existing metadata before setting new values, simply assign empty strings or null values to the properties you want to reset. This is particularly useful when preparing documents for external distribution where you want to remove internal company information.

What Metadata Fields Are Available in IronXL?

Not all metadata properties can be edited. Some properties can only be retrieved. Understanding which properties support different operations is crucial for effective metadata management. When working with password-protected workbooks, metadata can still be accessed and modified after the workbook is successfully decrypted.

Which Properties Support Read and Write Operations?

Property	Description	Operations	Common Use Cases
`Author`	Document creator name	Set, Modify, Retrieve	Tracking document ownership, compliance
`Comments`	Additional notes about the document	Set, Modify, Retrieve	Version notes, processing instructions
`LastPrinted`	Date/time of last print operation	Set, Modify, Retrieve	Print history tracking, audit trails
`Keywords`	Searchable keywords	Set, Modify, Retrieve	Document categorization, search optimization
`Category`	Document category classification	Set, Modify, Retrieve	File organization, departmental sorting
`Created`	Document creation date	Set, Modify, Retrieve	Document age tracking, archival decisions
`Modified`	Last modification date	Set, Modify, Retrieve	Change tracking, version control
`Subject`	Document subject description	Set, Modify, Retrieve	Content summarization, quick identification
`Title`	Document title	Set, Modify, Retrieve	Document identification, reporting

Which Properties Are Read-Only?

Property	Description	Typical Values
`ApplicationName`	Name of the application that created the file	"Microsoft Excel", "IronXL"
`CustomProperties`	User-defined custom properties	Varies by document
`Company`	Company name associated with the document	Organization name from system
`Manager`	Manager name from document properties	Retrieved from original file
`Template`	Template used to create the document	Template filename or "Normal"

For advanced metadata operations and complete API documentation, refer to the IronXL API Reference. If you encounter any issues with metadata handling, consult our troubleshooting guides or explore licensing options for production deployments.

Frequently Asked Questions

How can I edit metadata of an Excel workbook using C#?

You can edit the metadata of an Excel workbook in C# using IronXL's `Metadata` property. This allows you to set properties such as `author`, `title`, and `keywords` programmatically without needing Microsoft Interop.

What metadata properties can be modified with IronXL?

With IronXL, you can modify several metadata properties like `Author`, `Title`, `Keywords`, `Comments`, `Category`, `Created`, `Modified`, `Subject`, and `LastPrinted`. These provide valuable information to help organize and categorize spreadsheets.

Is it possible to modify metadata without changing other properties in the spreadsheet?

Yes, when modifying metadata with IronXL, only the properties you explicitly change are updated. All other properties retain their original values, ensuring valuable information isn't accidentally lost during processing.

Can IronXL handle metadata for multiple spreadsheet formats?

IronXL supports metadata handling for multiple spreadsheet formats, including `XLSX`, `XLS`, and `CSV`, making it versatile for different use cases and file types.

What are the steps to edit workbook metadata using IronXL?

To edit workbook metadata using IronXL, you need to load the workbook, access the `Metadata` property to set or modify values, and then save the updated workbook.

Do I need Microsoft Interop to modify Excel metadata with IronXL?

No, IronXL allows you to modify Excel metadata programmatically without requiring Microsoft Interop, simplifying the process with clean and intuitive C# code.

How does IronXL handle metadata for password-protected workbooks?

IronXL can access and modify metadata for password-protected workbooks once they are successfully decrypted, allowing secure handling while maintaining data privacy.

What happens if I want to clear existing metadata before saving?

To clear existing metadata before saving, you can assign empty strings or null values to the metadata properties you want to reset, which is useful for preparing documents for external distribution.

Can metadata be updated based on the dynamic content of a file?

Yes, IronXL allows you to set dynamic metadata based on file content or existing file properties, making it adaptable for batch processing or specific content conditions.

Are there any properties in IronXL that are read-only?

Yes, certain properties like `ApplicationName`, `CustomProperties`, `Company`, `Manager`, and `Template` are read-only and cannot be modified through IronXL.

Curtis Chau

Chat with engineering team now

Technical Writer

Curtis Chau holds a Bachelor’s degree in Computer Science (Carleton University) and specializes in front-end development with expertise in Node.js, TypeScript, JavaScript, and React. Passionate about crafting intuitive and aesthetically pleasing user interfaces, Curtis enjoys working with modern frameworks and creating well-structured, visually appealing manuals.

...