Writing to a .xls file using UTL_FILE package

[abhi_oracle]

Hi,
Can anyone help me out on writing a .xls file using the UTL_FILE package? I am able to write a .txt and .csv file. But .xls file I am not able to do .. the fields are not coming properly if I use a comma separated approach- all the data are coming in the first column itself.
I was trying the following..

v_buffer := '"'||rec.dept||'","'||rec.students||'"';
UTL_FILE.PUT_LINE(v_fh, v_buffer);

Any help in this regard will be appreciated. Thanks in advance.

Regds,
Abhi

[PAVB]

You separate with comma when creating csv files, when creating xls files you want to separate with chr(9) like: rec.dept||chr(9)||rec.students

[davey23uk]

Hi,
Can anyone help me out on writing a .xls file using the UTL_FILE package? I am able to write a .txt and .csv file. But .xls file I am not able to do .. the fields are not coming properly if I use a comma separated approach- all the data are coming in the first column itself.
I was trying the following..

v_buffer := '"'||rec.dept||'","'||rec.students||'"';
UTL_FILE.PUT_LINE(v_fh, v_buffer);

Any help in this regard will be appreciated. Thanks in advance.

Regds,
Abhi

when you open in excel you need to specify that it is comma delimited

[abhi_oracle]

Thanks a lot guys... I tried with chr(9) and it worked ..

[PAVB]

I tried with chr(9) and it worked ..

There is a reason for that, in Excel you hit TAB to move to the next cell... chr(9) = TAB