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

apache-poi
Saravanan picture Saravanan · Nov 25, 2010 · Viewed 25.7k times · Source

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

Neeme Praks picture Neeme Praks · Nov 25, 2010 
CellReference cr = new CellReference("A1");
row = mySheet.getRow(cr.getRow());
cell = row.getCell(cr.getCol());

See Quick Guide for more samples.

Related questions

How can I read numeric strings in Excel cells as string (not numbers)?

I have excel file with such contents: A1: SomeString A2: 2 All fields are set to String format. When I read the file in java using POI, it tells that A2 is in numeric cell format. The problem is that the …

Read More
Apache POI Excel - how to configure columns to be expanded?

I am using Apache POI API to generate excel spreadsheet to output some data. The problem I am facing is when the spreadsheet is created and opened, columns are not expanded so that some long text like Date formatted text …

Read More
How do I set cell value to Date and apply default Excel date format?

I've been using Apache POI for some time to read existing Excel 2003 files programmatically. Now I have a new requirement to create entire .xls files in-memory (still using Apache POI) and then write them to a file at the end. …

Read More