int main() {
lxw_row_t row;
lxw_col_t col;
lxw_row_t max_row = 1000;
lxw_col_t max_col = 50;
// 1
lxw_workbook *workbook;
lxw_worksheet *worksheet;
/* Set the worksheet options. */
lxw_workbook_options options;
options.constant_memory = 1;
/* Create a new workbook with options. */
// 1
workbook = workbook_new_opt("constant_memory.xlsx", &options);
worksheet = workbook_add_worksheet(workbook, NULL);
for (row = 0; row < max_row; row++) {
for (col = 0; col < max_col; col++) {
worksheet_write_number(worksheet, row, col, 123.45, NULL);
}
}
return workbook_close(workbook);
}
int main() {
lxw_workbook_options options = {LXW_FALSE, "."};
lxw_workbook *workbook = workbook_new_opt("test_tmpdir01.xlsx", &options);
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_write_string(worksheet, 0, 0, "Hello", NULL);
worksheet_write_number(worksheet, 1, 0, 123, NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook_options options = {1, NULL};
lxw_workbook *workbook = workbook_new_opt("test_optimize23.xlsx", &options);
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_format *bold = workbook_add_format(workbook);
format_set_bold(bold);
worksheet_set_row(worksheet, 0, 20, bold);
return workbook_close(workbook);
}
int main() {
lxw_workbook_options options = {1, NULL};
lxw_workbook *workbook = workbook_new_opt("test_optimize21.xlsx", &options);
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_write_string(worksheet, CELL("A1"), "Foo", NULL);
worksheet_write_string(worksheet, CELL("C3"), " Foo", NULL);
worksheet_write_string(worksheet, CELL("E5"), "Foo ", NULL);
worksheet_write_string(worksheet, CELL("A7"), "\tFoo\t", NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook_options options = {1};
lxw_workbook *workbook = workbook_new_opt("test_optimize01.xlsx", &options);
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_write_string(worksheet, 0, 0, "Hello", NULL);
/* For testing overwrite the 0, 0 cell to ensure the original is freed. */
worksheet_write_string(worksheet, 0, 0, "Hello", NULL);
worksheet_write_number(worksheet, 1, 0, 123, NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook_options options = {1, NULL};
lxw_workbook *workbook = workbook_new_opt("test_optimize02.xlsx", &options);
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_write_string(worksheet, 0, 0, "Hello", NULL);
worksheet_write_number(worksheet, 1, 0, 123, NULL);
/* G1 should be ignored since a later row has already been written. */
worksheet_write_string(worksheet, CELL("G1"), "World", NULL);
return workbook_close(workbook);
}
