excelwriter 0.1.0

A Rust module for writing files in the Excel 2007+ XLSX file format
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

// Test case that compares a file generated by excelwriter with a file
// created by Excel.
//
// SPDX-License-Identifier: MIT OR Apache-2.0 Copyright 2022, John McNamara,
// jmcnamara@cpan.org

use excelwriter::Workbook;

mod common;

// Test case to demonstrate creating a basic file with some string cell data.
fn create_new_xlsx_file(filename: &str) {
    let mut workbook = Workbook::new(filename);

    let worksheet1 = workbook.add_worksheet();

    worksheet1.write_string_only(0, 0, "Hello");
    worksheet1.write_string_only(1, 0, "World");
    worksheet1.write_string_only(2, 0, "Hello");
    worksheet1.write_string_only(3, 0, "World");

    let worksheet2 = workbook.add_worksheet();

    worksheet2.write_string_only(0, 0, "World");
    worksheet2.write_string_only(1, 0, "Hello");
    worksheet2.write_string_only(2, 0, "World");
    worksheet2.write_string_only(3, 0, "Hello");

    workbook.close();
}

#[test]
fn bootstrap08_write_repeated_strings_on_different_worksheets() {
    let testcase = "bootstrap08";

    let (excel_file, xlsxwriter_file) = common::get_xlsx_filenames(testcase);
    create_new_xlsx_file(&xlsxwriter_file);
    common::assert_eq(&excel_file, &xlsxwriter_file);
    common::remove_test_xlsx_file(&xlsxwriter_file);
}