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_autofilter01.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); uint16_t i; struct row { char region[16]; char item[16]; int volume; char month[16]; }; struct row data[] = { {"East", "Apple", 9000, "July" }, {"East", "Apple", 5000, "July" }, {"South", "Orange", 9000, "September" }, {"North", "Apple", 2000, "November" }, {"West", "Apple", 9000, "November" }, {"South", "Pear", 7000, "October" }, {"North", "Pear", 9000, "August" }, {"West", "Orange", 1000, "December" }, {"West", "Grape", 1000, "November" }, {"South", "Pear", 10000, "April" }, {"West", "Grape", 6000, "January" }, {"South", "Orange", 3000, "May" }, {"North", "Apple", 3000, "December" }, {"South", "Apple", 7000, "February" }, {"West", "Grape", 1000, "December" }, {"East", "Grape", 8000, "February" }, {"South", "Grape", 10000, "June" }, {"West", "Pear", 7000, "December" }, {"South", "Apple", 2000, "October" }, {"East", "Grape", 7000, "December" }, {"North", "Grape", 6000, "April" }, {"East", "Pear", 8000, "February" }, {"North", "Apple", 7000, "August" }, {"North", "Orange", 7000, "July" }, {"North", "Apple", 6000, "June" }, {"South", "Grape", 8000, "September" }, {"West", "Apple", 3000, "October" }, {"South", "Orange", 10000, "November" }, {"West", "Grape", 4000, "July" }, {"North", "Orange", 5000, "August" }, {"East", "Orange", 1000, "November" }, {"East", "Orange", 4000, "October" }, {"North", "Grape", 5000, "August" }, {"East", "Apple", 1000, "December" }, {"South", "Apple", 10000, "March" }, {"East", "Grape", 7000, "October" }, {"West", "Grape", 1000, "September" }, {"East", "Grape", 10000, "October" }, {"South", "Orange", 8000, "March" }, {"North", "Apple", 4000, "July" }, {"South", "Orange", 5000, "July" }, {"West", "Apple", 4000, "June" }, {"East", "Apple", 5000, "April" }, {"North", "Pear", 3000, "August" }, {"East", "Grape", 9000, "November" }, {"North", "Orange", 8000, "October" }, {"East", "Apple", 10000, "June" }, {"South", "Pear", 1000, "December" }, {"North", "Grape", 10000, "July" }, {"East", "Grape", 6000, "February" } }; /* Write the column headers. */ worksheet_write_string(worksheet, 0, 0, "Region", NULL); worksheet_write_string(worksheet, 0, 1, "Item", NULL); worksheet_write_string(worksheet, 0, 2, "Volume" , NULL); worksheet_write_string(worksheet, 0, 3, "Month", NULL); /* Write the row data. */ for (i = 0; i < sizeof(data)/sizeof(struct row); i++) { worksheet_write_string(worksheet, i + 1, 0, data[i].region, NULL); worksheet_write_string(worksheet, i + 1, 1, data[i].item, NULL); worksheet_write_number(worksheet, i + 1, 2, data[i].volume , NULL); worksheet_write_string(worksheet, i + 1, 3, data[i].month, NULL); } worksheet_autofilter(worksheet, 0, 0, 50, 3); return workbook_close(workbook); }