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_bar20.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 = 45925120; chart->axis_id_2 = 45927040; 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); worksheet_write_string(worksheet, CELL("A7"), "Pear" , NULL); chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$5"); lxw_chart_series *series2 = chart_add_series(chart, NULL, "=Sheet1!$B$1:$B$5"); lxw_chart_series *series3 = chart_add_series(chart, NULL, "=Sheet1!$C$1:$C$5"); chart_series_set_name(series2, "Apple"); chart_series_set_name(series3, "=Sheet1!$A$7"); worksheet_insert_chart(worksheet, CELL("E9"), chart); return workbook_close(workbook); }
/* * Create a worksheet with examples charts. */ int main() { lxw_workbook *workbook = new_workbook("chartsheet.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_chartsheet *chartsheet = workbook_add_chartsheet(workbook, NULL); lxw_chart_series *series; /* Add a bold format to use to highlight the header cells. */ lxw_format *bold = workbook_add_format(workbook); format_set_bold(bold); /* Write some data for the chart. */ write_worksheet_data(worksheet, bold); /* Create a bar chart. */ lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_BAR); /* Add the first series to the chart. */ series = chart_add_series(chart, "=Sheet1!$A$2:$A$7", "=Sheet1!$B$2:$B$7"); /* Set the name for the series instead of the default "Series 1". */ chart_series_set_name(series, "=Sheet1!$B$1"); /* Add a second series but leave the categories and values undefined. They * can be defined later using the alternative syntax shown below. */ series = chart_add_series(chart, NULL, NULL); /* Configure the series using a syntax that is easier to define programmatically. */ chart_series_set_categories(series, "Sheet1", 1, 0, 6, 0); /* "=Sheet1!$A$2:$A$7" */ chart_series_set_values(series, "Sheet1", 1, 2, 6, 2); /* "=Sheet1!$C$2:$C$7" */ chart_series_set_name_range(series, "Sheet1", 0, 2); /* "=Sheet1!$C$1" */ /* Add a chart title and some axis labels. */ chart_title_set_name(chart, "Results of sample analysis"); chart_axis_set_name(chart->x_axis, "Test number"); chart_axis_set_name(chart->y_axis, "Sample length (mm)"); /* Set an Excel chart style. */ chart_set_style(chart, 11); /* Add the chart to the chartsheet. */ chartsheet_set_chart(chartsheet, chart); /* Display the chartsheet as the active sheet when the workbook is opened. */ chartsheet_activate(chartsheet); return workbook_close(workbook); }
/* Create a worksheet with a chart. */ int main() { lxw_workbook *workbook = new_workbook("chart_pattern.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_chart *chart; /* Add a bold format to use to highlight the header cells. */ lxw_format *bold = workbook_add_format(workbook); format_set_bold(bold); /* Write some data for the chart. */ worksheet_write_string(worksheet, 0, 0, "Shingle", bold); worksheet_write_number(worksheet, 1, 0, 105, NULL); worksheet_write_number(worksheet, 2, 0, 150, NULL); worksheet_write_number(worksheet, 3, 0, 130, NULL); worksheet_write_number(worksheet, 4, 0, 90, NULL); worksheet_write_string(worksheet, 0, 1, "Brick", bold); worksheet_write_number(worksheet, 1, 1, 50, NULL); worksheet_write_number(worksheet, 2, 1, 120, NULL); worksheet_write_number(worksheet, 3, 1, 100, NULL); worksheet_write_number(worksheet, 4, 1, 110, NULL); /* Create a chart object. */ chart = workbook_add_chart(workbook, LXW_CHART_COLUMN); /* Configure the chart. */ lxw_chart_series *series1 = chart_add_series(chart, NULL, "Sheet1!$A$2:$A$5"); lxw_chart_series *series2 = chart_add_series(chart, NULL, "Sheet1!$B$2:$B$5"); chart_series_set_name(series1, "=Sheet1!$A$1"); chart_series_set_name(series2, "=Sheet1!$B$1"); chart_title_set_name(chart, "Cladding types"); chart_axis_set_name(chart->x_axis, "Region"); chart_axis_set_name(chart->y_axis, "Number of houses"); /* Configure an add the chart series patterns. */ lxw_chart_pattern pattern1 = {.type = LXW_CHART_PATTERN_SHINGLE, .fg_color = 0x804000, .bg_color = 0XC68C53}; lxw_chart_pattern pattern2 = {.type = LXW_CHART_PATTERN_HORIZONTAL_BRICK, .fg_color = 0XB30000, .bg_color = 0XFF6666}; chart_series_set_pattern(series1, &pattern1); chart_series_set_pattern(series2, &pattern2); /* Configure and set the chart series borders. */ lxw_chart_line line1 = {.color = 0x804000}; lxw_chart_line line2 = {.color = 0xb30000}; chart_series_set_line(series1, &line1); chart_series_set_line(series2, &line2); /* Widen the gap between the series/categories. */ chart_set_series_gap(chart, 70); /* Insert the chart into the worksheet. */ worksheet_insert_chart(worksheet, CELL("D2"), chart); return workbook_close(workbook); }
/* * Create a worksheet with examples charts. * */ int main() { lxw_workbook *workbook = new_workbook("chart_pie.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_chart *chart ; lxw_chart_series *series; /* Add a bold format to use to highlight the header cells. */ lxw_format *bold = workbook_add_format(workbook); format_set_bold(bold); /* Write some data for the chart. */ write_worksheet_data(worksheet, bold); /* * Chart 1: Create a simple pie chart. */ chart = workbook_add_chart(workbook, LXW_CHART_PIE); /* Add the first series to the chart. */ series = chart_add_series(chart, "=Sheet1!$A$2:$A$4", "=Sheet1!$B$2:$B$4"); /* Set the name for the series instead of the default "Series 1". */ chart_series_set_name(series, "Pie sales data"); /* Add a chart title. */ chart_title_set_name(chart, "Popular Pie Types"); /* Set an Excel chart style. */ chart_set_style(chart, 10); /* Insert the chart into the worksheet. */ worksheet_insert_chart(worksheet, CELL("D2"), chart); /* * Chart 2: Create a pie chart with user defined segment colors. */ chart = workbook_add_chart(workbook, LXW_CHART_PIE); /* Add the first series to the chart. */ series = chart_add_series(chart, "=Sheet1!$A$2:$A$4", "=Sheet1!$B$2:$B$4"); /* Set the name for the series instead of the default "Series 1". */ chart_series_set_name(series, "Pie sales data"); /* Add a chart title. */ chart_title_set_name(chart, "Pie Chart with user defined colors"); /* Add for fills for use in the chart. */ lxw_chart_fill fill1 = {.color = 0x5ABA10}; lxw_chart_fill fill2 = {.color = 0xFE110E}; lxw_chart_fill fill3 = {.color = 0xCA5C05}; /* Add some points with the above fills. */ lxw_chart_point point1 = {.fill = &fill1}; lxw_chart_point point2 = {.fill = &fill2}; lxw_chart_point point3 = {.fill = &fill3}; /* Create an array of the point objects. */ lxw_chart_point *points[] = {&point1, &point2, &point3, NULL}; /* Add/override the points/segments of the chart. */ chart_series_set_points(series, points); /* Insert the chart into the worksheet. */ worksheet_insert_chart(worksheet, CELL("D18"), chart); /* * Chart 3: Create a pie chart with rotation of the segments. */ chart = workbook_add_chart(workbook, LXW_CHART_PIE); /* Add the first series to the chart. */ series = chart_add_series(chart, "=Sheet1!$A$2:$A$4", "=Sheet1!$B$2:$B$4"); /* Set the name for the series instead of the default "Series 1". */ chart_series_set_name(series, "Pie sales data"); /* Add a chart title. */ chart_title_set_name(chart, "Pie Chart with segment rotation"); /* Change the angle/rotation of the first segment. */ chart_set_rotation(chart, 90); /* Insert the chart into the worksheet. */ worksheet_insert_chart(worksheet, CELL("D34"), chart); return workbook_close(workbook); }