int main() {
lxw_workbook *workbook = workbook_new("defined_name.xlsx");
lxw_worksheet *worksheet;
/* We don't use the returned worksheets in this example and use a generic
* loop instead. */
workbook_add_worksheet(workbook, NULL);
workbook_add_worksheet(workbook, NULL);
/* Define some global/workbook names. */
workbook_define_name(workbook, "Sales", "=!G1:H10");
workbook_define_name(workbook, "Exchange_rate", "=0.96");
workbook_define_name(workbook, "Sales", "=Sheet1!$G$1:$H$10");
/* Define a local/worksheet name. */
workbook_define_name(workbook, "Sheet2!Sales", "=Sheet2!$G$1:$G$10");
/* Write some text to the worksheets and one of the defined name in a formula. */
LXW_FOREACH_WORKSHEET(worksheet, workbook){
worksheet_set_column(worksheet, 0, 0, 45, NULL);
worksheet_write_string(worksheet, 0, 0,
"This worksheet contains some defined names.", NULL);
worksheet_write_string(worksheet, 1, 0,
"See Formulas -> Name Manager above.", NULL);
worksheet_write_string(worksheet, 2, 0,
"Example formula in cell B3 ->", NULL);
worksheet_write_formula(worksheet, 2, 1, "=Exchange_rate", NULL);
}
int main() {
/* Create a workbook and add a worksheet. */
lxw_workbook *workbook = new_workbook("tutorial01.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
/* Start from the first cell. Rows and columns are zero indexed. */
int row = 0;
int col = 0;
/* Iterate over the data and write it out element by element. */
for (row = 0; row < 4; row++) {
worksheet_write_string(worksheet, row, col, expenses[row].item, NULL);
worksheet_write_number(worksheet, row, col + 1, expenses[row].cost, NULL);
}
/* Write a total using a formula. */
worksheet_write_string (worksheet, row, col, "Total", NULL);
worksheet_write_formula(worksheet, row, col + 1, "=SUM(B1:B4)", NULL);
/* Save the workbook and free any allocated memory. */
return workbook_close(workbook);
}
