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 2008/03/12 16:57:48 UTC

DO NOT REPLY [Bug 44589] New: getSheetAt works not 100%, sometimes no Results get back

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: dev@poi.apache.org
        ReportedBy: alexanderdiedler@gmx.de


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 44589] getSheetAt works not 100%, sometimes no Results get back

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44589

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|---                         |WORKSFORME

--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
no response in a long time => resolving for now, please reopen with more
information ifnthis is still an issue

-- 
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

DO NOT REPLY [Bug 44589] getSheetAt works not 100%, sometimes no Results get back

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44589





--- Comment #3 from David Fisher <df...@jmlafferty.com>  2009-02-18 12:20:29 PST ---
Are some of the sheets hidden?

Are some of them chart sheets?

If so then you might try with the latest 3.5beta5. If this fails then it would
help if you would attach a file, or perhaps ask a question on the user list.


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 44589] getSheetAt works not 100%, sometimes no Results get back

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44589


Nick Burch <ni...@torchbox.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO




--- Comment #2 from Nick Burch <ni...@torchbox.com>  2008-03-13 06:05:11 PST ---
Is the problem that some sheets come out in the wrong order, or that some
sheets come out twice, and others not at all?

(eg 10 -> 10, 11 -> 10, 12 -> 12, or 10 -> 10, 11 -> 12, 12 -> 11, 13 -> 13)

Also, if you load the file up in excel, and do save as, does the resulting file
work properly with poi, or do you still have the same issue?


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 44589] getSheetAt works not 100%, sometimes no Results get back

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44589





--- Comment #1 from Alexander Diedler <al...@gmx.de>  2008-03-12 08:58:47 PST ---
My Version is 3.0.2 Final of POI Classes


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org