How to get the Cell value of A1(Cell Address) using apache poi 3.6

Question

I have Excel Cell Address like A1,A2. So, how to access this cell programatically using poi3.6

another way is

 row=mySheet.getRow();  cell=row.getCell(); 

But i have the address in the format of A1 ... so, how do I access those cell programatically

Answer 1

CellReference cr = new CellReference("A1"); row = mySheet.getRow(cr.getRow()); cell = row.getCell(cr.getCol()); 

See Quick Guide for more samples.

Answer 2

There's a cellReference function

E.g.

CellReference cellReference = new CellReference("B3");

(taken from the example here)