CODEWITHSUNDEEP
apache-poixssf
naamadheya
naamadheya

Reputation: 2542

Apache POI - XSSF: Row.getCell()

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?

Upvotes: 4

Views: 12488

Answers (2)

Ibot
Ibot

Reputation: 31

The question is regarding reaching out a cell using its references, if I am not wrong.

Sheet referenceSheet = workbook.getsheet("Sheet name your intrested in");

CellReference ref = new CellReference("C24");
Row row = referenceSheet.getRow(ref.getRow());
 // null check for the row
if(row != null)
{
Cell cell = row.getCell(ref.getCol());
}

In this way we can refer a cell using its reference.

Upvotes: 3

Gagravarr
Gagravarr

Reputation: 48356

I think the main class you're looking for is CellReference - it handles converting between user facing references such as "B2" into file format references like row=1,col=1 . There's a static method on there that handles your exact use case, convertColStringToIndex

For your use case, you'd want code something like

 Cell c = row.getCell( CellReference.convertColStringToIndex("G") );

Upvotes: 4

Related Questions