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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
Basic Java API for creating Excel? 2 DIM table
facing diffculty to highlight background color of an excel cell which is not reflected in file
apache poi excel workbook won't open after download
Opening an Excel file
Exporting some data to excel