poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "krishnanand thiyadath" <atkrishnaan...@gmail.com>
Subject regarding named ranges
Date Tue, 09 Sep 2008 11:33:29 GMT
Hi Guys,

 I have created a named range using the following code

 HSSFWorkbook wb = new HSSFWorkbook();

 HSSFName name = wb.createName();
 name.setNameName("test");
 name.setReference("sheet1!$A$1:$A$4");

 But i dont know, how to reference this named range in other cell.

 For example in MS Excel, if i create a named range, i can use it in
DataValidation, by selecting the named range name as source and type as
LIST.

 Can any one tell me, how we can use the named range using POI.

-- 
with thanks,
krishnanand.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message