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 (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]

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs