poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chenghao Situ <situcheng...@yahoo.com.cn>
Subject 回复: Re: How to find cell by name in excel?
Date Tue, 21 Oct 2008 13:34:48 GMT
  It works.
  Atfer I get the HSSFName, I can invoke its getReference() method.
  It will return a string like "Sheet1!$A$1", then I can parse it to get the Cell.
  Thanks very much!

Pierre Lavignotte <pierre.lavignotte@gmail.com> 写道:

I guess a named cell is the same as a name area.

I browse my named areas like this :

int nameCount = workbook.getNumberOfNames();

for(int nameIndex=0; nameIndex
HSSFName name = workbook.getNameAt(nameIndex);


By I can't see how to get the cell itself, so I may be wrong...


2008/10/21 Chenghao Situ 

> Hi,
> In excel, we can name a cell.
> In the jxl, it provide a method in jxl.Workbook as:
> public abstract Cell findCellByName(java.lang.String name)
> I checked the POI API Doc but can not find such interface.
> Is there any way to find the cell by cell name?
> Thanks.
> ---------------------------------
> 雅虎邮箱,您的终生邮箱!

Pierre Lavignotte
Ingénieur Conception & Développement

  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message