With regard to generation of spreadsheets, POI currently only supports
built-in functions (the ~300 basic functions like ROUND and STDEV).
I did some quick research on the "Bloomberg Excel add-in", but I
couldn't determine exactly how to set up my Excel so that I could try
calling BDP. I'm guessing that there is a .xlam or .xll file, for
Bloomberg, much like the standard "Analysis Toolpack" (analys32.xll /
atpvbaen.xlam which has functions like PRICE, YIELD and WEEKNUM)
I think that POI currently encodes an unknown function call as an
'external function in the current workbook', but what is needed (for
add-ins) is an 'external function in an external workbook'. POI may
support calls to add-ins soon, and if the bloomberg stuff is an
"add-in", your sample code should work.
BTW, when I try the code on the latest svn trunk, the formula
*appears* to get in OK (the cell content displays as '=BDP(A1,"PX YEST
CLOSE")' ). My excel(2007) evaluates this to '#NAME?'
I can think of two main reasons why you got '=#N/A', and I got '#NAME?'
- you are using a prior version of POI (less than svn trunk which is
3.0.2+), in which case there is a very slight chance that the trunk
may actually work for you.
- you have the Bloomberg add-in which confuses Excel as to the exact
definition of the called BDP().
On Mon, Mar 31, 2008 at 10:50 AM, poijava <[EMAIL PROTECTED]> wrote:
>
> Hi I am trying to create a formula in Java to call a bloomberg function in
> excel as follows
>
> cell1.setCellFormula("BDP(A1,\"PX YEST CLOSE\")");
>
> I get a "=#N/A" in the column when the spreadsheet is opened. Can anyone
> help?
> --
> View this message in context:
> http://www.nabble.com/POI-Formulas-tp16397740p16397740.html
> Sent from the POI - Dev mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
