Hi,
12.1.3 -- We are writing the sql data as .xls file and trying to add the color to the table Header.
Below is the table Header Details which we wanted to be in different background color to differentiate the header and the data ,but when we use HTML Tags, the header details color not appearing instead the HTML Tags are getting printed.
v_file_name:= l_File_nm ||'.xls';
v_file := UTL_FILE.fopen (v_path, v_file_name, 'w', 32767);
l_Header :=
'Type '
|| CHR (9)
|| 'Name '
|| CHR (9)
|| 'Item Type '
|| CHR (9)
|| 'Line / Product '
|| CHR (9)
|| 'Item Description '
|| CHR (9)
|| 'Quantitiy '
|| CHR (9)
|| 'UOM '
|| CHR (9)
|| 'Price '
|| CHR (9)
|| 'Amount '
|| CHR (9)
|| 'Associated Earnings Flag '
|| CHR (13);
UTL_FILE.put_line (v_file, l_Header);
Any help is highly appreciated.
Regards,
John.