How do I get XLS data to appear in CSV form the same way it displays in the file?

47 views Asked by At

I’m using Rails 4.2.7 and am using the roo-xls gem. I parse my .xls file using the following code

book = Roo::Spreadsheet.open(file_location)
sheet = book.sheet(0)
text = sheet.to_csv
arr_of_arrs = CSV.parse(text)

One oddity I’m noticing, is that cells in my XLS file that read as “53:52.56” appear in my CSV data as “0.037413888888888885”. All the other cells appear in the CSV data the same way they do in the XLS file. How can I get this one row to show up in my CSV data the same way it appears in the XLS file?

0

There are 0 answers