All Projects → jmcnamara → Libxlsxwriter

jmcnamara / Libxlsxwriter

Licence: other
A C library for creating Excel XLSX files.

Programming Languages

c
50402 projects - #5 most used programming language

Projects that are alternatives of or similar to Libxlsxwriter

umya-spreadsheet
A pure rust library for reading and writing spreadsheet files
Stars: ✭ 79 (-90%)
Mutual labels:  xlsx, spreadsheet
workbook
simple framework for containing spreadsheet like data
Stars: ✭ 13 (-98.35%)
Mutual labels:  xlsx, spreadsheet
sheet2dict
Simple XLSX and CSV to dictionary converter
Stars: ✭ 206 (-73.92%)
Mutual labels:  xlsx, spreadsheet
Sheetjs
📗 SheetJS Community Edition -- Spreadsheet Data Toolkit
Stars: ✭ 28,479 (+3504.94%)
Mutual labels:  spreadsheet, xlsx
Unioffice
Pure go library for creating and processing Office Word (.docx), Excel (.xlsx) and Powerpoint (.pptx) documents
Stars: ✭ 3,111 (+293.8%)
Mutual labels:  spreadsheet, xlsx
spreadsheet
Yii2 extension for export to Excel
Stars: ✭ 79 (-90%)
Mutual labels:  xlsx, spreadsheet
Docjure
Read and write Office documents from Clojure
Stars: ✭ 510 (-35.44%)
Mutual labels:  spreadsheet, xlsx
fxl
fxl is a Clojure spreadsheet library
Stars: ✭ 117 (-85.19%)
Mutual labels:  xlsx, spreadsheet
ExcelFormulaBeautifier
Excel Formula Beautifer,make Excel formulas more easy to read,Excel公式格式化/美化,将Excel公式转为易读的排版
Stars: ✭ 27 (-96.58%)
Mutual labels:  xlsx, spreadsheet
excel validator
Python script to validate data in Excel files
Stars: ✭ 14 (-98.23%)
Mutual labels:  xlsx, spreadsheet
convey
CSV processing and web related data types mutual conversion
Stars: ✭ 16 (-97.97%)
Mutual labels:  xlsx, spreadsheet
J
❌ Multi-format spreadsheet CLI (now merged in http://github.com/sheetjs/js-xlsx )
Stars: ✭ 343 (-56.58%)
Mutual labels:  spreadsheet, xlsx
xlsx reader
A production-ready XLSX file reader for Elixir.
Stars: ✭ 46 (-94.18%)
Mutual labels:  xlsx, spreadsheet
Reogrid
Fast and powerful .NET spreadsheet component, support data format, freeze, outline, formula calculation, chart, script execution and etc. Compatible with Excel 2007 (.xlsx) format and working on .NET 3.5 (or client profile), WPF and Android platform.
Stars: ✭ 532 (-32.66%)
Mutual labels:  spreadsheet, xlsx
Dexiom.EPPlusExporter
A very simple, yet incredibly powerfull library to generate Excel documents out of objects, arrays, lists, collections, etc.
Stars: ✭ 19 (-97.59%)
Mutual labels:  xlsx, spreadsheet
fxl.js
ƛ fxl.js is a data-oriented JavaScript spreadsheet library. It provides a way to build spreadsheets using modular, lego-like blocks.
Stars: ✭ 27 (-96.58%)
Mutual labels:  xlsx, spreadsheet
xltpl
A python module to generate xls/x files from a xls/x template.
Stars: ✭ 46 (-94.18%)
Mutual labels:  xlsx, spreadsheet
keikai-tutorial
A tutorial of a web spreadsheet component, keikai
Stars: ✭ 19 (-97.59%)
Mutual labels:  xlsx, spreadsheet
XToolset
Typed import, and export XLSX spreadsheet to JS / TS. Template-based create, render, and export data into excel files.
Stars: ✭ 110 (-86.08%)
Mutual labels:  xlsx, spreadsheet
Spout
Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way
Stars: ✭ 3,861 (+388.73%)
Mutual labels:  spreadsheet, xlsx

libxlsxwriter

Libxlsxwriter: A C library for creating Excel XLSX files.

demo image

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.
  • Data validation and drop down lists.
  • Conditional formatting.
  • Worksheet PNG/JPEG images.
  • Cell comments.
  • Support for adding Macros.
  • Memory optimization mode for writing large files.
  • Source code available on GitHub.
  • FreeBSD license.
  • ANSI C.
  • Works with GCC, Clang, Xcode, MSVC 2015, ICC, TCC, MinGW, MingGW-w64/32.
  • Works on Linux, FreeBSD, OpenBSD, OS X, iOS and Windows. Also works on MSYS/MSYS2 and Cygwin.
  • Compiles for 32 and 64 bit.
  • Compiles and works on big and little endian systems.
  • 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);

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

See the full documentation for the getting started guide, a tutorial, the main API documentation and examples.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].