How to convert xls to csv?


#1

How to access row value using spreadsheet?
How to find last row or end of file using roo?
How to convert xls to csv?


#2

google “ruby excel”

On Feb 17, 11:54 pm, Salil G. removed_email_address@domain.invalid


#3

Hi Salil,

To convert xls to csv and then parse for use in ruby, you could try
wrapping xls2csv (http://www.wagner.pp.ru/~vitus/software/catdoc/) and
parsing via CSV (http://www.ruby-doc.org/stdlib/libdoc/csv/rdoc/
index.html), something like:

$ irb
irb(main):001:0> require ‘csv’
=> true

irb(main):002:0> csv_raw = xls2csv test.xls.sub(/\s+$/, “\n”)
=> ““fruit”,“color”\n"banana”,“yellow”\n"strawberry",“red
“\n"tangerine”,“orange”\n”

irb(main):003:0> CSV.parse(csv_raw) {|rec| puts rec.inspect }
[“fruit”, “color”]
[“banana”, “yellow”]
[“strawberry”, “red”]
[“tangerine”, “orange”]
=> nil

Jeff

On Feb 17, 8:54 pm, Salil G. removed_email_address@domain.invalid