I have a dynamic html page (created by a cgi script) that I'd like users to be able to right click and use IE's built-in "Export to Microsoft Excel" option. This works on a static page, but not when any form variables are passed to the script.
The following is a simple example where the username and password are set as hidden variables. This is not actually what I'm trying to accomplish, but illustrates the problem.
If, instead, the variables are passed in the URL, it works fine (like this link):
It seems the problem is that IE re-loads the page before it exports, dropping any POSTed form variables. Is there any way around this (other than a custom routine that exports to Excel) -- I'm really looking to allow users to use the built-in function.
Thanks in advance!