ExcelCSV

Read, parse, generate and write CSV directly compatiable with Microsoft Excel on a Windows & Mac.

99% of the time, Ruby's CSV works just fine. This library deals with the other 1%:

• Some European countries use a semicolon instead of a comma as a field separator. ExcelCSV will try to autodetect this, and also supports Excel's proprietary sep= header.
• Excel can't deal with UTF-8, and will read & write in the local character set, which is usually 'Windows-1252'. ExcelCSV reads & writes in this character set automatically.
• Some versions of Excel can't deal with UNIX newlines. ExcelCSV forces DOS newlines.

Full documentation for the latest gem release is at RDoc

Installation

Add this line to your application's Gemfile:

gem 'excel_csv'

And then execute:

$ bundle

Or install it yourself as:

$ gem install excel_csv

Usage

ExcelCSV copies some of the Ruby's CSV method names & pragmas, and returns CSV objects:

require 'excel_csv'

# Read a file
rows = ExcelCSV.read("foo.csv", headers: true)

# Parse a string
ExcelCSV.parse(csv_string) do |row|
  parse_row(row)
end

# Generate a string
csv_string = ExcelCSV.generate do |csv|
  csv << %w{ ... }
end

# Write a file
ExcelCSV.write("foo.csv") do |csv|
  csv << %w{ ... }
end

Contributing

1. Fork it ( https://github.com/exchangegroup/excel_csv/fork )
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create a new Pull Request