You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/03/22 18:29:41 UTC
[Bug 54743] New: getrow() returns null even though there's data in
the file.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54743
Bug ID: 54743
Summary: getrow() returns null even though there's data in the
file.
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: dajasin@gmail.com
Classification: Unclassified
Here's the code:
SXSSFWorkbook wb;
Sheet sheet;
Row r;
Cell cell;
InputStream inp;
try {
inp = new FileInputStream(sFileName);
wb = new SXSSFWorkbook(new XSSFWorkbook(inp));
cell = wb.getSheetAt(0).getRow(0).getCell(0);
if(cell != null) {
sOutput = cell.getStringCellValue();
sOutput = sOutput + " in here!";
} else {
sOutput = "Nothing";
}
System.out.println(sOutput);
inp.close();
}
catch(FileNotFoundException ex) {
System.out.println(ex.getMessage());
}
catch(IOException | NullPointerException ex) {
System.out.println(ex.getMessage());
}
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54743] getrow() returns null even though there's data in the
file.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54743
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |INVALID
--- Comment #3 from Nick Burch <ap...@gagravarr.org> ---
SXSSFWorkbook is write/append only. It does not support reading
To read a .xlsx file, you need to use the regular XSSFWorkbook (or low level
event/SAX processing)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54743] getrow() returns null even though there's data in the
file.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54743
--- Comment #4 from dajasin <da...@gmail.com> ---
Thanks!
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54743] getrow() returns null even though there's data in the
file.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54743
dajasin <da...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #2 from dajasin <da...@gmail.com> ---
Everything prior to getRow() works ok. I debugged and was able to see that the
workbook and sheet were returned ok. Just couldn't get the row. Always returned
null.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54743] getrow() returns null even though there's data in the
file.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54743
dajasin <da...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|unspecified |3.9
OS| |Windows 7
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54743] getrow() returns null even though there's data in the
file.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54743
--- Comment #1 from dajasin <da...@gmail.com> ---
Created attachment 30096
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30096&action=edit
Test File
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org