This is intriguing me, are you opening up excel in a browser window or just
printing out html tables?? I am confused.

I am using PHP to query a database and create an HTML table based on the
information in the database (in this case it it a large crosstab query).
This is set up to open Excel in a broswer window (inline) and display the
data in a worksheet. All normal Excel functions can be performed on the
worksheet without changing the data in the database. These worksheets then
can be saved to the user's local disk. They can always run the original
query again by requesting the worksheet/page again.

Link pointed to php page that will send to browser <a
href="test.php/test.xls"> Stupid IE trick, the .xls file does not 'exist',
but will fake out Excel to open the .php 'page' in a worksheet. Also, make
sure to include header information listed in previous e-mail at the top of
the PHP page.

The steps are;
1. Create a PHP file with the header info
2. Do a PHP request to the database.
3. Use the results to create an HTML table within the PHP
4. Open this table in a spreadsheet


Jay Blanchard

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to