It's not a secret anymore!*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 4167
    
  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: 4167
    
  21

It isn't:
MissingCellPolicy.RETURN_BLANK_AS_NULL
It is
Row.RETURN_BLANK_AS_NULL
(which happens to be of type MissingCellPolicy).
 
 
subject: Problems with interface or something like that
 
Similar Threads
TableSorter and Selection gives problems
Builder to read xml? is this the right way?
about abstract class
Converting Old POI Reading .xls Files to POI 3.7 Issues
Debugging code