Do you know where I can get the latest SVN build?
g
Josh Micich wrote:
>
> 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]
>
>
>
--
View this message in context:
http://www.nabble.com/POI-Formulas-tp16397740p16416906.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]
