Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Creating excel with add-on Bloomberg function using POI

 
Rurien Wintercraft
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I'm currently developing a java code that creates an excel using Apache POI. I know this falls more on POI rather than java but I can't seem to access their forum and I was hoping someone here can help me out.

My problem is that when I'm creating a formula cell, as long as it's a built-in function from Excel it works. However, I need to place an add-on Bloomberg function to my cell and when I do that, with the original POI jar file (version poi-3.7.jar), it doesn't even accept the function, stating that the bloomberg function (=BDP...) does not exist. What I did was add the BDP function to the functionMetaData.txt of POI's source, built it, and used that as my new jar. With my edited POI jar, it returns "#VALUE!" using MS Excel below 2007 and "=#N/A" when using MS Excel 2007. Am I missing a step in my code? Please help.

Here's my code:

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic