As bad an idea as this can be, I'm still getting a lot of
requests for the ability to use Excel as a data source. Well
here you go! Please be aware that while ASP is meant to handle
multiple users, Excel is not. That means that
you should expect problems if
you put this on a server that handles multiple users.
Because of this limitation, I've departed from my standard
"all our samples are running on the site" philosophy and while
you can download the code, and what you see above was actually produced from
a real run of it, it was not produced on the fly.
Like any other data source, you can also change values in the
underlying file. These changes will be reflected in the Excel
file next time you open it.