Thursday, November 7, 2013

Spool table in excel sheet / html page

set feed on markup html on
spool c:\test.xls
select * from emp;
spool off
set feed off markup html off

same way you can export it in html also, you just need to change file extension from .xls to .html

No comments:

Post a Comment