Ole::Storage::FormatError: OLE2 signature is invalid

Question

I want to read an Excel File in my Rails Application.

This is how I open my Excel file and read it.

doc = Spreadsheet.open('./try.xls', "r")
sheet = doc.worksheet 0
sheet.each do |row|
array_rows << row.to_a
end

I have it as a rake task.When I try to Read this file it throws an error.

Ole::Storage::FormatError: OLE2 signature is invalid

What is happening? what should I do?

Related question: http://stackoverflow.com/questions/17990116/roo-spreadsheet-uploading-ole2-signature-is-invalid — Andrew Grimm, Oct 16 '15 at 03:36

score 11 · Accepted Answer · answered Aug 26 '14 at 09:52

11

The .xls file must be saved in EXCEL 2003 format. So File-->Save As from All Formats dropdown select the Excel year 2003

This solved my problem

answered Aug 26 '14 at 09:52

Suganya

13

but what would you do if your client uploads the file and it is in .xlsx which is a new format which is from 2007? – Sadiksha Gautam Dec 12 '14 at 09:55

score 2 · Answer 2 · answered May 23 '16 at 15:01

2

On Mac I had to save it as Excel 97-2004(.xls) to get it to work

answered May 23 '16 at 15:01

Stephen O'Reilly

2 Answers2