So I generate this excel output using sqlplus with the spool command in my sql script, but when I try to run another script and append the output to same excel file, it doesn't seem to work. The append works well if my output is a text file. Here are the 2 scripts I am running for this:
Script_1
set pagesize 5000 set markup html on spool on set num 24 spool C:\Apps\Result\mylog.xls append select * from list where Age=21; set markup html off spool off exit; /
Script_2
set pagesize 5000 set markup html on spool on set num 24 spool C:\Apps\Result\mylog.xls append select * from list where Age=25; set markup html off spool off exit; /
The excel file size actually gets bigger each time I run the Script_2 but when I open it I don't see anything else but the output of Script_1. Any help?