int main() {
lxw_workbook *workbook = workbook_new("test_defined_name01.xlsx");
lxw_worksheet *worksheet1 = workbook_add_worksheet(workbook, NULL);
lxw_worksheet *worksheet2 = workbook_add_worksheet(workbook, NULL);
lxw_worksheet *worksheet3 = workbook_add_worksheet(workbook, "Sheet 3");
worksheet_set_paper(worksheet1, 9);
worksheet1->vertical_dpi = 200;
worksheet_print_area(worksheet1, RANGE("A1:E6"));
worksheet_autofilter(worksheet1, RANGE("F1:G1"));
worksheet_write_string(worksheet1, CELL("G1"), "Filter", NULL);
worksheet_write_string(worksheet1, CELL("F1"), "Auto", NULL);
worksheet_fit_to_pages(worksheet1, 2, 2);
workbook_define_name(workbook, "'Sheet 3'!Bar", "='Sheet 3'!$A$1");
workbook_define_name(workbook, "Abc", "=Sheet1!$A$1");
workbook_define_name(workbook, "Baz", "=0.98");
workbook_define_name(workbook, "Sheet1!Bar", "=Sheet1!$A$1");
workbook_define_name(workbook, "Sheet2!Bar", "=Sheet2!$A$1");
workbook_define_name(workbook, "Sheet2!aaa", "=Sheet2!$A$1");
workbook_define_name(workbook, "_Egg", "=Sheet1!$A$1");
workbook_define_name(workbook, "_Fog", "=Sheet1!$A$1");
(void)worksheet2;
(void)worksheet3;
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = workbook_new("test_fit_to_pages05.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_fit_to_pages(worksheet, 1, 0);
worksheet_set_paper(worksheet, 9);
worksheet->vertical_dpi = 200;
worksheet_write_string(worksheet, CELL("A1"), "Foo" , NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_print_area05.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_set_paper(worksheet, 9);
worksheet->vertical_dpi = 200;
worksheet_print_area(worksheet, RANGE("A1:A1048576"));
worksheet_write_string(worksheet, CELL("A1"), "Foo" , NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_repeat04.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, "Sheet 1");
worksheet_set_paper(worksheet, 9);
worksheet->vertical_dpi = 200;
worksheet_repeat_rows(worksheet, 0, 0);
worksheet_write_string(worksheet, CELL("A1"), "Foo" , NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = workbook_new("test_print_options02.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_set_paper(worksheet, 9);
worksheet->vertical_dpi = 200;
worksheet_center_horizontally(worksheet);
worksheet_write_string(worksheet, CELL("A1"), "Foo" , NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = workbook_new("test_gridlines01.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_set_paper(worksheet, 9);
worksheet->vertical_dpi = 200;
worksheet_gridlines(worksheet, LXW_HIDE_ALL_GRIDLINES);
worksheet_write_string(worksheet, CELL("A1"), "Foo" , NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = workbook_new("test_print_options06.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_set_paper(worksheet, 9);
worksheet->vertical_dpi = 200;
worksheet_print_area(worksheet, RANGE("A1:G20"));
worksheet_repeat_rows(worksheet, 0, 0);
worksheet_write_string(worksheet, CELL("A1"), "Foo" , NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = workbook_new("test_page_breaks04.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_col_t breaks[] = {1, 0};
worksheet_set_paper(worksheet, 9);
worksheet->vertical_dpi = 200;
worksheet_set_v_pagebreaks(worksheet, breaks);
worksheet_write_string(worksheet, CELL("A1"), "Foo" , NULL);
return workbook_close(workbook);
}
/* Test the _write_page_setup() method. With set_paper(); */
CTEST(worksheet, write_page_setup04) {
char* got;
char exp[] = "<pageSetup paperSize=\"9\" orientation=\"portrait\"/>";
FILE* testfile = tmpfile();
lxw_worksheet *worksheet = lxw_worksheet_new(NULL);
worksheet->file = testfile;
worksheet_set_paper(worksheet, 9);
_worksheet_write_page_setup(worksheet);
RUN_XLSX_STREQ(exp, got);
lxw_worksheet_free(worksheet);
}
