Excel Cell Formatting & Styles
Unlike basic CSVs, Excel files decouple data from presentation. A cell in sheet1.xml simply contains a value (e.g., 0.75) and an integer reference attribute (s="2"). This integer points to a specific record in the highly complex xl/styles.xml file, which dictates the font, border, background fill, and number format (e.g., 75%).
These sample files test your parser's ability to cross-reference styles correctly. They include complex merged cell bounds (<mergeCells>) and conditional number formats like [Red]-#,##0.00.
formatting showcase
A comprehensive showcase of fonts, colors, borders, alignments, and standard number formats.
merged cells
A complex layout featuring horizontal, vertical, and block-merged cells to stress-test grid layout algorithms.
conditional number formats
A file utilizing custom format strings (like `[Red]-#,##0.00`) that change color based on the numeric value.
Frequently Asked Questions
Use Cases
- Validating Excel-to-HTML table converters to ensure merged cells generate correct `colspan` and `rowspan` attributes.
- Testing style resolution engines to ensure currency symbols and percentage signs are applied to raw float values.
- Checking color palette extraction (translating indexed Excel colors to standard HEX codes).