Header Repeats When i Spool result to xls file
905660Dec 15 2011 — edited Dec 15 2011hey all,
I know it must be a basic thing that i must be overlooking. I am spooling the result of a query in excel using code similar to as shown below
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ;
SPOOL MY_TEST_FILE.xls;
select * from emp;
SPOOL OFF;
exit / %errorlevel%;
I get a neat xml output but with the header repeating every 15th column. (The actual query is different and has >50 records as result set.)
Any Ideas how do i ensure just one header. Any response feedback is appreciated.
Thanks,
Gavy