Caxlsx (Community Continued Version)
Notice: Community Axlsx Organization
To better maintain the Axlsx ecosystem, all related gems have been forked or moved to the following community organization:
https://github.com/caxlsx
Join the Caxlsx Slack channel
Synopsis
Axlsx is an Office Open XML Spreadsheet generator for the Ruby programming language. With Axlsx you can create Excel worksheets with charts, images (with links), automated and fixed column widths, customized styles, functions, tables, conditional formatting, print options, comments, merged cells, auto filters, file and stream serialization as well as full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification.
Feature List
Author xlsx documents: Caxlsx is made to let you easily and quickly generate professional xlsx based reports that can be validated before serialization. Generate 3D Pie, Line, Scatter and Bar Charts: With Caxlsx chart generation and management is as easy as a few lines of code. You can build charts based off data in your worksheet or generate charts without any data in your sheet at all. Customize gridlines, label rotation and series colors as well. Custom Styles: With guaranteed document validity, you can style borders, alignment, fills, fonts, and number formats in a single line of code. Those styles can be applied to an entire row, or a single cell anywhere in your workbook. Automatic type support: Caxlsx will automatically determine the type of data you are generating. In this release Float, Integer, String, Date, Time and Boolean types are automatically identified and serialized to your spreadsheet. Automatic and fixed column widths: Caxlsx will automatically determine the appropriate width for your columns based on the content in the worksheet, or use any value you specify for the really funky stuff. Support for automatically formatted 1904 and 1900 epochs configurable in the workbook. Add jpg, gif and png images to worksheets with hyperlinks Reference cells in your worksheet with "A1" and "A1:D4" style references or from the workbook using "Sheet1!A3:B4" style references Cell level style overrides for default and customized style objects Support for formulas, merging, row and column outlining as well as cell level input data validation. Auto filtering tables with worksheet.auto_filter as well as support for Tables Export using shared strings or inline strings so we can inter-op with iWork Numbers (sans charts for now). Output to file or StringIO Support for page margins and print options Support for workbook-level encryption and password protection (requires ooxml_crypt gem which only supports MRI Ruby.) Support for sheet-level password and non-password protection. First stage interoperability support for GoogleDocs, LibreOffice, and Numbers. Support for defined names, which gives you repeated header rows for printing. Data labels for charts as well as series color customization. Support for sheet headers and footers Pivot Tables Page Breaks
Install
... continue reading