Category

Reports & Spreadsheets

This category does not have a description yet. You can add one on github!

2.93
There's a lot of open issues
No release in over a year
xlsx spreadsheet generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx helps you create beautiful Office Open XML Spreadsheet documents ( Excel, Google Spreadsheets, Numbers, LibreOffice) 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.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2.9
A long-lived project that still receives updates
Roo can access the contents of various spreadsheet files. It can handle * OpenOffice * Excelx * LibreOffice * CSV
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2.17
A long-lived project that still receives updates
The Spreadsheet Library is designed to read and write Spreadsheet Documents. As of version 0.6.0, only Microsoft Excel compatible spreadsheets are supported. Spreadsheet is a combination/complete rewrite of the Spreadsheet::Excel Library by Daniel J. Berger and the ParseExcel Library by Hannes Wyss. Spreadsheet can read, write and modify Spreadsheet Documents.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
1.23
A long-lived project that still receives updates
rubyXL is a gem which allows the parsing, creation, and manipulation of Microsoft Excel (.xlsx/.xlsm) Documents
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.82
A long-lived project that still receives updates
Axlsx_Rails provides an Axlsx renderer so you can move all your spreadsheet code from your controller into view files. Partials are supported so you can organize any code into reusable chunks (e.g. cover sheets, common styling, etc.) You can use it with acts_as_xlsx, placing the to_xlsx call in a view and adding ':package => xlsx_package' to the parameter list. Now you can keep your controllers thin!
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.45
The project is in a healthy, maintained state
Spreadsheet Architect is a library that allows you to create XLSX, ODS, or CSV spreadsheets easily from ActiveRecord relations, Plain Ruby classes, or predefined data.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.37
Low commit activity in last 3 years
There's a lot of open issues
No release in over a year
Ruby Reports is a software library that aims to make the task of reporting less tedious and painful. It provides tools for data acquisition, database interaction, formatting, and parsing/munging.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.27
There's a lot of open issues
A long-lived project that still receives updates
write_xlsx is a gem to create a new file in the Excel 2007+ XLSX format.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.26
Low commit activity in last 3 years
There's a lot of open issues
A long-lived project that still receives updates
Easy SQL based report generation with the ability to accept request parameters and render multiple formats.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.26
Low commit activity in last 3 years
A long-lived project that still receives updates
Generates ODF files, given a template (.odt) and data, replacing tags
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.23
No release in over 3 years
Low commit activity in last 3 years
There's a lot of open issues
An ActiveRecord gem that makes it easier to do reporting.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.19
No release in over 3 years
Low commit activity in last 3 years
There's a lot of open issues
This gem uses axlsx to provide excel/xlsx downloads for resources in Active Admin. Often, users are happier with excel, so why not give it to them instead of CSV?
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.17
No release in over 3 years
Low commit activity in last 3 years
There's a lot of open issues
acts_as_xlsx lets you turn any ActiveRecord::Base inheriting class into an excel spreadsheet. It can be added to any finder method or scope chain and can use localized column and sheet names with I18n.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.15
No commit activity in last 3 years
No release in over 3 years
There's a lot of open issues
Open local or remote XLSX, XLS, ODS, CSV (comma separated), TSV (tab separated), other delimited, fixed-width files, and Google Docs. Returns an enumerator of Arrays or Hashes, depending on whether there are headers.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.1
No release in over 3 years
Low commit activity in last 3 years
There's a lot of open issues
Reportable allows for easy report generation from ActiveRecord models by the addition of the reportable method.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.09
Low commit activity in last 3 years
A long-lived project that still receives updates
Render XLSX from Rails using existing views ( .*.html => .xlsx )
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.04
A long-lived project that still receives updates
Manipulating LibreOffice Calc (OpenDocument Spreadsheet) files with Ruby. This gem can create new, read existing files abd modify them. When modyfying files, it tries to change as little as possible, making it as much forward compatible as possible.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.03
No release in over 3 years
Just as the name says, simple writter for Office 2007+ Excel files
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
 Popularity
0.02
Low commit activity in last 3 years
A long-lived project that still receives updates
A fast Excel 2007/2010 (.xlsx) file parser that returns a collection of Matrix objects
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.02
There's a lot of open issues
A long-lived project that still receives updates
Workbook contains workbooks, as in a table, contains rows, contains cells, reads/writes excel, ods and csv and tab separated files, and offers basic diffing and sorting capabilities.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.01
A long-lived project that still receives updates
RobustExcelOle automates reading and writing Excel workbooks in Windows by using the win32ole library. It is designed to cope with several kinds of concurrency of both simultaneously running Excel instances and simultanously happening user interactions. RobustExcelOle deals with various cases of Excel (and user) behaviour, supplies workarounds for some Excel bugs, and supports referenced libraries.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.01
No release in over 3 years
OpenOffice.org oocalc: Fast automated batch-processing of spreadsheets (*.ods) conforming to Open Document Format v1.1. used by e.g. OpenOffice.org and LibreOffice. Please see screenshot and Rdoc-Documentation at http://ruby.homelinux.com/ruby/rods/. You can contact me at rods.ruby@online.de (and tell me about your experiences or drop me a line, if you like it ;-)
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
 Popularity
0.01
No commit activity in last 3 years
No release in over 3 years
WrapExcel is to wrap the win32ole, and easy to use Excel operations with ruby. Detailed description please see the README.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.0
No release in over 3 years
Simple tool for running queries against ActiveRecord and putting them into a Google Spreadsheet.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
 Popularity
0.0
The project is in a healthy, maintained state
Ruby/Gnumeric is a Ruby binding of Gnumeric.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
 Popularity
0.0
The project is in a healthy, maintained state
Ruby/GOFFICE is a Ruby binding of GOFFICE.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
 Popularity
0.0
No release in over 3 years
Dynamic Ruby Reporting Engine with support for Charts.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
 Popularity