[thelist] Excel over the web

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Norman Bunn" <norman.bunn at craftedsolutions.com>
Subject: [thelist] Excel over the web


: I have built a spreadsheet macro that does some data
: manipulation on some output from a website printed to a file.
: I would like to duplicate this functionality over the web
: where the user uploads the output and Excel processes it.
: I know I can run Access over the web, but what about Excel?
:
: BTW, if this is a stupid question, please be gentle. :)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If you know how to instantiate an Access Application object, you can do the
same for Excel. However, from what I've heard from others, this is can be a
violation of your Office EULA.

There are lots of articles out there - google for "Office Automation",
though with ASP, CF etc I'm not sure.

There are a few things to be aware of:

http://support.microsoft.com/?id=257757
INFO: Considerations for Server-Side Automation of Office

http://support.microsoft.com/?id=317316
INFO: Limitations of Office 2000 Web Components When Used Server-Side

and here is an example:

http://support.microsoft.com/?id=244049
HOWTO: Use Server-Side Charting to Generate Charts Dynamically

http://support.microsoft.com/?id=294798
HOWTO: Use ASP to Create an Office XP PivotTable and Display the Results as
HTML

Cheers
Ken

Microsoft MVP - Windows Server (IIS)