Reports & Spreadsheets

axlsx

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.

Rubygem axlsx

Total Downloads
1631445
Releases
41
Current Version
2.1.0.pre
Released
2015-03-14 00:00:00 UTC
First Release
2011-11-10 15:00:00 UTC

Github randym/axlsx

Watchers
1615
Forks
331
Development activity
Less active
Last commit
2016-04-30 05:28:35 UTC

spreadsheet

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.

Rubygem spreadsheet

Total Downloads
3833137
Releases
73
Current Version
1.0.2
Released
2015-03-05 00:00:00 UTC
First Release
2008-10-12 22:00:00 UTC

Github zdavatz/spreadsheet

Watchers
607
Forks
151
Development activity
Less active
Last commit
2016-03-29 11:10:46 UTC
First commit

roo

Roo can access the contents of various spreadsheet files. It can handle * OpenOffice * Excelx * LibreOffice * CSV

Rubygem roo

Total Downloads
1966824
Releases
80
Current Version
2.4.0
Released
2016-05-14 00:00:00 UTC
First Release
2007-05-28 22:00:00 UTC

Github Empact/roo

Watchers
694
Forks
149
Development activity
Less active
Last commit
2014-08-12 19:04:34 UTC
First commit

Ruport

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.

Rubygem ruport

Total Downloads
376819
Releases
53
Current Version
1.6.3
Released
2009-12-12 13:00:00 UTC
First Release
2005-08-28 04:00:00 UTC

Github ruport/ruport

Watchers
366
Forks
92
Development activity
Inactive
Last commit
2016-02-11 14:11:02 UTC

rubyXL

rubyXL is a gem which allows the parsing, creation, and manipulation of Microsoft Excel (.xlsx/.xlsm) Documents

Rubygem rubyXL

Total Downloads
540710
Releases
87
Current Version
3.3.21
Released
2016-06-17 00:00:00 UTC
First Release
2011-08-01 04:00:00 UTC

Github gilt/rubyXL

Watchers
176
Forks
68
Development activity
Inactive
Last commit
2012-08-07 16:22:15 UTC
First commit
Contributors
9
Issues
Wiki pages

axlsx_rails

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!

Rubygem axlsx_rails

Total Downloads
503572
Releases
10
Current Version
0.4.0
Released
2015-07-14 00:00:00 UTC
First Release
2012-07-17 00:00:00 UTC
Depending Gems
2

Github straydogstudio/axlsx_rails

Watchers
276
Forks
40
Development activity
Less active
Last commit
2016-04-22 16:58:30 UTC
First commit

google-spreadsheet-ruby

This is a library to read/write Google Spreadsheet.

Rubygem google-spreadsheet-ruby

Total Downloads
369592
Releases
14
Current Version
0.3.1
Released
2013-01-20 00:00:00 UTC
First Release
2010-01-05 15:00:00 UTC

Github gimite/google-spreadsheet-ruby

Watchers
273
Forks
46
Development activity
Inactive
Last commit
2015-04-11 17:54:33 UTC

Odf-report

Generates ODF files, given a template (.odt) and data, replacing tags

Rubygem odf-report

Total Downloads
30032
Releases
12
Current Version
0.5.1
Released
2014-07-30 00:00:00 UTC
First Release
2009-07-28 06:00:00 UTC
Depends on following gems
Depending Gems
1

Github sandrods/odf-report

Watchers
228
Forks
74
Development activity
Inactive
Last commit
2016-04-06 19:58:55 UTC

Statistics

An ActiveRecord gem that makes it easier to do reporting.

Rubygem statistics

Total Downloads
13845
Releases
2
Current Version
1.0.0
Released
2010-09-10 04:00:00 UTC
First Release
2010-02-18 05:00:00 UTC
Depends on following gems
Depending Gems
0

Github acatighera/statistics

Watchers
479
Forks
23
Development activity
Inactive
Last commit
2010-09-10 05:40:42 UTC
Top contributors
Contributors
3
Issues

activeadmin-axlsx

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?

Rubygem activeadmin-axlsx

Total Downloads
33199
Releases
6
Current Version
2.1.2
Released
2013-06-02 00:00:00 UTC
First Release
2012-11-03 00:00:00 UTC
Depends on following gems
Depending Gems
0

Github randym/activeadmin-axlsx

Watchers
70
Forks
86
Development activity
Inactive
Last commit
2016-03-14 10:17:17 UTC
First commit
Top contributors
Contributors
3
Issues

dossier

Easy SQL based report generation with the ability to accept request parameters and render multiple formats.

Rubygem dossier

Total Downloads
44176
Releases
24
Current Version
2.13.1
Released
2015-08-24 00:00:00 UTC
First Release
2013-01-18 00:00:00 UTC
Depending Gems
1

Github adamhunter/dossier

Watchers
285
Forks
37
Development activity
Less active
Last commit
2014-12-15 14:59:04 UTC
First commit

simple_xlsx_writer

Just as the name says, simple writter for Office 2007+ Excel files

