Hi,
you can use the named range in formulas or in Data Validation too.
Search for recent messages with HSSFDataValidation and you will find
some exemple code.
Come back if you need more information.
Pierre
On Tue, Sep 9, 2008 at 1:33 PM, krishnanand thiyadath
<[EMAIL PROTECTED]> wrote:
> 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.
>
--
Cordialement,
Pierre Lavignotte
Ingénieur Conception & Développement
http://pierre.lavignotte.googlepages.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
