Using the usermodel (so you can feel my pain, I had to put the file and an executable jar up on a 64-bit server. The file's size was causing java to consume 5-8GB of heap space in usermodel mode): getRichStringCellValue() getStringCellValue() Both return the name of the column header for all columns.
c.getRawValue() Returns null for all columns. Using the latest snapshot jars: poi-3.8-beta1-20101209.jar poi-ooxml-3.8-beta1-20101209.jar poi-ooxml-schemas-3.8-beta1-20101209.jar Same issue as before. It outputs anything that is a date or a number, but no character/text/string fields. -----Original Message----- From: Nick Burch [mailto:[email protected]] Sent: Wednesday, December 08, 2010 8:04 PM To: POI Users List Subject: Re: XSSF text extraction On Wed, 8 Dec 2010, Matt Rogghe wrote: > I've used both my own extractor and the built in > XSSFEventBasedExcelExtractor. In either case the output yields only > data from number or date columns. All character/string columns return > null. Example code for using the latter: If you use the usermodel based one, does that work properly? Also, have you tried with a recent nightly snapshot build in case it has been fixed lately? (There have been some tweaks since 3.7 went out) Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