Rubygem simple_xlsx_writer

Total Downloads
54390
Releases
1
Current Version
0.5.3
Released
2010-08-19 21:00:00 UTC
First Release
2010-08-19 21:00:00 UTC
Depends on following gems
Depending Gems
2

Github harvesthq/simple_xlsx_writer

Watchers
148
Forks
56
Development activity
Inactive
Last commit
2016-02-23 16:41:37 UTC
First commit
Top contributors
Contributors
4
Issues

acts_as_xlsx

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.

Rubygem acts_as_xlsx

Total Downloads
104919
Releases
7
Current Version
1.0.6
Released
2012-07-27 00:00:00 UTC
First Release
2011-12-01 00:00:00 UTC
Depends on following gems
Depending Gems
1

Github randym/acts_as_xlsx

Watchers
127
Forks
38
Development activity
Inactive
Last commit
2015-09-28 06:59:02 UTC
Top contributors
Contributors
3
Issues

remote_table

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.

Rubygem remote_table

Total Downloads
119790
Releases
72
Current Version
3.3.3
Released
2016-02-01 00:00:00 UTC
First Release
2009-11-02 08:00:00 UTC

Github seamusabshere/remote_table

Watchers
196
Forks
21
Development activity
Inactive
Last commit
2016-02-01 21:51:53 UTC
First commit

Munger

a data munging and reporting library for Ruby

Github schacon/munger

Watchers
79
Forks
22
Development activity
Inactive
Last commit
2008-12-29 00:20:39 UTC
Top contributors
Contributors
5
Issues

mondrian-olap

JRuby gem for performing multidimensional queries of relational database data using Mondrian OLAP Java library

Rubygem mondrian-olap

Total Downloads
9742
Releases
7
Current Version
0.7.0
Released
2015-12-12 00:00:00 UTC
First Release
2011-03-18 22:00:00 UTC

Github rsim/mondrian-olap

Watchers
189
Forks
30
Development activity
Less active
Last commit
2016-04-24 10:15:46 UTC
First commit
Top contributors
Contributors
5
Issues

Dynamic reports

Dynamic Ruby Reporting Engine with support for Charts.

Rubygem dynamic_reports

Total Downloads
7814
Releases
3
Current Version
0.0.4
Released
2009-07-01 04:00:00 UTC
First Release
2009-06-26 04:00:00 UTC
Depends on following gems
Depending Gems
0

Github wayneeseguin/dynamic_reports

Watchers
235
Forks
19
Development activity
Inactive
Last commit
2009-08-04 19:49:44 UTC
Top contributors
Contributors
1
Issues

thinreports

Thinreports is an open source report generation tool for Ruby.

Rubygem thinreports

Total Downloads
56296
Releases
10
Current Version
0.9.1
Released
2016-06-03 00:00:00 UTC
First Release
2011-07-29 00:00:00 UTC
Depends on following gems
Depending Gems
4

Github thinreports/thinreports-generator

Watchers
137
Forks
22
Development activity
Less active
Last commit
2016-05-01 18:06:36 UTC
Contributors
5
Issues

Reportable

Reportable allows for easy report generation from ActiveRecord models by the addition of the reportable method.

Rubygem reportable

Total Downloads
25282
Releases
12
Current Version
1.4.0
Released
2012-02-14 00:00:00 UTC
First Release
2010-02-25 23:00:00 UTC
Depends on following gems
Depending Gems
0

Github saulabs/reportable

Watchers
97
Forks
33
Development activity
Inactive
Last commit
2015-09-28 16:09:03 UTC

to_spreadsheet

Render XLSX from Rails using existing views ( .*.html => .xlsx )

Rubygem to_spreadsheet

Total Downloads
20066
Releases
13
Current Version
1.0.6
Released
2015-11-03 00:00:00 UTC
First Release
2011-03-20 23:00:00 UTC
Depending Gems
0

Github glebm/to_spreadsheet

Watchers
71
Forks
26
Development activity
Inactive
Last commit
2015-11-03 07:43:31 UTC
First commit
Top contributors
Contributors
6
Issues

write_xlsx

write_xlsx is a gem to create a new file in the Excel 2007+ XLSX format.

Rubygem write_xlsx

Total Downloads
87818
Releases
40
Current Version
0.83.0
Released
2015-04-12 00:00:00 UTC
First Release
2012-01-19 00:00:00 UTC
Depends on following gems
Depending Gems
1

Github cxn03651/write_xlsx

Watchers
64
Forks
15
Development activity
Less active
Last commit
2016-03-11 05:34:57 UTC
First commit
Top contributors
Contributors
3
Issues

Reports as sparkline

rails gem for easy reporting using google chart api sparklines

Github mk/reports_as_sparkline

Watchers
36
Forks
7
Development activity
Inactive
Last commit
2010-03-24 15:01:01 UTC
Top contributors
Contributors
3
Issues

excel_rails

Allows you to program spreadsheets using .rxls views

Rubygem excel_rails

