I am using the following script to send output of a query to excel file.
Set markup html on
SET LINESIZE 2000
Spool test1.xls
Select * from CMSLOANISSUETRANSACTION;
Spool off
The entire row is converted into a single cell. How to send each column value into a seperate cell while sending output to excel file?