Set Document Properties to a Workbook in C#

set-document-properties-to-a-workbook.cs

// Create a new workbook and set cell values and document properties.
using (var workbook = new Workbook())
{
    // Access the first worksheet.
    Worksheet firstSheet = workbook.Worksheets[0];
    
    // Set values for cells A1 and A2.
    Cell cellA1 = firstSheet.Cells["A1"];
    cellA1.PutValue("Text A1");

    Cell cellA2 = firstSheet.Cells["A2"];
    cellA2.PutValue("Text A2");
    
    // Configure document properties.
    var newProperties = new BuiltInDocumentProperties
    {
        Author = "Fahad Adeel",
        Title = "Sample Workbook",
        CreatedDate = DateTime.Now,
        ModifiedBy = "Fahad",
        ModifiedDate = DateTime.Now.AddHours(1),
        Subject = "Testing Subject"
    };

    // Assign the new properties to the workbook.
    workbook.BuiltinDocumentProperties = newProperties;

    // Save the workbook to the specified path.
    workbook.Save(filePath);
}