Hi Mark, Thanks for the detailed note, I was able to resolve my issue by using the method getColumnIndex() of the cell.
Regards, James George. MSB wrote: > > Hello James, > > I am not at all familiar with such an old version of POI - 2.5 - so can I > ask please, what exactly did the getCellNum() method return? > > The co-ordinates of a cell are usually the product of the column and the > row it sits in. When you recover a cell using POI, the typical idiom is to > get a row from a sheet using an index and then to get a cell from the row > also using an index. Thus, the cell's number is the pair of co-ordinates - > row and column index - that you use to obtain it in the first place. If > you are after the cells index in Excel's format then there is a support > calss that will convert from the row and column index into that format be > it A1, X35 of whatever. Take a look here - > http://poi.apache.org/apidocs/org/apache/poi/ss/util/CellReference.html - > CellReference allows you to convert from the column and row indices used > to refer to cell in POI to it's Excel equivalent. > > Do not know if this helps at all as I am not familiar with 2.5 and the > getCellNum() method. If not, then can you explain what that method did and > it should be possible to convery from one value into another. > > Yours > > Mark B > > > James Geroge wrote: >> >> Hi Friends, >> I am trying to way to get the cellnumber from POI 3.5. >> in 2.5 (HSSFCell) there was method named cell.getCellNum() which returns >> the cell number, but in 3.5 i did not see that method, please help >> >> Thanks >> James George >> > > -- View this message in context: http://old.nabble.com/How-to-get-the-Cell-Number-from-POI-3.5-tp28259150p28268004.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
