dmk / fastsheet Goto Github PK

FastSheet is the fastest XLSX file parser for Ruby (at the time of release). It leverages a Rust library for high-performance parsing, making it significantly faster than other available solutions.

License: MIT License

Ruby 38.84% Rust 61.16%

excel gem ruby rust spreadsheets xlsx

fastsheet's Introduction

Fastsheet

Fastest ruby gem for reading Excel documents.

Installation

You should have rust installed to use this gem.

Add this line to your application's Gemfile:

gem 'fastsheet'

And then execute:

$ bundle

Or install it yourself as:

$ gem install fastsheet

Usage

Open a sheet:

require 'fastsheet'

sheet = Fastsheet::Sheet.new('path/to/sheet.xlsx')

# number of columns
sheet.width

# number of rows
sheet.height

Get rows or columns:

sheet.rows
sheet.columns

sheet.row(42)
sheet.column(1)

Iterators (returns enumerator if no block given):

sheet.each_row { |r| ... }
sheet.each_column { |c| ... }

That's all API for now. Feel free to open an issue if you need more.

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/dkkoval/fastsheet.

License

The gem is available as open source under the terms of the MIT License.

fastsheet's People

Contributors

Stargazers

Watchers

Forkers

mkalenska yivo kmasuda050 hyoshida kshahkshah beetrack

fastsheet's Issues

Cells of date type are parsed as floats

cell = Fastsheet::Sheet.new(File.expand_path('~/book.xlsx')).rows[0][0] # => 32887.0
cell.class # => Float

book.xlsx

Currently calamine returns dates as ISO strings: https://github.com/tafia/calamine/blob/89acf7614692322d5ad39d23def54f0f7e03b5bb/src/xlsx.rs#L343

cargo build failing

from fastsheet/ext/fastsheet

