Hi All.
I recently upgraded to POI 3.8. I am having issue with cell type when
trying to read xls file. The cell is defined as a text. But value in the
cell is numeric(5678). When I validate the cell type I can see that it
is Cell.CELL_TYPE_NUMERIC and the value in the cell is 5678.0
Here is the code I have:
...
import org.apache.poi.ss.usermodel.Workbook;
....
Workbook workbook = null;
FileInputStream fileInputStream = new FileInputStream(fileName);
if(fileExt.equals("xls"){
workbook = new HSSFWorkbook(fileInputStream);
}
if(fileExt.equals("xlsx"){
workbook = new XSSFWorkbook(fileInputStream);
}
sheet = workbook.getSheetAt(0);
xlsRow = sheet.getRow(0);
etc....
Am I doing something wrong?
Thank you,
Feliks.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
