Bug 61989 - Wrong result of sheet(0).row(0).cell(0)
Summary: Wrong result of sheet(0).row(0).cell(0)
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.17-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2018-01-11 12:58 UTC by laiwen.li
Modified: 2018-03-17 23:33 UTC (History)
0 users

The excel to read and Debug Infomation (251.06 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-01-11 12:58 UTC, laiwen.li

Note You need to log in before you can comment on or make changes to this bug.
Description laiwen.li 2018-01-11 12:58:19 UTC
Created attachment 35673 [details]
The excel to read and Debug Infomation

I read the first sheet of the first row of the first cell.
but the result is wrong.
It gives me the sheetName.

Please read the attachment file for the detail information.
Comment 1 Alain Fagot Bearez 2018-01-11 16:29:27 UTC
You should try to use one of the specialized methods to retrieve the cell content.

I would suggest to take a look at getStringCellValue() as first try.

Comment 2 Dominik Stadler 2018-03-17 23:33:42 UTC
No update for some time and initial investigation indicated an incorrect usage of the API, thus closing this. Please provide more information if this is still a problem for you.