How to read data from excel file in windows azure cloud service?
I have a web application in visual studio 2010 and windows azure sdk.It asks the user to upload an excel file and then read its data to the database.When i ran the application on localhost it ran perfectly but when I run it using windows azure sdk emulator (using my application as a web role) it gives the error "The Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine".How to resolve this other than using OpenXml?
March 22nd, 2015 2:26am

You can access office documents only if office COM objects (means office) is installed on the machine.

One option is using of Open.XML (why don't you want to use it?) and another option is to use Office365. However the later one would probably change the whole architecture of you application.

One workaround might be to save Excel file as HTML and read it as HTML. This will not give you all of Open.XML and COM power, but you can very easy access and change data.

Free Windows Admin Tool Kit Click here and download it now
March 22nd, 2015 5:16am

Hi,

  Thanks for Posting.
 
  I Believe the same question has been Answered at StackOverflow.
 
  You can further refer to the following Thread.
 
Regards,
Nithin Rathnakar

March 22nd, 2015 5:21am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics