I'm trying to upload and parse an .XLS file. I've tried with roo-xls and Spreadsheet, but with both, I'm getting this error: Ole::Storage::FormatError in UploadController#upload OLE2 signature is ...

I'm using Rails 5. I want to parse an .xls (not to be confused with .xlsx doc) using the code below book = Roo::Spreadsheet.open(file_location) sheet = book.sheet(0) text = sheet.to_csv csv = ...

I have an Excel column containing part numbers. Here is a sample As you can see, it can be many different datatypes: Float, Int, and String. I am using roo gem to read the file. The problem is t...

I'm on Rails 5 (Ruby 2.4). I want to read an .xls doc and I would like to get the data into CSV format, just as it appears in the Excel file. Someone recommended I use Roo, and so I have book = Ro...