doc_properties/
doc_properties.rs

1use edit_xlsx::{WorkSheetCol, Properties, Workbook, WorkbookResult, Write};
2
3fn main() -> WorkbookResult<()> {
4    // Create a new workbook
5    let mut workbook = Workbook::new();
6    let mut properties = Properties::default();
7    properties.set_title("This is an example spreadsheet")
8        .set_subject("With document properties")
9        .set_author("pt")
10        .set_manager("example manager")
11        .set_company("example company")
12        .set_category("Example spreadsheets")
13        .set_keywords("Sample, Example, Properties")
14        .set_comments("Created with Rust")
15        .set_status("example status");
16    workbook.set_properties(&properties)?;
17    // Use the default worksheet
18    let worksheet = workbook.get_worksheet_mut(1)?;
19    worksheet.set_columns_width("A:A", 70.0)?;
20    worksheet.write("A1", "Select 'Workbook Properties' to see properties.")?;
21    workbook.save_as("examples/doc_properties.xlsx")?;
22    Ok(())
23}