To create xls documents easy from sql*plus

To create xls documents easy   February 5, 2004 - 6am Central time zone

Reviewer: Peter Visscher from The Netherlands

 Hi Tom, I know a nice way to make Excel sheets from sqlplus. You can use the markup html tag in sqlplus. Here's an example. SET LINESIZE 4000 SET VERIFY OFF SET FEEDBACK OFF SET PAGESIZE 999 SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF SPOOL c:\temp\test_xls.xls SELECT object_type , SUBSTR( object_name, 1, 30 ) object , created , last_ddl_time , status FROM user_objects ORDER BY 1, 2 / SPOOL OFF SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT ON SET LINESIZE 2000 VERIFY ON FEEDBACK ON Kind regards, Peter Visscher Amis Services BV 
 
 
 
 PS : on peut appeler le fichier crée en ajoutant à la fin du code ci-dessus : 
 
 host "C:\Program Files\Microsoft Office\OFFICE11\excel.exe" "c:\temp\test_xls.xls"