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

INFO: Considerations for Server-Side Automation of Office

INFO: Limitations of Office 2000 Web Components When Used Server-Side

and here is an example:

HOWTO: Use Server-Side Charting to Generate Charts Dynamically

HOWTO: Use ASP to Create an Office XP PivotTable and Display the Results as


Microsoft MVP - Windows Server (IIS)

More information about the thelist mailing list