Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

POI row.getPhyicalNumberOfCells?

 
Andrew Mcmurray
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I am using HSSF and I am calling the row.getPhyicalNumberOfCells() method. Does this only return the number of non empty cells in the row? Thats what is seems to be doing for me? I need to know the total number of cells for the row. Any thoughts?

Thanks,

AMD
 
Andrew Mcmurray
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok I am stupid that is how it is suspose to work, but is there a way to get what I want, the max number of cells in a row?

Thanks,

AMD
[ January 11, 2007: Message edited by: Andrew Mcmurray ]
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I thought it was fixed at 256.
 
Andrew Mcmurray
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have 251, is 256 stable? Also Ulf do you know how to getDates out. I saw there is a getDate, but what if you don't know the field you are getting is a date or not?

Thanks,

AMD
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out the HSSFDateUtil.isCellDateFormatted(HSSFCell cell) method.
 
Andrew Mcmurray
Ranch Hand
Posts: 188
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Great thanks Ulf
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic