hide_sheet/
hide_sheet.rs

1use edit_xlsx::{WorkSheetCol, Workbook, WorkbookResult, Write};
2
3fn main() -> WorkbookResult<()> {
4    // Create a new workbook
5    let mut workbook = Workbook::new();
6    let worksheet1 = workbook.get_worksheet_mut(1)?;
7
8    worksheet1.set_columns_width("A:A", 30.0)?;
9    worksheet1.write("A1", "Sheet2 is hidden")?;
10
11    // Hide Sheet2. It won't be visible until it is unhidden in Excel.
12    let worksheet2 = workbook.add_worksheet()?;
13    worksheet2.set_columns_width("A:A", 30.0)?;
14    // worksheet2.activate();
15    worksheet2.hide();
16    worksheet2.write("A1", "Now it's my turn to find you!")?;
17    // Note, you can't hide the "active" worksheet, which generally is the
18    // first worksheet, since this would cause an Excel error. So, in order to hide
19    // the first sheet you will need to activate another worksheet:
20    //
21    //    worksheet2.activate();
22    //    worksheet1.hide();
23
24    let worksheet3 = workbook.add_worksheet()?;
25    worksheet3.set_columns_width("A:A", 30.0)?;
26    worksheet3.write("A1", "Sheet2 is hidden")?;
27
28    workbook.save_as("examples/hide_sheet.xlsx")?;
29    Ok(())
30}
hide_sheet/hide_sheet.rs

hide_sheet/
hide_sheet.rs
