Closed javierav closed 6 years ago
Which software created the original file, that you try to parse with spreadsheet gem?
I don`t know the software used to generate the excel file. It's generated by a public company of the government of Spain :cry:
Ok, please open the file you get from the gov, then save it with libreoffice and then try to edit it with spreadsheet gem.
The XLS file used is a report of the spanish electric operator from this url: 71-PVPC_DETALLE_DD-2018-01-14T23_59_59+00_00.xls.zip
Preview of excel:
The code used:
The output that I have:
Spreadsheet gem is unable to retrieve the cell values, such as dates or numbers. Any idea?