How to convert xls to csv?

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

google “ruby excel”

On Feb 17, 11:54 pm, Salil G. [email protected]

Hi Salil,

To convert xls to csv and then parse for use in ruby, you could try
wrapping xls2csv ( and
parsing via CSV (
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

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


On Feb 17, 8:54 pm, Salil G. [email protected]