Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Creating excel with add-on Bloomberg function using POI  RSS feed

Rurien Wintercraft
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Boost this thread!