You can use CellReference#toString() to get the alpha-numeric cell
location.
<code>
CellReference cref = new CellReference(1,2); // row, col
System.out.println(cref.toString());
</code>
Prints out: C2
If you simply want the Column however, you may want
to check out the implementation in the CellReference.java
for the method: convertNumToColString
The method is private, but should give you the idea.
HTH,
~ amol
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 08, 2005 3:28 PM
> To: POI Users List
> Subject: RE: Inserting a row in Excel between existing rows using POI
> HSSF
>
>
> I looked at CellReference but it provides only numeric
> coordinates of the
> cell. I need to map column number to it's respective string
> expression in
> Excel.
> Thanks.
>
>
>
>
>
> Amol Deshmukh
>
>
> <[EMAIL PROTECTED] To:
> "'POI Users List'" <poi-user@jakarta.apache.org>
>
> s-us.com> cc:
>
>
> Subject: RE:
> Inserting a row in Excel between existing rows using POI HSSF
>
> 08/08/2005 03:16
>
>
> PM
>
>
> Please respond to
>
>
> "POI Users List"
>
>
>
>
>
>
>
>
>
>
>
>
>
> For #2 see:
> org.apache.poi.hssf.util.CellReference
>
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]
> > Sent: Monday, August 08, 2005 2:42 PM
> > To: poi-user@jakarta.apache.org
> > Subject: Inserting a row in Excel between existing rows
> using POI HSSF
> >
> >
> > Sorry if I'm sending this the second time - not sure if the
> > first e-mail
> > went through:
> >
> > Hello,
> > I' m working with POI HSSF and looking for more help on two issues:
> > 1. Can someone suggest a few lines of code how to insert a
> new row in
> > Excel between existing rows using POI HSSF.
> > 2. May be somebody has a quick utility to determine an
> > alphabetic cell
> > column (like A1, C12) from the numeric cell number. Let's
> > say, if the cell
> > number is 32 what would be the cell letter.
> >
> > Thanks in advance.
> > Michael D
> >
> >
> >
> ---------------------------------------------------------------------
> > 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/
>
>
>
>
>
> ---------------------------------------------------------------------
> 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/
