How to get numeric and string value from excel file cell, using POI , i am getting error for numeric value, string value easily fetch [duplicate]

Question

Currently i am using String data= sheet1.getRow(row).getCell(column).getStringCellValue(); It works properly for String value but displays error for numeric value. So i have to add numeric value like "34567" in excel. Is there any other method to fetch both numeric and String ?

Vijay · Accepted Answer · 2016-06-06 10:19:06Z

1

You will get an error when you try to fetch the numeric cell as String.

You should be setting the cellType as string like below, before fetching the numeric cell.

   HSSFCell yourCell = sheet1.getRow(row).getCell(column);
   yourCell.setCellType(Cell.CELL_TYPE_STRING);
   String data = yourCell.getStringCellValue();

answered Jun 6, 2016 at 10:19

Vijay

5524 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mahendra sonavane Over a year ago

Thanks a lot vijay .. it works for me .. :) Appreciate your knowledge :) @vijay

Ajay · Accepted Answer · 2016-06-06 09:59:41Z

0

in the template excel change the column type as string.then get the value as string as follows sheet1.getRow(row).getCell(column).getStringCellValue().Then pasrse to integer or whatever.

answered Jun 6, 2016 at 9:59

Ajay

857 bronze badges

Collectives™ on Stack Overflow

How to get numeric and string value from excel file cell, using POI , i am getting error for numeric value, string value easily fetch [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related