Excel dll for Microsoft.Office.Interop.Excel

Question

We want to use Microsoft.Office.Interop.Excel in our web application. Everything works fine on our local machines, but on our test machine we're running into problems. It has neither Visual Studio nor Office installed on it.
We're using .NET framework 2.0 and the server is running on Windows Server 2003 with IIS6.

Is there a dll that needs to be installed on the machine or added to the bin of the web application?

Answer 1

Please go through the following URLs for redistribution:

How to make changes in references

Where to get distribution

This may help your suituation. And also according to the distribution page, you also need to install office also.

Answer 2

I'm pretty sure that you will need to have Office installed on the machine it's runnnig on. At least that's my experience from building desktop apps that uses Office.Interop

Answer 3

You will need to have MS Office and the Office Interop assemblies installed on your server in order for that to work.

Answer 4

Does Anyone know of a tool that will allow an application deployed on a web server to manipulate Excel spreadsheets without requiring MS Excel installed on the server.

I have heard of a tool called 'OfficeWriter' that allows manipulation of Word documents without MS Word installed on the server.

Answer 5

OpenXML?

I got it working at the moment to create Office 2007/Open Office spreadsheet files.

1. Point to table
2. Include column headers - optional parameter
3. Detect data type - optional parameter
4. Stream to user or save to file system or save to file system then immediately download.
5. Outcomes an Excel file with cells that are detected as numbers / strings.