Created attachment 30318 [details] 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
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.
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
Finally i've found everything! Thanks a lot for assistance!