Wrapper around anjlab/excel2csv-java POI CLI
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
lib
spec
vendor/excel2csv-java
.gitignore
Gemfile
README.md
Rakefile
excel2csv.gemspec

README.md

Excel2CSV: gem for converting Excel files to csv

Installation and usage

gem install excel2csv

With Gemfile

gem 'excel2csv'

Requirements

  1. Ruby > 1.9.2
  2. Java Runtime

Usage

require 'excel2csv'

# Read csv, xls, xlsx files like with CSV#read
Excel2CSV.read "path/to/file.csv", encoding:"windows-1251:utf-8"
# by default Excel2CSV reads first worksheet
Excel2CSV.read "path/to/file.xls"  # working encoding is always UTF-8
Excel2CSV.read "path/to/file.xlsx" # working encoding is always UTF-8

# Line by line reading like with CSV#foreach
Excel2CSV.foreach("path/to/file.csv", encoding:"windows-1251:utf8") {|r| puts r}
Excel2CSV.foreach("path/to/file.xls") {|r| puts r}
Excel2CSV.foreach("path/to/file.xlsx") {|r| puts r}

# Read non first worksheet
Excel2CSV.read "path/to/file.xls", sheet:1 #reads second sheet 
Excel2CSV.read "path/to/file.xlsx", sheet:2 #reads third sheet


# Preview first N rows in big files
Excel2CSV.read "path/to/file.xls", rows: 2, preview: true
Excel2CSV.read "path/to/file.xlsx", rows: 2, preview: true
Excel2CSV.read "path/to/file.csv", rows: 2, preview: true