https://issues.apache.org/bugzilla/show_bug.cgi?id=49653
Summary: xlsx: line brake in Excel cell read as '_x00D_' in
cell.getStringCellValue
Product: POI
Version: 3.7-dev
Platform: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=25806)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=25806)
The cell values of F3 and F4 aren't read correctly
When reading a string cell value from excel (see attached xslx file) the line
break is read as _x000D_.
The code below with the provided excel sheet can be used to reproduce this (3.7
Beta 1)
InputStream xlsInputStream = new FileInputStream(new File(
"f:\\vfs\\UnReadableStrings.xlsx"));
Workbook wb = new XSSFWorkbook(OPCPackage.open(xlsInputStream));
Sheet sheet = wb.getSheetAt(wb.getActiveSheetIndex());
Row row = sheet.getRow(2);
Cell cell = row.getCell(5);
System.out.println(cell.getStringCellValue());
row = sheet.getRow(3);
cell = row.getCell(5);
System.out.println(cell.getStringCellValue());
Output:
1行目_x000D_2行目
1行目_x000D_
2行目
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
