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. removed_email_address@domain.invalid

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