aspose file tools*
The moose likes Other Open Source Projects and the fly likes Creating excel with add-on Bloomberg function using POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Creating excel with add-on Bloomberg function using POI" Watch "Creating excel with add-on Bloomberg function using POI" New topic
Author

Creating excel with add-on Bloomberg function using POI

Rurien Wintercraft
Greenhorn

Joined: Nov 08, 2010
Posts: 1
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:

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Creating excel with add-on Bloomberg function using POI
 
Similar Threads
facing diffculty to highlight background color of an excel cell which is not reflected in file
Basic Java API for creating Excel? 2 DIM table
Exporting some data to excel
Opening an Excel file
apache poi excel workbook won't open after download