• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

Problems with interface or something like that

 
Ranch Hand
Posts: 37
Netbeans IDE Eclipse IDE Chrome
  • 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.
 
Bartender
Posts: 4179
22
IntelliJ IDE Python Java
  • 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
Netbeans IDE Eclipse IDE Chrome
  • 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: 4179
22
IntelliJ IDE Python Java
  • 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).
 
This parrot is no more. It has ceased to be. Now it's a tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!