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.
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.