Skip to content

Instantly share code, notes, and snippets.

@rorcraft

rorcraft/convert xls to csv

Created September 21, 2010 13:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rorcraft/589700 to your computer and use it in GitHub Desktop.
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
Copy link

idris commented Feb 12, 2011

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