https://issues.apache.org/bugzilla/show_bug.cgi?id=44589
Summary: getSheetAt works not 100%, sometimes no Results get back
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
IF I have a large(?) (28 sheets) Excelsheet and want to get every Sheet looping
through a Interface, not every Sheet will be identified by ID correctly.
FileInputStream in = new FileInputStream(filename);
POIFSFileSystem fs = new POIFSFileSystem(in);
HSSFWorkbook e_workbook = new HSSFWorkbook(fs);
HSSFSheet e_sheet = e_workbook.getSheetAt(Integer.parseInt(sheet_id));
System.out.println(String.valueOf(e_sheet.getRow(5).getCell((short)1).getRichStringCellValue()));
brings me sometimes an result, sometimes not but eyery sheets has exactly the
same structure of cells. The readed cell has the Format "Text" in Excel an
contains a String "1A1".
--
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]
