Alex Rivera | Logout

Excel dll for Microsoft.Office.Interop.Excel

Asked 2009-02-19T08:55:14.130
11

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?

asp.net excel interop asp.net-2.0
Edit
Report

1 Answer

2

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.
answered 2010-07-26T13:12:39.487

Your Answer