It is usual for strings to be stored in the shared string stable but not compulsory. Strings may be stored in line, that is as part of the main markup for the worksheet and not in the shared strings table.
How are the files you are working with produced, using Excel, POI or some other software? Obviously, you understand that an xlsx file is simply zipped xml. May I ask you to look into the worksheets folder and open one of the files called sheetn.xml (where n is an integer) and take a look at the markup. It might be that the strings are store inline and you will be able to see that in the markup for each cell. In truth, I have never needed to use the streaming api and it is possible that all you need to do is to modify it for in line strings - if this is indeed the problem here. Anyway, the first step is to check for in line strings by looking at the markup for a sheet. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/sax-get-nothing-but-numbers-from-a-large-excel2007-and-sharedStrings-xml-is-empty-tp5719797p5719799.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
