aspose file tools*
The moose likes Other Open Source Projects and the fly likes Problems with interface or something like that Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Problems with interface or something like that" Watch "Problems with interface or something like that" New topic
Author

Problems with interface or something like that

Josh Borg
Ranch Hand

Joined: Oct 02, 2012
Posts: 32

Hello everybody, I am trying to use apache POI to manipulate XLSX files from MS Excel, looking in forums I found that to ignore errors and avoid exceptions when find an empty cell we must use this instruction when try to get Cells, it will return Null:


The problem is that it returns error in the second argument of method, row.getCell(x,x);


(I'm using netbeans)

I don't know what exactly is it, if it's something I don't know in Interface (I'm novice in it) or what. In all the forums I saw they were using the same terms, and it's working.

I gave a look in MissingCellPolice Interface, here is the first lines of the code:



What should I do to solve this problem? Thanks and sorry for the novice subject.
Steve Luke
Bartender

Joined: Jan 28, 2003
Posts: 4181
    
  21

Josh Borg wrote:The problem is that it returns error in the second argument of method, row.getCell(x,x);
...
I don't know what exactly is it,

What exactly is the problem? We can't help you if we don't know the error.


Steve
Josh Borg
Ranch Hand

Joined: Oct 02, 2012
Posts: 32

Steve Luke wrote:
Josh Borg wrote:The problem is that it returns error in the second argument of method, row.getCell(x,x);
...
I don't know what exactly is it,

What exactly is the problem? We can't help you if we don't know the error.



Sorry, it returns:

cannot find symbol
symbol: variable RETURN_BLANK_AS_NULL
location: class org.apache.poi.ss.usermodel.Row.MissingCellPolicy
Steve Luke
Bartender

Joined: Jan 28, 2003
Posts: 4181
    
  21

It isn't:
MissingCellPolicy.RETURN_BLANK_AS_NULL
It is
Row.RETURN_BLANK_AS_NULL
(which happens to be of type MissingCellPolicy).
 
Consider Paul's rocket mass heater.
 
subject: Problems with interface or something like that