• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problems with interface or something like that

 
Josh Borg
Ranch Hand
Posts: 37
Chrome Eclipse IDE Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4181
22
IntelliJ IDE Java Python
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Josh Borg
Ranch Hand
Posts: 37
Chrome Eclipse IDE Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4181
22
IntelliJ IDE Java Python
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It isn't:
MissingCellPolicy.RETURN_BLANK_AS_NULL
It is
Row.RETURN_BLANK_AS_NULL
(which happens to be of type MissingCellPolicy).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic