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?