Excel on a ASP.NET page - HELP

  • Thread starter Thread starter Dale Williams
  • Start date Start date
D

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

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.
 
Back
Top