A Ruby gem for generating Excel spreadsheets with charts, images, automated column widths, customizable styles, and full schema validation.
Caxlsx is a Ruby library for generating Office Open XML Spreadsheet (Excel) files programmatically. It solves the problem of creating complex, styled spreadsheets with charts, images, and automated formatting without requiring developers to understand the full ECMA specification. The gem includes schema validation to ensure generated files are compatible across different spreadsheet software.
Ruby developers who need to generate Excel reports, dashboards, or data exports in applications, particularly those in business intelligence, finance, or data analysis roles.
Developers choose Caxlsx for its comprehensive feature set—including charting, styling, and validation—coupled with a straightforward Ruby DSL. Its ability to guarantee valid output and interoperability with tools like Google Docs and LibreOffice makes it a robust alternative to manual spreadsheet creation or lower-level libraries.
xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Supports charts, images, pivot tables, conditional formatting, and password protection, enabling professional Excel documents directly from Ruby code, as detailed in the feature list.
Automatically identifies and serializes Float, Integer, String, Date, Time, and Boolean types, reducing manual data handling and simplifying the API.
Includes schema validation to ensure generated files are compatible across platforms, preventing client-side errors and guaranteeing document validity.
Forked to a community organization with active updates, CI/CD integration, and a Slack channel, ensuring ongoing support and development.
Has known rendering issues with LibreOffice, Google Docs, and Apple Numbers, such as charts not displaying or images failing to load, requiring workarounds.
Workbook encryption requires the external ooxml_crypt gem, which only works with MRI Ruby, limiting usability in other Ruby implementations.
Usage questions are redirected to examples and FAQ, and the README discourages issue creation, suggesting documentation may be incomplete or hard to navigate for complex cases.