Skip to content

Fast Microsoft Excel's XLSX reader. Binding of C's xlsx_drone lib.

License

Notifications You must be signed in to change notification settings

damian-m-g/xlsx_drone_rb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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_column
  • Sheet#empty?

License