On Tue, 20 Dec 2011, Erik van de Pol wrote:
Where does the s-attribute of a cell-node refer to? Is it a style? If it is, what style does it refer to? According to the ISO-spec it is a unsigned int, which does not help us much.
It's a cell style, yes.
If there is a comprehensive mapping list somewhere, where can we find it?
It's dynamic based on the file, the style definitions get stored in different streams of the file
If you want a good way to see how the styles and formatting fits together, but while working close to the XML level, then the event based text extractor (XSSFEventBasedExcelExtractor) is probably a good place to look. That handles parsing a .xlsx file largely via sax, and pulls out the formatting information for cells as it goes so it can format numbers and dates for output
Alternately, just use the XSSF usermodel and it's all handled for you :) Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
