CODEWITHSUNDEEP
ruby-on-railsexcel
Suganya
Suganya

Reputation: 741

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

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?

Upvotes: 12

Views: 10528

Answers (2)

Stephen O&#39;Reilly
Stephen O&#39;Reilly

Reputation: 63

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

Upvotes: 2

Suganya
Suganya

Reputation: 741

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

Upvotes: 12

Related Questions