carthage fastsheet cargo build --verbose
       Fresh cc v1.0.0
       Fresh libc v0.2.32
       Fresh rustc-demangle v0.1.5
       Fresh cfg-if v0.1.2
       Fresh podio v0.1.5
       Fresh byteorder v1.1.0
       Fresh log v0.3.8
       Fresh time v0.1.38
       Fresh memchr v1.0.1
       Fresh backtrace v0.3.3
       Fresh encoding_rs v0.7.1
       Fresh encoding_rs v0.6.11
       Fresh msdos_time v0.1.5
       Fresh error-chain v0.10.0
       Fresh miniz-sys v0.1.10
       Fresh quick-xml v0.9.4
       Fresh flate2 v0.2.20
       Fresh zip v0.2.6
       Fresh calamine v0.11.8
   Compiling fastsheet v0.1.0 (file:///Users/kshah/Projects/fastsheet/ext/fastsheet)
     Running `rustc --crate-name fastsheet src/lib.rs --crate-type cdylib --emit=dep-info,link -C debuginfo=2 -C metadata=18b2c63d0c7ca4ac --out-dir /Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps -C incremental=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/incremental -L dependency=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps --extern libc=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/liblibc-c61a85ada6fff360.rlib --extern calamine=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libcalamine-63f324057d3415ac.rlib -L /Users/kshah/.rbenv/versions/2.4.4/lib -l dylib=ruby -L native=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/build/miniz-sys-77bf16acbe89aeb1/out`
error: linking with `cc` failed: exit code: 1
  |
  = note: "cc" "-m64" "-L" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.138pesuvab4dy035.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.15kq92zzbmxot4k9.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.165baco9su64i857.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.16u6js6g0l3k1ic6.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1ckp3bwk0jmrbky4.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1im38lueib99jsk0.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1jnlhyxj59jycbjv.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1kduva7sc7em934m.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1mvmz58owquyropc.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1q8ffos2d96smbjs.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1vh38o7wxh11wkn0.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1y16o1qfye96o7m0.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1zeawhkbeobww1zn.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.1zwd8n7bcl3vhvvh.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.2f0hry2t7c05ttdi.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.2fken9eeju7oloq5.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.2jqywn86b2gsqohu.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.2k46uffec3qe5kzm.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.2lyh15q6cjwzy18c.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.3171x0bwu82dptu7.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.3ayaeypdcro9d6yk.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.3cx7oljifvb206q7.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.3g94tobrpgum5dk6.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.3ik0x0hz6l66cx38.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.3oow75egt3w2yamp.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.43v6g0y2xsxoggnt.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.44bsbddupzfao2om.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.45nf4z58qqykpcpi.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.45pc7c65foh9i35f.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.48721dc4k5qxei0u.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.49a7n47po4ttqjl7.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.49lx1q7cxvpykyv0.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.4a6dgwgsyclvnmy1.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.4ezmh1vbs95c5ack.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.4xq48u46a1pwiqn7.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.4yh8x2b62dcih00t.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.4ypvbwho0bu5tnww.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.51eljgz8aqn910w7.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.5607purn0g2vuinv.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.57k06xfugllsc526.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.59tekexjfguannst.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.5gf6du7k58s78kob.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.8xzrsc1ux72v29j.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.98g0d9x8aw3akpe.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.9elsx31vb4it187.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.c6lbtaiefvx3wya.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.e19kx9t7xhzajfl.rcgu.o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.pqmjx25qpxkduz7.rcgu.o" "-o" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libfastsheet.dylib" "-Wl,-exported_symbols_list,/var/folders/y4/gdhydhl91kj45g0b62tq_01c0000gn/T/rustc.7xcEL7ueLcaA/list" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/fastsheet.crate.allocator.rcgu.o" "-Wl,-dead_strip" "-nodefaultlibs" "-L" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps" "-L" "/Users/kshah/.rbenv/versions/2.4.4/lib" "-L" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/build/miniz-sys-77bf16acbe89aeb1/out" "-L" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib" "-l" "ruby" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libcalamine-63f324057d3415ac.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/liblog-a043e0c4ba9a8419.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libbyteorder-d57dd9171a553da1.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libencoding_rs-d16f043b7752075d.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libquick_xml-5c7e42682916074e.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libmemchr-e258494fb8fbeae4.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/liberror_chain-3132341efd3cfef0.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libbacktrace-bfd89c026b60e6d4.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/librustc_demangle-e0e3e37d9a48a093.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libencoding_rs-fdf6496c7e624361.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libcfg_if-4b39e50f7b7262d9.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libzip-94fc28aa4a995754.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libpodio-28f18a52fb78f6ef.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libmsdos_time-32645c761a5f4e48.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libtime-1c3b1bbf639033c3.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libflate2-fc8a040ce16441b9.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libminiz_sys-abc0cf2bfd4b112f.rlib" "/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/liblibc-c61a85ada6fff360.rlib" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib/libstd-9c9a33c348bd8e28.rlib" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib/libpanic_unwind-bfadc73c1c740faf.rlib" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib/libunwind-f95059049928a72a.rlib" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib/liballoc_system-c5b02ba65d48e95e.rlib" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib/liblibc-6f35de8054b3e3a6.rlib" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib/liballoc-19f4fd82a48bf85f.rlib" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib/libstd_unicode-62d20f204b8e46cd.rlib" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib/libcore-c8eb739c41b5b8f1.rlib" "/usr/local/Cellar/rust/1.26.2/lib/rustlib/x86_64-apple-darwin/lib/libcompiler_builtins-444a5e2b0462e72c.rlib" "-l" "System" "-l" "resolv" "-l" "pthread" "-l" "c" "-l" "m" "-dynamiclib" "-Wl,-dylib"
  = note: Undefined symbols for architecture x86_64:
            "_rb_float_new", referenced from:
                fastsheet::read::h4ffb3e1e6d149d4c in fastsheet.51eljgz8aqn910w7.rcgu.o
            "_rb_utf8_str_new_cstr", referenced from:
                fastsheet::read::h4ffb3e1e6d149d4c in fastsheet.51eljgz8aqn910w7.rcgu.o
          ld: symbol(s) not found for architecture x86_64
          clang: error: linker command failed with exit code 1 (use -v to see invocation)


error: aborting due to previous error

error: Could not compile `fastsheet`.

Caused by:
  process didn't exit successfully: `rustc --crate-name fastsheet src/lib.rs --crate-type cdylib --emit=dep-info,link -C debuginfo=2 -C metadata=18b2c63d0c7ca4ac --out-dir /Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps -C incremental=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/incremental -L dependency=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps --extern libc=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/liblibc-c61a85ada6fff360.rlib --extern calamine=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/deps/libcalamine-63f324057d3415ac.rlib -L /Users/kshah/.rbenv/versions/2.4.4/lib -l dylib=ruby -L native=/Users/kshah/Projects/fastsheet/ext/fastsheet/target/debug/build/miniz-sys-77bf16acbe89aeb1/out` (exit code: 101)

carthage fastsheet ruby --version
ruby 2.4.4p296 (2018-03-28 revision 63013) [x86_64-darwin16]
carthage fastsheet rustc --version
rustc 1.26.2
carthage fastsheet cargo --version
cargo 1.26.0

carthage fastsheet cc --version
Apple LLVM version 9.0.0 (clang-900.0.39.2)
Target: x86_64-apple-darwin16.7.0
Thread model: posix
InstalledDir: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin

could it be my LLVM?

@dkkoval I know you are busy, but have a second for a thought here?

My intention here is to build this so I can add capability to iterate over spreadsheets using Ruby enumerable as I saw a TODO was looking for.

I have to get off of the other Ruby spreadsheet libs ASAP, they are bug ridden and have horrendous memory leaks.

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.