|
Yes I know the HTML you proposed is valid Excel readable stuff. I do it al the time. I still thing Jeff (was it Jeff?) has a CCSID issue. -Bob Cozzi www.RPGxTools.com If everything is under control, you are going too slow. - Mario Andretti -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Larry Ducie Sent: Friday, July 15, 2005 1:39 AM To: rpg400-l@xxxxxxxxxxxx Subject: <html> Hi Bob, <snip> You might be confusing Excel by using the XLS suffix on the file since the file has HTML in it... I would leave it at .HTM or .HTML </snip> It can't be this. Excel is designed to look for HTML tables if the data can't be interpreted as a "standard" OLE 2 compound document. If it finds tables in the data it will redefine the tables and display them as spreadsheets. Consider this HTML: <html> <body> <table> <tr> <th>value1</th> <th>value2</th> <th>value1</th> </tr> <tr> <td>value1</td> <td>value2</td> <td>value1</td> </tr> <tr> <td>value1</td> <td>value2</td> <td>value1</td> </tr> </table> </body> </html> Put that in a file using notepad, save it as a .XLS and open it using Excel - you'll get a formatted table - with the header cells automatically set to BOLD/CENTER. All good stuff. Larry Ducie
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
