sanhue0302 / libxlsxwriter Goto Github PK

View Code? Open in Web Editor NEW

A C library for creating Excel XLSX files.

License: Other

Prolog 0.16% Makefile 0.99% Objective-C 0.06% Shell 0.51% Perl 0.80% C 93.25% Ruby 0.20% Python 4.04%

libxlsxwriter's Introduction

libxlsxwriter

Libxlsxwriter: A C library for creating Excel XLSX files.

The libxlsxwriter library

Libxlsxwriter is a C library that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file.

It supports features such as:

100% compatible Excel XLSX files.
Full Excel formatting.
Merged cells.
Defined names.
Autofilters.
Charts.
Worksheet PNG/JPEG images.
Memory optimization mode for writing large files.
Source code available on GitHub.
FreeBSD ref license.
ANSI C.
Works with GCC 4.x, GCC 5.x, Clang, Xcode, MSVC 2015, ICC and TCC.
Works on Linux, FreeBSD, OS X, iOS and Windows.
The only dependency is on zlib.

Here is an example that was used to create the spreadsheet shown above:

#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);

    /* Writer 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;
}