https://issues.apache.org/bugzilla/show_bug.cgi?id=55107
Bug ID: 55107
Summary: Problem reading formatted cel in Excel
Product: POI
Version: 3.8
Hardware: PC
OS: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
Assignee: [email protected]
Reporter: [email protected]
Created attachment 30447
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30447&action=edit
Test Excel File
A cell in excel is being skipped and not read at all using XSSFWorkbook and
getSheetAt. The cell seems to have a special formatting. Is this a limitation?
Please find attached the test case excel file. Note how B2 is skipped.
This is the code:
import org.apache.poi.xssf.usermodel.*
import org.apache.poi.ss.usermodel.*
//Excel .xlsx
Workbook wbx = new XSSFWorkbook("test.xlsx")
XSSFSheet sheetx = wbx.getSheetAt(0);
//Get Values from Excel
for (XSSFRow rowx : sheetx) {
println rowx
}
--
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]