Edit Excel Metadata from Python

VB C#

from ironxl import *

# Load the Excel 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
creation_date = workbook.Metadata.Created

# Read the last printed date of the Excel file
print_date = workbook.Metadata.LastPrinted

# Save the workbook with edited metadata
workbook.SaveAs("editedMetadata.xlsx")

Edit Excel Metadata from Python

Editing Excel metadata programmatically with IronXL for Python allows developers to update workbook properties—such as author, title, subject, or custom metadata fields—without manual interaction. This is particularly useful in automated workflows, large-scale data processing, or integration scenarios where metadata-driven solutions are required.

IronXL makes this process efficient by supporting popular Excel formats including XLSX, XLS, and CSV. This functionality minimizes manual effort and ensures accuracy for teams handling reporting, auditing, or metadata-driven applications. It simplifies the connection between Excel files and backend systems, enabling dynamic metadata updates that scale effectively in real-world Python environments.