Ruby Spreadsheet Library to Create XLSX, ODS, or CSV Files
Open Source Ruby API to generate and handle XLSX, ODS, or CSV spreadsheets documents, generate multi-sheet spreadsheets files, add rows and columns using Ruby commands.
The open source Ruby library Spreadsheet Architect is very useful for the creation and handling of spreadsheet documents using Ruby commands. The library has included support for the creation of XLSX, ODS, or CSV spreadsheets with ease. The library allows spreadsheet creation from ActiveRecord relations, plain Ruby objects, or tabular data.
The Spreadsheet Architect library is very stable and easy to use. It has included several important features related to spreadsheet management, such as create a new spreadsheet file from the scratch, create a spreadsheet from custom data, generate the header, insert rows and columns, apply styles to spreadsheets cells, add new worksheets, add new cells, customize cell data and so on.
Using Spreadsheet Architect library developers can generate multi-sheet spreadsheets document with just a couple of lines of code. All the features related to basic formatting can be easily applied such as bold, italic, underline, text alignment, applying text and cell color, font size, and many more. It has also provided some style aliases that can be easily used inside your applications.
At A Glance
An overview of Spreadsheet Architect features.
- Spreadsheets Creation
- Access spreadsheet
- Modify Excel File
- Formula support
- Add new sheet
- Cells management
- Font support
- Add rows
- Add Columns
- Style support
- String Encodings
- Hide rows/columns
- Delete rows
- Apply colors
The Spreadsheet Architect library only requires Ruby runtime.
Getting Started with Spreadsheet Architect
The recommended way to install Spreadsheet Architect into your project is by using RubyGems. Please use the following command for an easy installation.
Install Spreadsheet Architect via RubyGems
Generate XLSX and ODS Spreadsheet via Ruby
The open source Ruby library Spreadsheet Architect has provided software developers the capability to generate XLSX and ODS documents with ease. You can easily add new sheets, update existing sheets, rename sheets, apply formatting to a range of cells, and much more. The library also provides support for editing the contents of a sheet with just a couple of lines of code.
Combine Multiple Worksheets via Ruby
The free library Spreadsheet Architect enables software programmers to combine multiple worksheets to a single file using Ruby commands. You need to provide the names and complete addresses of the worksheets. After that, it is very easy to join them on another sheet of your choice. Once the process is completed you can easily apply new styles, add new columns or rows, and insert images to it with ease.
Add mages & Styles to Excel Worksheet
The open source Ruby library Spreadsheet Architect gives software programmers the capability to add images inside their spreadsheet with just a couple of lines of Ruby code. You can easily style and customize spreadsheet contents. A developer can adjust its size, replace it with another image, and delete the unwanted images with ease.