Inserting formulas with PL/SQL

C

Childers

I'm not familiar with PL/SQL, but my friend is using it to place data
into an Excel spreadsheet. She can place strings into the
spreadsheet, but cannot figure out how to put in formulas.

Specifically, she is trying to place web links into a column of cells.
She is able to put in 'http://www...' as a string, but then cannot
link from the cell.

I suggested using Excel's hyperlink function, but again it ends up as
a string, not a function.

....
....

owa_util.mime_header(ccontent_type =>'application/vnd.ms-excel');
htp.p('ID;ORACLE');
htp.p(';');
htp.p('; Formatting');
htp.p(';');

....
....


What htp.p statement will insert something like
=hyperlink('http://www.whatthe.com') into a cell?


Thanks for any assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top