1

Topic: Sending xls and color of cells

Kind time of days!
At me is  for sending of messages with.xls nestings.
It is formed clob and it is transferred in procedure:

FOR x IN (SELECT *
FROM all_objects
WHERE ROWNUM <20)
LOOP
v_clob: =
v_clob
|| x.owner
|| ';'
|| x.object_name
|| ';'
|| x.object_type
|| ';'
|| TO_CHAR (x.created, ' yyyy-mm-dd hh24:mi:ss')
|| UTL_TCP.crlf;
END LOOP;
sending_mails.send_attach_clob (p_sender => ' blabla@zzz.ru'
,p_recipients => ' blabla@zzz.ru'
,p_message => v_message
,p_subject => ' Test msg'
,p_attachment => v_clob
,p_att_inline => FALSE
,p_att_mime_type =>.XLS'
,p_att_filename => ' TEST.XLS ');

Prompt, please, as it is possible (whether probably) to install color of cells in.xls in this case?
In the Internet anything suitable did not find.

2

Re: Sending xls and color of cells

It not XLS, and CSV.
Make XLS - there all is possible.
For example, library POI.

3

Re: Sending xls and color of cells

israelshamir, what hinders to collect xml? All that you want it is possible to specify for excel, color, a font etc.