poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Geroge <jamesgeor...@gmail.com>
Subject Re: How to get the Cell Number from POI 3.5
Date Fri, 16 Apr 2010 15:04:12 GMT

Hi Mark,
Thanks for the detailed note, I was able to resolve my issue by using the
method getColumnIndex() of the cell.

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message