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 2011/02/25 14:43:38 UTC

DO NOT REPLY [Bug 50829] New: Unable to get excel 2007 table information

https://issues.apache.org/bugzilla/show_bug.cgi?id=50829

           Summary: Unable to get excel 2007 table information
           Product: POI
           Version: 3.7
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: d_tagliabue2@yahoo.it


Created an attachment (id=26692)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=26692)
Excel 2007 workbook with a table

I created a new workbook with Excel 2007 and saved it as xlsx file. The sheet1
contains one table (not a pivot table, just an excel 2007 table). Unzipping the
xlsx file, I saw that the table information (such as the cell range) is saved
in the file xl/tables/table1.xml.

Using POI 3.7 (object XSSFWorkbook) it seems impossible to access (and change)
this table. See also:
http://comments.gmane.org/gmane.comp.jakarta.poi.user/16123

(methods such as getRelations( ), getMapInfo( ), .. do not work)

-- 
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 50829] Unable to get excel 2007 table information

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #1 from Nick Burch <ni...@alfresco.com> 2011-02-25 16:45:18 EST ---
Tables are associated with sheets, so the trick is to get them from the
relationships on a sheet, rather than a workbook. I've added a getTables()
method to XSSFSheet in r1074710 which does this.

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