Expert: Peter Choi - 5/28/2009

Question
Hi, am going through a plsql procedure by which an xls file is created using util_file.  My question is ,is it possible to give formatting parameters ex: width, length, colour of the xls sheet using util_file.put_line. And please explain what does /td mean in the follwoing line utl_file.put_line( xls_file, '<td width=1 ></td>' );

Answer
Hi Bhuvaneswari,

Here's a great article and example of creating an XLS (MS-Excel) file using utl_file.

http://www.orafusion.com/art_excel.htm

In your second question, the </td> is an HTML markup ending tag.

So for example, if I wanted to created a bolded text in an HTML,

This text is in <b>bold</b>.

Here's a primer on HTML tags:

http://www.w3.org/MarkUp/Guide/

Hope this helps.

Peter