Total Downloads
51431
Releases
7
Current Version
0.3.1
Released
2012-12-07 00:00:00 UTC
First Release
2010-11-14 18:30:00 UTC
Depends on following gems
Depending Gems
0

Github asanghi/excel_rails

Watchers
30
Forks
5
Development activity
Inactive
Last commit
2012-12-07 08:33:52 UTC
Top contributors
Contributors
3
Issues

soroban

Soroban makes it easy to extract and execute formulas from Excel spreadsheets. It rewrites Excel formulas as Ruby expressions, and allows you to bind named variables to spreadsheet cells to easily manipulate inputs and capture outputs.

Rubygem soroban

Total Downloads
13505
Releases
13
Current Version
0.10.0
Released
2014-10-24 00:00:00 UTC
First Release
2012-04-23 00:00:00 UTC
Depends on following gems
Depending Gems
0

Github agworld/soroban

Watchers
20
Forks
8
Development activity
Inactive
Last commit
2014-10-24 01:26:19 UTC
First commit
Top contributors
Contributors
2
Issues

compendium

Ruby on Rails reporting framework

Rubygem compendium

Total Downloads
15451
Releases
16
Current Version
1.1.3.3
Released
2015-06-22 00:00:00 UTC
First Release
2013-08-29 00:00:00 UTC
Depending Gems
1

Github dvandersluis/compendium

Watchers
22
Forks
6
Development activity
Less active
Last commit
2015-12-24 01:29:51 UTC
First commit
Top contributors
Contributors
4
Issues

workbook

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.

Rubygem workbook

Total Downloads
24098
Releases
27
Current Version
0.5
Released
2016-04-06 00:00:00 UTC
First Release
2012-09-10 22:00:00 UTC
Depends on following gems
Depending Gems
0

Github murb/workbook

Watchers
7
Forks
6
Development activity
Less active
Last commit
2016-04-19 08:04:40 UTC
First commit
Top contributors
Contributors
4
Issues

oxcelix

A fast Excel 2007/2010 (.xlsx) file parser that returns a collection of Matrix objects

Rubygem oxcelix

Total Downloads
10476
Releases
12
Current Version
0.4.1
Released
2015-06-15 00:00:00 UTC
First Release
2013-10-06 00:00:00 UTC
Depends on following gems
Depending Gems
0

Github gbiczo/oxcelix

Watchers
11
Forks
7
Development activity
Inactive
Last commit
2015-06-17 17:08:07 UTC
First commit

sheets

Work with spreadsheets easily in a native ruby format.

Rubygem sheets

Total Downloads
13069
Releases
7
Current Version
1.2.1
Released
2015-01-09 00:00:00 UTC
First Release
2011-04-11 04:00:00 UTC
Depends on following gems
Depending Gems
0

Github bspaulding/Sheets

Watchers
22
Forks
4
Development activity
Inactive
Last commit
2015-06-21 20:37:13 UTC
Top contributors
Contributors
3
Issues

wrap_excel

WrapExcel is to wrap the win32ole, and easy to use Excel operations with ruby. Detailed description please see the README.

Rubygem wrap_excel

Total Downloads
8595
Releases
6
Current Version
0.1.0
Released
2013-03-15 00:00:00 UTC
First Release
2011-11-08 00:00:00 UTC
Depends on following gems
Depending Gems
0

Github tomiacannondale/wrap_excel

Watchers
8
Forks
2
Development activity
Inactive
Last commit
2013-03-15 17:10:41 UTC
Top contributors
Contributors
1
Issues

Spreadsheet report

Simple tool for running queries against ActiveRecord and putting them into a Google Spreadsheet.

Rubygem spreadsheet_report

Total Downloads
5711
Releases
3
Current Version
0.0.6
Released
2009-09-28 07:00:00 UTC
First Release
2009-09-01 07:00:00 UTC
Depends on following gems
Depending Gems
0

Github gnoso/spreadsheet_report

Watchers
14
Forks
1
Development activity
Inactive
Last commit
2013-05-28 20:47:36 UTC
Top contributors
Contributors
3
Issues

write_xlsx_rails

xlsx renderer for Rails base on write_xlsx gem

Rubygem write_xlsx_rails

Total Downloads
3511
Releases
3
Current Version
0.0.3
Released
2013-07-30 00:00:00 UTC
First Release
2013-07-10 00:00:00 UTC
Depends on following gems
Depending Gems
0

Github maxd/write_xlsx_rails

Watchers
1
Forks
0
Development activity
Inactive
Last commit
2013-07-30 10:33:31 UTC
First commit
Top contributors
Contributors
1
Issues
×

In order to continue, you must be signed in using your Github account.

If you're signing in using this account for the first time Github will ask for your permission to give access to your public user data to the Ruby Toolbox.

Although the Github Authorization page does not mention it, the request includes read-only access to your verified email address (user:email OAuth scope). This is neccessary so there's a way to notify you about comments, information about your accepted project edits and the like. You can review your notification settings on your account page once you're signed in.