[thelist] Excel over the web
Ken Schaefer
ken at adOpenStatic.com
Sat Nov 1 19:11:17 CST 2003
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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)
More information about the thelist
mailing list