int main() {
lxw_workbook *workbook = new_workbook("test_chart_axis29.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_LINE);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 45444480;
chart->axis_id_2 = 47402368;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_add_series(chart, NULL, "=Sheet1!$B$1:$B$5");
chart_add_series(chart, NULL, "=Sheet1!$C$1:$C$5");
lxw_chart_font font1 = {.rotation = -90, .baseline = -1};
chart_axis_set_num_font(chart->x_axis, &font1);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_format19.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_COLUMN_STACKED);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 56127488;
chart->axis_id_2 = 57455360;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_add_series(chart, NULL, "=Sheet1!$B$1:$B$5");
lxw_chart_series *series = chart_add_series(chart, NULL, "=Sheet1!$C$1:$C$5");
chart_series_set_labels(series);
chart_series_set_labels_position(series, LXW_CHART_LABEL_POSITION_INSIDE_BASE);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_data_labels13.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_PIE);
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
lxw_chart_series *series1 = chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_series_set_labels(series1);
chart_series_set_labels_position(series1, LXW_CHART_LABEL_POSITION_INSIDE_END);
chart_series_set_labels_leader_line(series1);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_doughnut02.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_DOUGHNUT);
uint8_t data[3][2] = {
{2, 60},
{4, 30},
{6, 10},
};
int row, col;
for (row = 0; row < 3; row++)
for (col = 0; col < 2; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart,
"=Sheet1!$A$1:$A$3",
"=Sheet1!$B$1:$B$3"
);
chart_set_hole_size(chart, 10);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_size01.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_COLUMN);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 61355904;
chart->axis_id_2 = 61365248;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_add_series(chart, NULL, "=Sheet1!$B$1:$B$5");
chart_add_series(chart, NULL, "=Sheet1!$C$1:$C$5");
lxw_image_options options = {.x_scale = 1.06666667, .y_scale = 1.11111112};
worksheet_insert_chart_opt(worksheet, CELL("E9"), chart, &options);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_bar02.xlsx");
lxw_worksheet *worksheet1 = workbook_add_worksheet(workbook, NULL);
lxw_worksheet *worksheet2 = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_BAR);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 93218304;
chart->axis_id_2 = 93219840;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet2, row, col, data[row][col] , NULL);
worksheet_write_string(worksheet1, CELL("A1"), "Foo" , NULL);
chart_add_series(chart, "Sheet2!$A$1:$A$5", "Sheet2!$B$1:$B$5");
chart_add_series(chart, "Sheet2!$A$1:$A$5", "Sheet2!$C$1:$C$5");
worksheet_insert_chart(worksheet2, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_axis25.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_COLUMN);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 47471232;
chart->axis_id_2 = 48509696;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_add_series(chart, NULL, "=Sheet1!$B$1:$B$5");
chart_add_series(chart, NULL, "=Sheet1!$C$1:$C$5");
chart_axis_set_num_format(chart->x_axis, "[$¥-411]#,##0.00");
chart_axis_set_num_format(chart->y_axis, "0.00%");
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_title01.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_COLUMN);
lxw_chart_series *series;
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 46165376;
chart->axis_id_2 = 54462720;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
series = chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_series_set_name(series, "Foo");
chart_title_off(chart);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_axis06.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_PIE);
uint8_t data[3][2] = {
{2, 60},
{4, 30},
{6, 10},
};
int row, col;
for (row = 0; row < 3; row++)
for (col = 0; col < 2; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart,
"=Sheet1!$A$1:$A$3",
"=Sheet1!$B$1:$B$3"
);
chart_title_set_name(chart, "Title");
/* Axis formatting should be igmored. */
chart_axis_set_name(chart->x_axis, "XXX");
chart_axis_set_name(chart->y_axis, "YYY");
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_display_units11.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_COLUMN);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 69559424;
chart->axis_id_2 = 69560960;
worksheet_write_number(worksheet, 0, 0, 10000000, NULL);
worksheet_write_number(worksheet, 1, 0, 20000000, NULL);
worksheet_write_number(worksheet, 2, 0, 30000000, NULL);
worksheet_write_number(worksheet, 3, 0, 20000000, NULL);
worksheet_write_number(worksheet, 4, 0, 10000000, NULL);
chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_axis_set_display_units(chart->y_axis, LXW_CHART_AXIS_UNITS_HUNDREDS);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_column05.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, "Foo");
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_COLUMN);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 47292800;
chart->axis_id_2 = 47295104;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col] , NULL);
chart_add_series(chart, NULL, "=Foo!$A$1:$A$5");
chart_add_series(chart, NULL, "=Foo!$B$1:$B$5");
chart_add_series(chart, NULL, "=Foo!$C$1:$C$5");
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_blank03.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_LINE);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 44253568;
chart->axis_id_2 = 44269952;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_add_series(chart, NULL, "=Sheet1!$B$1:$B$5");
chart_add_series(chart, NULL, "=Sheet1!$C$1:$C$5");
chart_show_blanks_as(chart, LXW_CHART_BLANKS_AS_CONNECTED);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_legend03.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_LINE);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 93548928;
chart->axis_id_2 = 93550464;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_add_series(chart, NULL, "=Sheet1!$B$1:$B$5");
chart_add_series(chart, NULL, "=Sheet1!$C$1:$C$5");
chart_legend_set_position(chart, LXW_CHART_LEGEND_TOP_RIGHT);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_format02.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_format *format1 = workbook_add_format(workbook);
lxw_format *format2 = workbook_add_format(workbook);
worksheet_set_row(worksheet, 0, 30, NULL, NULL);
format_set_font_name(format1, "Arial");
format_set_bold(format1);
format_set_align(format1, LXW_ALIGN_LEFT);
format_set_align(format1, LXW_ALIGN_VERTICAL_BOTTOM);
format_set_font_name(format2, "Arial");
format_set_bold(format2);
format_set_rotation(format2, 90);
format_set_align(format2, LXW_ALIGN_CENTER);
format_set_align(format2, LXW_ALIGN_VERTICAL_BOTTOM);
worksheet_write_string(worksheet, 0, 0, "Foo", format1);
worksheet_write_string(worksheet, 0, 1, "Bar", format2);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_hyperlink16.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_write_url(worksheet, CELL("B2"), "external:./subdir/blank.xlsx", NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_data07.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_write_formula_num(worksheet, 0, 0, "=1+2", NULL, 3);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_escapes04.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_write_url(worksheet, CELL("A1"), "http://www.perl.com/?a=1&b=2" , NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_bar22.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_BAR);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 43706240;
chart->axis_id_2 = 43727104;
worksheet_write_string(worksheet, 0, 1, "Series 1", NULL);
worksheet_write_string(worksheet, 0, 2, "Series 2", NULL);
worksheet_write_string(worksheet, 0, 3, "Series 3", NULL);
worksheet_write_string(worksheet, 1, 0, "Category 1", NULL);
worksheet_write_string(worksheet, 2, 0, "Category 2", NULL);
worksheet_write_string(worksheet, 3, 0, "Category 3", NULL);
worksheet_write_string(worksheet, 4, 0, "Category 4", NULL);
worksheet_write_number(worksheet, 1, 1, 4.3, NULL);
worksheet_write_number(worksheet, 2, 1, 2.5, NULL);
worksheet_write_number(worksheet, 3, 1, 3.5, NULL);
worksheet_write_number(worksheet, 4, 1, 4.5, NULL);
worksheet_write_number(worksheet, 1, 2, 2.4, NULL);
worksheet_write_number(worksheet, 2, 2, 4.5, NULL);
worksheet_write_number(worksheet, 3, 2, 1.8, NULL);
worksheet_write_number(worksheet, 4, 2, 2.8, NULL);
worksheet_write_number(worksheet, 1, 3, 2, NULL);
worksheet_write_number(worksheet, 2, 3, 2, NULL);
worksheet_write_number(worksheet, 3, 3, 3, NULL);
worksheet_write_number(worksheet, 4, 3, 5, NULL);
worksheet_set_column(worksheet, COLS("A:D"), 11, NULL);
chart_add_series(chart,
"=Sheet1!$A$2:$A$5",
"=Sheet1!$B$2:$B$5"
);
chart_add_series(chart,
"=Sheet1!$A$2:$A$5",
"=Sheet1!$C$2:$C$5"
);
chart_add_series(chart,
"=Sheet1!$A$2:$A$5",
"=Sheet1!$D$2:$D$5"
);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_outline01.xlsx");
lxw_worksheet *worksheet1 = workbook_add_worksheet(workbook, "Outlined Rows");
lxw_format *bold = workbook_add_format(workbook);
format_set_bold(bold);
lxw_row_col_options options1 = {.hidden = 0, .level = 2, .collapsed = 0};
lxw_row_col_options options2 = {.hidden = 0, .level = 1, .collapsed = 0};
worksheet_set_column(worksheet1, COLS("A:A"), 20, NULL);
worksheet_set_row_opt(worksheet1, 1, LXW_DEF_ROW_HEIGHT, NULL, &options1);
worksheet_set_row_opt(worksheet1, 2, LXW_DEF_ROW_HEIGHT, NULL, &options1);
worksheet_set_row_opt(worksheet1, 3, LXW_DEF_ROW_HEIGHT, NULL, &options1);
worksheet_set_row_opt(worksheet1, 4, LXW_DEF_ROW_HEIGHT, NULL, &options1);
worksheet_set_row_opt(worksheet1, 5, LXW_DEF_ROW_HEIGHT, NULL, &options2);
worksheet_set_row_opt(worksheet1, 6, LXW_DEF_ROW_HEIGHT, NULL, &options1);
worksheet_set_row_opt(worksheet1, 7, LXW_DEF_ROW_HEIGHT, NULL, &options1);
worksheet_set_row_opt(worksheet1, 8, LXW_DEF_ROW_HEIGHT, NULL, &options1);
worksheet_set_row_opt(worksheet1, 9, LXW_DEF_ROW_HEIGHT, NULL, &options1);
worksheet_set_row_opt(worksheet1, 10, LXW_DEF_ROW_HEIGHT, NULL, &options2);
worksheet_write_string(worksheet1, CELL("A1"), "Region", bold);
worksheet_write_string(worksheet1, CELL("A2"), "North" , NULL);
worksheet_write_string(worksheet1, CELL("A3"), "North" , NULL);
worksheet_write_string(worksheet1, CELL("A4"), "North" , NULL);
worksheet_write_string(worksheet1, CELL("A5"), "North" , NULL);
worksheet_write_string(worksheet1, CELL("A6"), "North Total", bold);
worksheet_write_string(worksheet1, CELL("B1"), "Sales", bold);
worksheet_write_number(worksheet1, CELL("B2"), 1000 , NULL);
worksheet_write_number(worksheet1, CELL("B3"), 1200 , NULL);
worksheet_write_number(worksheet1, CELL("B4"), 900 , NULL);
worksheet_write_number(worksheet1, CELL("B5"), 1200 , NULL);
worksheet_write_formula_num(worksheet1, CELL("B6"), "=SUBTOTAL(9,B2:B5)", bold, 4300);
worksheet_write_string(worksheet1, CELL("A7"), "South" , NULL);
worksheet_write_string(worksheet1, CELL("A8"), "South" , NULL);
worksheet_write_string(worksheet1, CELL("A9"), "South" , NULL);
worksheet_write_string(worksheet1, CELL("A10"), "South" , NULL);
worksheet_write_string(worksheet1, CELL("A11"), "South Total", bold);
worksheet_write_number(worksheet1, CELL("B7"), 400 , NULL);
worksheet_write_number(worksheet1, CELL("B8"), 600 , NULL);
worksheet_write_number(worksheet1, CELL("B9"), 500 , NULL);
worksheet_write_number(worksheet1, CELL("B10"), 600 , NULL);
worksheet_write_formula_num(worksheet1, CELL("B11"), "=SUBTOTAL(9,B7:B10)", bold, 2100);
worksheet_write_string(worksheet1, CELL("A12"), "Grand Total", bold);
worksheet_write_formula_num(worksheet1, CELL("B12"), "=SUBTOTAL(9,B2:B10)", bold, 6400);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_bar03.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart1 = workbook_add_chart(workbook, LXW_CHART_BAR);
lxw_chart *chart2 = workbook_add_chart(workbook, LXW_CHART_BAR);
/* For testing, copy the randomly generated axis ids in the target file. */
chart1->axis_id_1 = 64265216;
chart1->axis_id_2 = 64447616;
chart2->axis_id_1 = 86048128;
chart2->axis_id_2 = 86058112;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col] , NULL);
chart_add_series(chart1,
"=Sheet1!$A$1:$A$5",
"=Sheet1!$B$1:$B$5"
);
chart_add_series(chart1,
"=Sheet1!$A$1:$A$5",
"=Sheet1!$C$1:$C$5"
);
worksheet_insert_chart(worksheet, CELL("E9"), chart1);
chart_add_series(chart2,
"=Sheet1!$A$1:$A$4",
"=Sheet1!$B$1:$B$4"
);
chart_add_series(chart2,
"=Sheet1!$A$1:$A$4",
"=Sheet1!$C$1:$C$4"
);
worksheet_insert_chart(worksheet, CELL("F25"), chart2);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_defined_name03.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, "sheet One");
workbook_define_name(workbook, "Sales", "='sheet One'!G1:H10");
(void)worksheet;
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_row_col_format07.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_format *bold = workbook_add_format(workbook);
format_set_bold(bold);
worksheet_set_row(worksheet, 4, 15, bold, NULL);
return workbook_close(workbook);
}
/* Create a worksheet with a chart. */
int main() {
lxw_workbook *workbook = new_workbook("chart_fonts.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
/* Write some data for the chart. */
worksheet_write_number(worksheet, 0, 0, 10, NULL);
worksheet_write_number(worksheet, 1, 0, 40, NULL);
worksheet_write_number(worksheet, 2, 0, 50, NULL);
worksheet_write_number(worksheet, 3, 0, 20, NULL);
worksheet_write_number(worksheet, 4, 0, 10, NULL);
worksheet_write_number(worksheet, 5, 0, 50, NULL);
/* Create a chart object. */
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_LINE);
/* Configure the chart. */
chart_add_series(chart, NULL, "Sheet1!$A$1:$A$6");
/* Create some fonts to use in the chart. */
lxw_chart_font font1 = {.name = "Calibri", .color = LXW_COLOR_BLUE};
lxw_chart_font font2 = {.name = "Courier", .color = 0x92D050};
lxw_chart_font font3 = {.name = "Arial", .color = 0x00B0F0};
lxw_chart_font font4 = {.name = "Century", .color = LXW_COLOR_RED};
lxw_chart_font font5 = {.rotation = -30};
lxw_chart_font font6 = {.bold = LXW_TRUE,
.italic = LXW_TRUE,
.underline = LXW_TRUE,
.color = 0x7030A0};
/* Write the chart title with a font. */
chart_title_set_name(chart, "Test Results");
chart_title_set_name_font(chart, &font1);
/* Write the Y axis with a font. */
chart_axis_set_name(chart->y_axis, "Units");
chart_axis_set_name_font(chart->y_axis, &font2);
chart_axis_set_num_font(chart->y_axis, &font3);
/* Write the X axis with a font. */
chart_axis_set_name(chart->x_axis, "Month");
chart_axis_set_name_font(chart->x_axis, &font4);
chart_axis_set_num_font(chart->x_axis, &font5);
/* Display the chart legend at the bottom of the chart. */
chart_legend_set_position(chart, LXW_CHART_LEGEND_BOTTOM);
chart_legend_set_font(chart, &font6);
/* Insert the chart into the worksheet. */
worksheet_insert_chart(worksheet, CELL("C1"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_row_col_format10.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_format *bold = workbook_add_format(workbook);
format_set_bold(bold);
worksheet_set_column(worksheet, 2, 2, LXW_DEF_COL_WIDTH, bold, NULL);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_order01.xlsx");
lxw_worksheet *worksheet1 = workbook_add_worksheet(workbook, NULL);
lxw_worksheet *worksheet2 = workbook_add_worksheet(workbook, NULL);
lxw_worksheet *worksheet3 = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart1 = workbook_add_chart(workbook, LXW_CHART_COLUMN);
lxw_chart *chart2 = workbook_add_chart(workbook, LXW_CHART_BAR);
lxw_chart *chart3 = workbook_add_chart(workbook, LXW_CHART_LINE);
lxw_chart *chart4 = workbook_add_chart(workbook, LXW_CHART_PIE);
/* For testing, copy the randomly generated axis ids in the target file. */
chart1->axis_id_1 = 54976896;
chart1->axis_id_2 = 54978432;
chart2->axis_id_1 = 54310784;
chart2->axis_id_2 = 54312320;
chart3->axis_id_1 = 69816704;
chart3->axis_id_2 = 69818240;
chart4->axis_id_1 = 69816704;
chart4->axis_id_2 = 69818240;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++) {
worksheet_write_number(worksheet1, row, col, data[row][col], NULL);
worksheet_write_number(worksheet2, row, col, data[row][col], NULL);
worksheet_write_number(worksheet3, row, col, data[row][col], NULL);
}
chart_add_series(chart1, NULL, "=Sheet1!$A$1:$A$5");
chart_add_series(chart2, NULL, "=Sheet2!$A$1:$A$5");
chart_add_series(chart3, NULL, "=Sheet3!$A$1:$A$5");
chart_add_series(chart4, NULL, "=Sheet1!$B$1:$B$5");
worksheet_insert_chart(worksheet1, CELL("E9"), chart1);
worksheet_insert_chart(worksheet2, CELL("E9"), chart2);
worksheet_insert_chart(worksheet3, CELL("E9"), chart3);
worksheet_insert_chart(worksheet1, CELL("E24"), chart4);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_fit_to_pages01.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_fit_to_pages(worksheet, 1, 1);
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 = new_workbook("test_chartsheet08.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chartsheet *chartsheet = workbook_add_chartsheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_BAR);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 61297792;
chart->axis_id_2 = 61299328;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5");
chart_add_series(chart, NULL, "=Sheet1!$B$1:$B$5");
chart_add_series(chart, NULL, "=Sheet1!$C$1:$C$5");
chartsheet_set_margins(chartsheet, 0.511811023622047,
0.511811023622047,
0.551181102362204,
0.944881889763779);
chartsheet_set_paper(chartsheet, 9);
chartsheet_set_portrait(chartsheet);
lxw_header_footer_options header_options = { 0.118110236220472 };
chartsheet_set_header_opt(chartsheet, "&CPage &P", &header_options);
chartsheet_set_footer_opt(chartsheet, "&C&A", &header_options);
/* For testing. */
chartsheet->worksheet->horizontal_dpi = 200;
chartsheet->worksheet->vertical_dpi = 200;
chartsheet_set_chart(chartsheet, chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_hyperlink18.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
worksheet_write_url(worksheet, CELL("A1"), "http://google.com/00000000001111111111222222222233333333334444444444555555555566666666666777777777778888888888999999999990000000000111111111122222222223333333333444444444455555555556666666666677777777777888888888899999999999000000000011111111112222222222x", NULL);
/* This longer url should be ignored. */
worksheet_write_url(worksheet, CELL("A1"), "http://google.com/00000000001111111111222222222233333333334444444444555555555566666666666777777777778888888888999999999990000000000111111111122222222223333333333444444444455555555556666666666677777777777888888888899999999999000000000011111111112222222222xy", NULL);
return workbook_close(workbook);
}
