Gerhard, These should help:
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFWork book.html#createName() http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFName .html Regards, ~ amol > -----Original Message----- > From: news [mailto:[EMAIL PROTECTED] Behalf Of Gerhard Hiller > Sent: Thursday, August 11, 2005 11:47 AM > To: [email protected] > Subject: How to define a name for a cell > > > Hi everybody, > > in Excel it is possible to define a name for a selection > (German Excel it is "Einfügen - Name - Definieren"), > in english one it should be something like > "Insert - name - define". > > Is it possible to do this with hssf-User-Model or somehow > else? I want to reference some columns in other sheets without > having to know the exact place of them. This could be done with > defining the name and then use it in other formulas. > > Thanks in advance, > > Gerhard Hiller > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
