poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amol Deshmukh <adeshm...@hobsons-us.com>
Subject RE: Inserting a row in Excel between existing rows using POI HSSF
Date Mon, 08 Aug 2005 19:38:20 GMT
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: michael.dolgonos@jpmchase.com
> [mailto:michael.dolgonos@jpmchase.com]
> 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                           
>                                                               
>            
>                       <adeshmukh@hobson        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: michael.dolgonos@jpmchase.com
> > [mailto:michael.dolgonos@jpmchase.com]
> > 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: poi-user-unsubscribe@jakarta.apache.org
> > Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> >
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message