Wow! I am impressed, thats too cool. And man is that ever going to be helpful.
Thanks, Steve -----Original Message----- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:25 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] Formatting Information in header? Gridlines in Excel [snip] This is intriguing me, are you opening up excel in a browser window or just printing out html tables?? I am confused. [/snip] 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 HTH! Jay Blanchard -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
