Hi, I am using Apache SAX (Event API) to process xlsx file (size-167 MB with around 7 lakh records).
I want to upload this data to database. However, it gets nothing but numbers. String can't be read unless the xlsx file is edited and saved. And I hava a lot of xlsx files like this to be processed everyday. As far as I know,strings are stored in sharedStrings.xml. However,the sharedStrings.xml is 1 KB before i edit and save the xlsx file. <http://apache-poi.1045710.n5.nabble.com/file/n5719797/before.jpg> After that, it's 90.8 KB. <http://apache-poi.1045710.n5.nabble.com/file/n5719797/after.jpg> Any one please help me in resolving this issue. Thanks in advance. -- 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-tp5719797.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]
