Mondeo Posted May 21, 2007 Posted May 21, 2007 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 Quote
MrPaul Posted May 22, 2007 Posted May 22, 2007 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 :) Quote Never trouble another for what you can do for yourself.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.