text_indent/
text_indent.rs

1use edit_xlsx::{WorkSheetCol, Format, FormatAlignType, Workbook, WorkbookResult, Write};
2
3fn main() -> WorkbookResult<()> {
4    // Create a new workbook
5    let mut workbook = Workbook::new();
6    let worksheet = workbook.get_worksheet_mut(1)?;
7
8    let indent1 = Format::default().set_indent(1);
9    let indent2 = Format::default().set_indent(2);
10
11    worksheet.set_columns_width("A:A", 40.0)?;
12
13    worksheet.write_with_format("A1", "This text is indented 1 level", &indent1)?;
14    worksheet.write_with_format("A2", "This text is indented 2 levels", &indent2)?;
15
16    // Note: Alignment is not applied correctly when changing the reading order, this bug will be fixed in the future!
17    // let indent = Format::default().set_reading_order(2).set_align(FormatAlignType::Right).set_indent(2);
18    // worksheet.right_to_left();
19
20    workbook.save_as("examples/text_indent.xlsx")?;
21    Ok(())
22}