Open Source Fast Ruby Spreadsheet Generator Library

Ruby API that programmatically supports creating and manipulating spreadsheet documents. It allows to protect spreadsheets, apply custom styles & formatting, inserting images, and hyperlinks.

caxlsx is a very useful and feature rich open source Ruby library that helps developers to generate powerful apps for creating and manipulating spreadsheet with ease. The spreadsheet generator library caxlsx helps the developer to make stunning looking Open XML Spreadsheet documents without having the complete knowledge of ECMA specification.

caxlsx library is very powerful but yet very simple to configure. It has included several important features for Excel spreadsheet generation and processing such as adding new worksheet, renaming a worksheet, add charts to worksheet, inserting images and links, manage column & rows widths, customized styles, tables handling, printing support, merging cells, apply filters, add comments and much more.

The library also included some advanced features while handling spreadsheet files, such as adding headers and footers, handling PivotTables, protecting your sheets using passwords, Auto filtering tables, and many more.

At A Glance

An overview of caxlsx features.

Features Overview

XLSX File
Custom Styles
Add worksheet
Rename worksheet
Custom styles
Insert hyperlinks
Add charts

Features Overview

Protect sheet
Add cells
Add rows
Insert columns
Style borders
merging cells
Delete rows/Columns

caxlsx

caxlsx supports the following formats.

Reader

XLSX

Writer

XLSX, HTML, TXT

caxlsx

Platform Independence

The caxlsx library only requires Ruby runtime.

Ruby

caxlsx

Getting Started with caxlsx

The recommend way to install caxlsx library is by using RubyGems. Please use the following command for smooth installation.

Install caxlsx via RubyGems

gem 'caxlsx'

You can download the compiled shared library from the GitHub repository and install it.

Create Spreadsheet with Charts via Ruby

The caxlsx library makes it easy for software programmers to create Excel spreadsheets inside their own Ruby applications. The library supports adding charts to their spreadsheet with just a couple of lines of code. It enables developers to generate 3D pie, line, scatter, and bar charts easily. The library allows users to build charts based on the custom data as well as generate charts without any data in their worksheets. You can easily customize the gridlines, label rotation, and much more.

Protect Spreadsheet via Ruby API

The open source caxlsx library gives Ruby programmers the ability to protect the spreadsheet by applying passwords inside their own applications. It is a very useful technique that prevents other people from making any changes or viewing, moving, or deleting important data from a worksheet. The library has included support for creating password protected as well as non-password worksheets with just a couple of lines of code.

Apply Custom Styles to Worksheets

Custom styles are a very convenient way to save users time when formatting their worksheets. The caxlsx library has provided complete functionality for applying custom style and formatting to Excel Spreadsheet using Ruby code. The library has provided consistent formatting across a range of cells. Developers can easily style borders, use alignment, apply fills, select fonts, and number formats in a single line of Ruby code.

Inserting Images and Hyperlinks to Spreadsheets

The free caxlsx library has provided complete support for adding and modifying images inside their worksheets with just a couple of Ruby commands. You can use popular image formats such as JPG, GIF, and PNG images inside a worksheet. You can also insert images with hyperlinks. The library also allows replacing an existing image or modifying its size and place.