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/05/24 16:09:14 UTC
[Bug 55016] New: XSSF event model. Cannot get cell name
https://issues.apache.org/bugzilla/show_bug.cgi?id=55016
Bug ID: 55016
Summary: XSSF event model. Cannot get cell name
Product: POI
Version: 3.9
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: evgeni_kisel@epam.com
Created attachment 30318
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30318&action=edit
xlsx file with named cell.
Hi,
Unfortunately I'm not able to get cell name using XSSF event model API. Please
see the B2 column in the attached xlsx file.
The expected result that I expect to receive is cell id (B2 according to
attached file) and cell name (COLUMN_NAME according to attached file)
Thanks,
Evgeni
--
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 55016] XSSF event model. Cannot get cell name
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55016
--- Comment #2 from Evgeni <ev...@epam.com> ---
Thank you for explanation. It's quite useful for me. It seems like my fault.
I've not parsed workbook.xml. But I have already spent a lot of time trying to
find anything related to this issue.
Could you share the example if you have one, please?
Thanks,
Evgeni
--
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 55016] XSSF event model. Cannot get cell name
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55016
Mark B <ma...@tiscali.co.uk> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from Mark B <ma...@tiscali.co.uk> ---
I am assuming that you are using an SAX parser and a content handler to read
the raw xml for the sheet but do need to be clear on this point so, may I ask
how you are going about trying to retrieve the cell's name?
If you take a look at the raw xml markup for a workbook, then the names are
usually stored in the workbook.xml file in an element called definedNames. This
element have children - each called definedName - which identifies the cell or
cells the name refers to and specifies the name applied to that range of cells.
If you are using the SAX parser/handler approach to process the sheet's
contents, then I then you will also need to handle this extra wrinkle and parse
the workbook.xml file also.
--
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 55016] XSSF event model. Cannot get cell name
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55016
Evgeni <ev...@epam.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #3 from Evgeni <ev...@epam.com> ---
Finally i've found everything!
Thanks a lot for assistance!
--
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