How to Edit Workbook Metadata

using IronXL;
using System;

// Load the Excel workbook from a file
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Check if the workbook is loaded successfully
if (workBook == null)
{
    Console.WriteLine("Failed to load the workbook.");
    return;
}

// Set metadata properties for the workbook
workBook.Metadata.Author = "Your Name"; // Specify the author of the document
workBook.Metadata.Comments = "Monthly report"; // Add comments to describe the document
workBook.Metadata.Title = "July"; // Set the title of the document
workBook.Metadata.Keywords = "Report"; // Add keywords for better searching

// Read the creation date of the Excel file
DateTime? creationDate = workBook.Metadata.Created;

// Optional: Output the creation date to the console for verification
if (creationDate.HasValue)
{
    Console.WriteLine($"File creation date: {creationDate.Value}");
}
else
{
    Console.WriteLine("Creation date is not available.");
}

// Read the last printed date of the Excel file
DateTime? printDate = workBook.Metadata.LastPrinted;

// Optional: Output the last printed date to the console for verification
if (printDate.HasValue)
{
    Console.WriteLine($"File last printed date: {printDate.Value}");
}
else
{
    Console.WriteLine("Last printed date is not available.");
}

// Save the workbook with the new metadata
try
{
    workBook.SaveAs("editedMetadata.xlsx");
    Console.WriteLine("Workbook saved successfully with updated metadata.");
}
catch (Exception ex)
{
    Console.WriteLine($"Failed to save the workbook. Error: {ex.Message}");
}

Imports IronXL

Imports System



' Load the Excel workbook from a file

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")



' Check if the workbook is loaded successfully

If workBook Is Nothing Then

	Console.WriteLine("Failed to load the workbook.")

	Return

End If



' Set metadata properties for the workbook

workBook.Metadata.Author = "Your Name" ' Specify the author of the document

workBook.Metadata.Comments = "Monthly report" ' Add comments to describe the document

workBook.Metadata.Title = "July" ' Set the title of the document

workBook.Metadata.Keywords = "Report" ' Add keywords for better searching



' Read the creation date of the Excel file

Dim creationDate? As DateTime = workBook.Metadata.Created



' Optional: Output the creation date to the console for verification

If creationDate.HasValue Then

	Console.WriteLine($"File creation date: {creationDate.Value}")

Else

	Console.WriteLine("Creation date is not available.")

End If



' Read the last printed date of the Excel file

Dim printDate? As DateTime = workBook.Metadata.LastPrinted



' Optional: Output the last printed date to the console for verification

If printDate.HasValue Then

	Console.WriteLine($"File last printed date: {printDate.Value}")

Else

	Console.WriteLine("Last printed date is not available.")

End If



' Save the workbook with the new metadata

Try

	workBook.SaveAs("editedMetadata.xlsx")

	Console.WriteLine("Workbook saved successfully with updated metadata.")

Catch ex As Exception

	Console.WriteLine($"Failed to save the workbook. Error: {ex.Message}")

End Try