Awesome
xlsx_drone
Fast Microsoft Excel's *.xlsx reader. Binding of C's xlsx_drone lib.
Table of contents
Summary
The xlsx_drone gem highlight specifically in runtime speed. This is because almost all the process of gathering information happens in well constructed -for speed- native C code.
You can find a benchmark inside the repository that measure the reading speed of the most known (and used) Ruby libraries for *.xlsx's reading/writing. The results gathered in my old notebook, reading 200000 rows × 3 columns (number, string and date) are as follow:
x2 times faster than the fastest one.
You can run this test on your own computer with the rake bm task.
Installation
Use the gem command that comes with your Ruby installation:
gem install xlsx_drone
Usage
require 'xlsx_drone'
path_to_xlsx = 'foo.xlsx'
wb = XLSXDrone.open(path_to_xlsx) #: XLSXDrone::Workbook
sheets_amount = wb.sheets_amount #: Integer
# you can pass its index (starts with 1) or its name as argument
sheet = wb.load_sheet(1) #: XLSXDrone::Sheet
puts "Sheet #1 name: #{sheet.name}"
puts "Sheet #1 is #{sheet.empty? ? 'empty' : 'not-empty'}"
1.upto(sheet.last_row) do |row|
'A'.upto(sheet.last_column) do |column|
p sheet.read_cell(row, column)
end
end
TODO
All ideas about new implementations are thoroughly thought to keep the essence of the library, which is to be fast and simple. Hence, next TODOs could be taken into account or dismissed based on that.
Also, consider that this TODO list is somehow concatenated to the C's xlsx_drone TODO list. Changes implemented there, will be immediately mirrored here.
- C's xlsx_drone has in its plans to provide writing support for xlsx files. As soon as this is implemented there, I'll perform the neccessary binding.
- Consider making
XLSXDrone::Workbook#load_sheet()to keep a reference to the loaded sheet as an accessible instance variable (i.e.: @loaded_sheets).
Be free to make (or upvote) any feature request.
News
Version 0.4.0 introduces:
Sheet#last_columnSheet#empty?