Write Excel File

M

Mondeo

Centurion
Joined
Nov 10, 2006
Messages
128
Location
Sunny Lancashire
We're converting some Excel spreadsheets to an ASP.NET application. During the transition process we want to offer the facility for users to download an excel spreadsheet similar to what they are used to. This will be generated on the fly from an asp.net page.

So whats the best way to generate an excel file programatically. Not too bothered about formatting, but we would need multiple tabs/worksheets within the Excel file.

Thanks
 
Automating Excel

The most obvious method would be to automate Excel programmatically. This would of course require Excel to be installed on the web server. By referencing Excel in your project you will be able to interact with it to perform the required operations. The posts in the Interoperation / Office Integration board should point you in the right direction, and a web search on Excel automation in .Net should return some useful information.

Good luck :)
 
Back
Top