CODEWITHSUNDEEP
asp.net-mvcexcelazure
gorgonzola
gorgonzola

Reputation: 115

How run excel on Azure?

I'm implementing a new application in ASP.NET with MVC4. I'd like to use Azure to host my project. I've already created a cloud, but I have a problem with my datasheet. I'm using a excel file whom calculates some prices. I tryed to use openXML, but it can't recalculate my sheet, so i can't use it.

Then, I was thinking to install Microsoft Excel on my cloud to run my excel file.

Do you have any different ideas? Could my solution work?

Upvotes: 0

Views: 6411

Answers (2)

Simon Munro
Simon Munro

Reputation: 5419

Advice against running Office on a server apply doubly to Azure. The short answer is consistently "Don't do it". I replied to a similar question a couple of years ago, and the answer still applies. (Use a native .NET library)

Upvotes: 2

bendataclear
bendataclear

Reputation: 3850

Personally I would avoid this like the plague.

Unless you're doing a crazy amount of calculations in the Excel sheet, it's likely going to be easier to translate the calculation to an asp list or local sql instance than try to get manipulating Excel via Azure asp working.

If you can give details on what happens in the sheet we can probably help to find a way around the problem.

Edit:

It seems like you may be forced to use Excel, if so the following Microsoft KB article has a long list of problems and possible workarounds for manipulating Excel files server side:

Considerations for server-side Automation of Office

Upvotes: 1

Related Questions