simple_batch_writer/
simple_batch_writer.rs

1
2#[cfg(feature = "xlsxwriter")]
3use xlsx_batch_reader::{get_num_from_ord, read::XlsxBook, write::XlsxWriter};
4
5#[cfg(feature = "xlsxwriter")]
6fn main() -> Result<(), Box<dyn std::error::Error>> {
7    let mut writer = XlsxWriter::new();
8    let mut book = XlsxBook::new("xlsx/test.xlsx", true)?;
9    for shname in book.get_visible_sheets().clone() {
10        // left_ncol should not be 0
11        // each row will have 3 cells.
12        let mut sheet = book.get_sheet_by_name(&shname, 100, 0, 1, get_num_from_ord("C".as_bytes())?, true)?;
13
14        // the sheet name will be write at the begin of each row
15        let pre_cells = vec![shname];
16        if let Some((rows_nums, rows_data)) = sheet.get_remaining_cells()? {
17            // write all data
18            // writer.append_rows("sheet", rows_nums, rows_data, &pre_cells)?;
19            // if you don't want row numbers to be writed before data, set nrows = vec![];
20
21            // write by row
22            for (row_num, row_data) in rows_nums.into_iter().zip(rows_data) {
23                writer.append_row("sheet", Some(&row_num), row_data, &pre_cells)?;
24            }
25        }; 
26    };
27    writer.save_as("xlsx/out.xlsx")?;
28    Ok(())
29}
30
31#[cfg(not(feature = "xlsxwriter"))]
32fn main() {
33    println!("Please enable the feature 'rust_xlsxwriter' to run this example.");
34}
35
36// cargo run --example merged_range --features xlsxwriter
simple_batch_writer/simple_batch_writer.rs

simple_batch_writer/
simple_batch_writer.rs
