int main() { lxw_workbook *workbook = new_workbook("test_chart_format24.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 = 115374720; chart->axis_id_2 = 115389568; 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, "=Sheet1!$A$1:$A$5", "=Sheet1!$B$1:$B$5" ); chart_add_series(chart, "=Sheet1!$A$1:$A$5", "=Sheet1!$C$1:$C$5" ); lxw_chart_fill fill1 = {.color = LXW_COLOR_YELLOW, .transparency = 75}; lxw_chart_fill fill2 = {.color = LXW_COLOR_RED, .transparency = 25}; chart_chartarea_set_fill(chart, &fill1); chart_plotarea_set_fill(chart, &fill2); worksheet_insert_chart(worksheet, CELL("E9"), chart); return workbook_close(workbook); }
int main() { lxw_workbook *workbook = new_workbook("test_chart_chartarea05.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" ); lxw_chart_line line1 = {.dash_type = LXW_CHART_LINE_DASH_LONG_DASH, .color = 0xFFFF00}; lxw_chart_line line2 = {.dash_type = LXW_CHART_LINE_DASH_DASH_DOT}; lxw_chart_fill fill1 = {.color = 0x92D050}; lxw_chart_fill fill2 = {.color = 0xFFC000}; chart_chartarea_set_line(chart, &line1); chart_chartarea_set_fill(chart, &fill1); /* This should be ignored for a pie chart. */ chart_plotarea_set_line(chart, &line2); chart_plotarea_set_fill(chart, &fill2); worksheet_insert_chart(worksheet, CELL("E9"), chart); return workbook_close(workbook); }