Jump to content
Xtreme .Net Talk

Recommended Posts

Posted

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

Posted

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 :)

Never trouble another for what you can do for yourself.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...