Bug 61989 - Wrong result of sheet(0).row(0).cell(0)
Summary: Wrong result of sheet(0).row(0).cell(0)
Status: RESOLVED WORKSFORME
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-11 12:58 UTC by laiwen.li
Modified: 2018-03-17 23:33 UTC (History)
0 users


Attachments
The excel to read and Debug Infomation (251.06 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-01-11 12:58 UTC, laiwen.li 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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.

http://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFCell.html#getStringCellValue--
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.