Spool SqlPlus Output to Microsoft Excel Format
Spool SqlPlus Output to Microsoft Excel Format SET PAGESIZE 50000 SET FEEDBACK OFF SET MARKUP HTML ON SPOOL ON SET NUM 24 SPOOL file_name.xls ---- Execute your query SPOOL OFF SET MARKUP HTML OFF SPOOL OFF Example: SET PAGESIZE 50000 SET FEED OFF MARKUP HTML ON SPOOL ON SET NUM 24 SPOOL EMP_DATA.xls Select EMPNO, ENAME, HIREDATE, SAL From Scott.EMP / [[ The output from above query will be displayed ..... ]] SPOOL OFF SET MARKUP HTML OFF SPOOL OFF NOTE: The file will contain the SQL as well. Save the file as Your_File_name.xlsx The file should be in the Current Working Directory.
