Use org.apache.poi.hssf.util.CellReference to convert string
representation of a cell ref to column and rows:
CellReference ref = new CellReference("AC1");
Cell cell = sheet.getRow(ref.getRow()).getCell(ref.getCol());
Yegor
On Tue, Oct 11, 2011 at 6:13 AM, skrajath
<[email protected]> wrote:
> Hi,
>
> I am using XSSF to access the .xlsx format. Extracting row data and cell
> data is being done by
>
> Row.getCell(1) // to get the first cell data.
>
> Is there a way to access cells like
>
> Row.getCell(A) or Row.getCell(AC).
>
> This will be very helpfull for me to access columns.
> Can any one tell me the way to do this?
>
> Thanks in advance
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/XSSF-Row-getCell-tp4890435p4890435.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
