Rails import from Excel issue

Question

Rails import from Excel issue

We are using Ruby on Rails code to import the data from an Excel sheet, we use an alert where it asks whether we upload the data and append to existing data (MySQL database) and display it in a grid designed in Flex 3, or replace the old data with new data. But we are getting this error:

Error in Importing excel files Open
OLE error code:800A03EC in Microsoft Office Excel
Unable to get the Open property of the Workbooks class
HRESULT error code:0x80020009

ruby-on-rails

ruby

excel

import

ole

asked on Stack Overflow Jul 2, 2009 by (unknown user) • edited Jul 2, 2009 by

Jim Puls

2 Answers

IMO this has nothing to do with rails. It is more likely a VBA bug.

answered on Stack Overflow Jul 2, 2009 by

nasmorn

It's a matter of permissions/identities.

I searched on many forums and finally I was able to find a workaround!

In "Components services” => “Computers” => “My Computer” => right-click on “Application Microsoft Excel" then click Properties; in the "Identity" tab, set the user to "Interactive user".

I'm not an expert on this matter so I'm not 100% sure this won't cause any other problem.

answered on Stack Overflow Dec 7, 2012 by

mic.sca

User contributions licensed under CC BY-SA 3.0