自学教程：C++ worksheet_write_number函数代码示例

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  = workbook_new("test_format51.xlsx");    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);    lxw_format    *format;    double value = 123.456;    worksheet_set_column(worksheet, 0, 0, 12, NULL);    format = workbook_add_format(workbook);    format_set_num_format(format, "0.0");    worksheet_write_number(worksheet, 0, 0, value, format);    format = workbook_add_format(workbook);    format_set_num_format(format, "0.000");    worksheet_write_number(worksheet, 1, 0, value, format);    format = workbook_add_format(workbook);    format_set_num_format(format, "0.0000");    worksheet_write_number(worksheet, 2, 0, value, format);    format = workbook_add_format(workbook);    format_set_num_format(format, "0.00000");    worksheet_write_number(worksheet, 3, 0, value, format);    return workbook_close(workbook);}

int main() {    /* Create a new workbook. */    lxw_workbook  *workbook   = workbook_new("anatomy.xlsx");    /* Add a worksheet with a user defined sheet name. */    lxw_worksheet *worksheet1 = workbook_add_worksheet(workbook, "Demo");    /* Add a worksheet with Excel's default sheet name: Sheet2. */    lxw_worksheet *worksheet2 = workbook_add_worksheet(workbook, NULL);    /* Add some cell formats. */    lxw_format  *myformat1    = workbook_add_format(workbook);    lxw_format  *myformat2    = workbook_add_format(workbook);    /* Set the bold property for the first format. */    format_set_bold(myformat1);    /* Set a number format for the second format. */    format_set_num_format(myformat2, "$#,##0.00");    /* Widen the first column to make the text clearer. */    worksheet_set_column(worksheet1, 0, 0, 20, NULL);    /* Write some unformatted data. */    worksheet_write_string(worksheet1, 0, 0, "Peach", NULL);    worksheet_write_string(worksheet1, 1, 0, "Plum",  NULL);    /* Write formatted data. */    worksheet_write_string(worksheet1, 2, 0, "Pear",  myformat1);    /* Formats can be reused. */    worksheet_write_string(worksheet1, 3, 0, "Persimmon",  myformat1);    /* Write some numbers. */    worksheet_write_number(worksheet1, 5, 0, 123,       NULL);    worksheet_write_number(worksheet1, 6, 0, 4567.555,  myformat2);    /* Write to the second worksheet. */    worksheet_write_string(worksheet2, 0, 0, "Some text", myformat1);    /* Close the workbook, save the file and free any memory. */    uint8_t error = workbook_close(workbook);    /* Check if there was any error creating the xlsx file. */    if (error)        printf("Error in workbook_close()./n"               "Error %d = %s/n", error, lxw_strerror(error));    return error;}

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  = workbook_new("test_data02.xlsx");    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);    /* Tests for the row range. */    worksheet_write_number(worksheet, 0,       0, 123, NULL);    worksheet_write_number(worksheet, 1048575, 0, 456, NULL);    /* These should be ignored. */    worksheet_write_number(worksheet, -1,      0, 123, NULL);    worksheet_write_number(worksheet, 1048576, 0, 456, NULL);    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_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_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_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_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_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, "[$
C++ workspace函数代码示例
C++ workerThread函数代码示例