Inserting functions into Excel

From: Childers <iquine_at_yahoo.com>
Date: 13 Sep 2004 16:27:57 -0700
Message-ID: <d83a746.0409131527.36960143@posting.google.com>

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. Received on Mon Sep 13 2004 - 18:27:57 CDT