Excel on a ASP.NET page - HELP

[Dale Williams]

Everyone :

Here's my problem. I'm developing an web application for a user inwhich
they will select a "template". This needs to populate an Excel spreadsheet
on the web form with data from SQL Server. All the formulas, values, etc.
will come from the database. The user(s) will do their thing than click
save and all the changes on the excel sheet will be written back to the
database.

I've tried using Farpoint's Spread for Web with some limited success.
What I really want is to bring up excel on the web form.

I tried putting the Microsoft Office Spreadsheet 10.0 COM on the form
but I'm not able to access it from the codebehind page.

Any examples or articles on how to do this would be greatly appreciated.

Sincerely,
Dale Williams

 

[Jason S]

Dale,

Used to be OWC was the way to go here, and yeah I don't think it knows what
runat="server" means. Take a look at the new Office. Trust me, a lot
better... and .net friendly )

If you can't get that working why not stream down a spreadsheet file with
some VBA or macros that do what you want in a client/server fashion? You
might even be able to call a web service from the VBA. But if it has to
live in a web page seriously look at the new office.

Regards,
Jason S.

 

[Steve C. Orr [MVP, MCSD]]

This article demonstrates ways to interact with Excel:
http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp

In addition you may want to take a look at this technique:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306572

You might also consider one of these 3rd party products to make the whole
process easier:
http://www.aspose.com/Products/Aspose.Excel/
http://officewriter.softartisans.com/