libxlsxwriter

Libxlsxwriter: 一个用于创建 Excel XLSX 文件的 C 语言库。

demo image

libxlsxwriter 库

Libxlsxwriter 是一个 C 语言库,可用于将文本、数字、公式和超链接写入 Excel 2007+ XLSX 文件中的多个工作表。

它支持以下功能,例如:

这是一个用于创建上面显示的电子表格的示例

#include "xlsxwriter.h"

int main() {

    /* Create a new workbook and add a worksheet. */
    lxw_workbook  *workbook  = workbook_new("demo.xlsx");
    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);

    /* Add a format. */
    lxw_format *format = workbook_add_format(workbook);

    /* Set the bold property for the format */
    format_set_bold(format);

    /* Change the column width for clarity. */
    worksheet_set_column(worksheet, 0, 0, 20, NULL);

    /* Write some simple text. */
    worksheet_write_string(worksheet, 0, 0, "Hello", NULL);

    /* Text with formatting. */
    worksheet_write_string(worksheet, 1, 0, "World", format);

    /* Write some numbers. */
    worksheet_write_number(worksheet, 2, 0, 123,     NULL);
    worksheet_write_number(worksheet, 3, 0, 123.456, NULL);

    /* Insert an image. */
    worksheet_insert_image(worksheet, 1, 2, "logo.png");

    workbook_close(workbook);

    return 0;
}

请参阅 完整文档,以获取入门指南、教程、主要 API 文档和示例。