Bug 44741 - HSSFWorkbook can't return sheet name in 3.0.2-FINAL-20080204.jar
Summary: HSSFWorkbook can't return sheet name in 3.0.2-FINAL-20080204.jar
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2008-04-02 21:54 UTC by Xiaosong Li
Modified: 2008-04-03 19:20 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Xiaosong Li 2008-04-02 21:54:09 UTC
I just downloaded poi-3.0.2-FINAL-20080204.jar and made a test with a xls file: getSheetName()of HSSFWorkbook doesn't return correct sheet name, instead, it returns "sheet1", "sheet2"...
Another issue is getSheetAt(index) only works for index=0.

Trying to debug it, I downloaded source file (poi-3.0.2-beta2), and did the same test, the issues mentioned above doesn't happen. So I guess something wrong happened during project(jar) build. Probably you need a re-build for the jar.
Comment 1 Nick Burch 2008-04-03 01:58:56 UTC
Could you please upload the problem file, so we can test?

Also, are you sure you only have one version of the poi jar in your classpath? It sounds like you might have more than one, and that's confusing things.
Comment 2 Xiaosong Li 2008-04-03 19:17:40 UTC
I found the problem: I modified xls file, but didn't put in right place, so app was still using old file (with sheet name=sheet1). Sorry, my bad. You may close it.