How to access row value using spreadsheet?
How to find last row or end of file using roo?
How to convert xls to csv?
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. [email protected]