Skip to content

Instantly share code, notes, and snippets.

@rorcraft

rorcraft/convert xls to csv

Created September 21, 2010 13:44
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rorcraft/589700 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rorcraft/589700 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
convert xls to csv
#!/usr/bin/env ruby
require 'rubygems'
require 'roo'
pwd = File.dirname(__FILE__)
file = ARGV[0]
file_path = "#{pwd}/#{file}"
xls = Excel.new(file_path)
xls.to_csv("#{pwd}/#{file}.csv")
@idris

idris commented Feb 12, 2011

Copy link
Copy Markdown

When installing/requiring roo, I also needed to install the spreadsheet gem. Then I got this error:
LoadError: no such file to load -- google_spreadsheet

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment