Features cross reference

• <span style="text-align: center; color: green;">✔</span> Supported
• <span style="text-align: center; color: orange;">●</span> Partially supported
• <span style="text-align: center; color: red;">✖</span> Not supported
• N/A Cannot be supported

Readers

<table class="features-cross-reference"> <tr> <th></th> <th colspan="8">Readers</th> </tr> <tr> <th></th> <th>XLS</th> <th>XLSX</th> <th>Excel2003XML</th> <th>Ods</th> <th>Gnumeric</th> <th>CSV</th> <th>SYLK</th> <th>HTML</th> </tr> <tr> <td style="padding-left: 0.5em;"><strong><a href="#setGetReaderOptions">Reader Options</a></strong></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Read Charts</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 1em;">Read Data Only (no formatting)</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Read Only Specified Worksheets</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Read Only Specified Cells</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Read External Images</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔ <a href="#footnote9">⁹</a></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔ <a href="#footnote9">⁹</a></td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Document Properties</strong></td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;"><a href="#setGetStdProp">Standard Properties</a></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Creator</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Creation Date/Time</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Modifier</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Modified Date/Time</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Title</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Description</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Subject</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Keywords</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;"><a href="#setGetExtProp">Extended Properties</a></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Category</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Company</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Manager</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;"><a href="#setGetCustProp">User-Defined (Custom) Properties</a></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Text Properties</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Number Properties</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Date Properties</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Yes/No (Boolean) Properties</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Cell Data Types</strong></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 1em;">Empty/NULL</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Boolean</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Integer</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Floating Point</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">String</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Error</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Formula</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 1em;">Array Formula</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 1em;">Rich Text</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td></td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Conditional Formatting</strong></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Rows and Column Properties</strong></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Row Height/Column Width</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Hidden</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Worksheet Properties</strong></td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: orange;">●</td> </tr> <tr> <td style="padding-left: 2em;">Frozen Panes</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Hidden Worksheets</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: orange;">●</td> </tr> <tr> <td style="padding-left: 2em;">Coloured Tabs</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetDrawingHyperlink">Drawing hyperlink</a></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Cell Formatting</strong></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">● <a href="#footnote7">⁷</a></td> </tr> <tr> <td style="padding-left: 1em;">Number Format Mask</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: orange;">● <a href="#footnote6">⁶</a></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Alignment</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: orange;">● <a href="#footnote7">⁷</a></td> </tr> <tr> <td style="padding-left: 2em;">Horizontal</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Vertical</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Wrapping</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: orange;">●</td> </tr> <tr> <td style="padding-left: 2em;">Shrink-to-Fit</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: orange;">●</td> </tr> <tr> <td style="padding-left: 2em;">Indent</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Background Colour</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: orange;">● <a href="#footnote7">⁷</a></td> </tr> <tr> <td style="padding-left: 2em;">Patterned</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 1em;">Font Attributes</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: orange;">● <a href="#footnote7">⁷</a></td> </tr> <tr> <td style="padding-left: 2em;">Font Face</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Font Size</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Bold</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Italic</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Strikethrough</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Underline</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Superscript</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Subscript</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Borders</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">● <a href="#footnote7">⁷</a></td> </tr> <tr> <td style="padding-left: 2em;">Line Style</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Position</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 3em;">Diagonal</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetHyperlink">Hyperlinks</a></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">http</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 0.5em;">Merged Cells</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetComment"><strong>Cell Comments</strong></a></td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> </tr> <tr> <td style="padding-left: 2em;">Rich Text</td> <td style="text-align: center; color: red;">✖ <a href="#footnote2">²</a></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Alignment</td> <td style="text-align: center; color: red;">✖ <a href="#footnote3">³</a></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Background Image</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetCellValidation"><strong>Cell Validation</strong></a></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetAutoFilter"><strong>AutoFilters</strong></a></td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td><strong>AutoFilter Expressions</strong></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Filter</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Custom Filter</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Date Filter</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Dynamic Filter</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Colour Filter</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Icon Filter</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Top 10 Filter</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetMacro"><strong>Macros</strong></a></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: orange;">● <a href="#footnote5"><sup>5</sup</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Form Controls</strong></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: orange;">● <a href="#footnote4"><sup>4</sup</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetSecurity"><strong>Security</strong></a></td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Protection (prevent editing)</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Encryption (prevent viewing)</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <th></th> <th>XLS</th> <th>XLSX</th> <th>Excel2003XML</th> <th>Ods</th> <th>Gnumeric</th> <th>CSV</th> <th>SYLK</th> <th>HTML</th> </tr> <tr> <th></th> <th colspan="8">Readers</th> </tr> </table>

1. <span id="footnote1">Only text contents</span>
2. <span id="footnote2">Only BIFF8 files support Rich Text. Prior to that, comments could only be plain text</span>
3. <span id="footnote3">Only BIFF8 files support alignment and rotation. Prior to that, comments could only be unformatted text</span>
4. <span id="footnote4">Xlsx forms and controls can be read and written but not otherwise manipulated</span>
5. <span id="footnote5">Xlsx macros can be read and written; their values can be retrieved and changed, but only in a binary form which is unlikely to be useful</span>
6. <span id="footnote6">There is very limited support for reading styles from an Ods spreadsheet before release 5.5.0. Writing styles has much better support. Starting with release 5.5.0, Number Format Writer supports many common styles, and users may extend support to additional styles; Reader support for Number Formats is improved but still imperfect; for other styles, it is much improved.</span>
7. <span id="footnote7">In most cases, Html reader processes only inline styles; styles provided by Css classes may be ignored.</span>
8. <span id="footnote8">Code must opt in to array output.</span>
9. <span id="footnote9">Use with caution - allowing external images may can subject the caller to security exploits. Starting with release 4.5.0 (also earlier releases 3.9.3, 2.3.10, 2.1.11, and 1.29.12), code can allow or not external images. In those starting releases, and in earlier releases which do not offer an option, default is to allow it. In release 5+ (and earlier supported versions 1.30+, 2.1.12+, 2.4+, and 3.10+), the default is to not allow it.</span>

Writers

<table class="features-cross-reference"> <tr> <th></th> <th colspan="6">Writers</th> </tr> <tr> <th></th> <th>XLS</th> <th>XLSX</th> <th>Ods</th> <th>CSV</th> <th>HTML</th> <th>PDF</th> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Document Properties</strong></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 1em;"><a href="#setGetStdProp">Standard Properties</a></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">Creator</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Creation Date/Time</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Modifier</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Modified Date/Time</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Title</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Description</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Subject</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Keywords</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;"><a href="#setGetExtProp">Extended Properties</a></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">Category</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Company</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Manager</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 1em;"><a href="#setGetCustProp">User-Defined (Custom) Properties</a></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 0.5em;">Rich Text</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Conditional Formatting</strong></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Array Formula<a href="#footnote8">⁸</a></strong></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Rows and Column Properties</strong></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 1em;">Row Height/Column Width</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Hidden</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Worksheet Properties</strong></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 1em;">Frozen Panes</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 1em;">Hidden Worksheets</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 1em;">Coloured Tabs</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetDrawingHyperlink"><strong>Drawing hyperlink</strong></a></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Cell Formatting</strong></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 1em;">Number Format Mask</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔<a href="#footnote6">⁶</a></td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Alignment</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Horizontal</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Vertical</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Wrapping</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Shrink-to-Fit</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Indent</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Background Colour</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Patterned</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 1em;">Font Attributes</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">Font Face</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Font Size</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Bold</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Italic</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Strikethrough</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Underline</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Superscript</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Subscript</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 1em;">Borders</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">Line Style</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 2em;">Position</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 3em;">Diagonal</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetHyperlink"><strong>Hyperlinks</strong></a></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 1em;">http</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Merged Cells</strong></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetComment"><strong>Cell Comments</strong></a></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center; color: orange;">●</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: orange;">● <a href="#footnote1">¹</a></td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 1em;">Rich Text</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 1em;">Alignment</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 1em;">Background Image</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetCellValidation"><strong>Cell Validation</strong></a></td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetAutoFilter"><strong>AutoFilters</strong></a></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">AutoFilter Expressions</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Filter</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Custom Filter</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">DateGroup Filter</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Dynamic Filter</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Colour Filter</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Icon Filter</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 2em;">Top 10 Filter</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> <td style="text-align: center;">N/A</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetMacro"><strong>Macros</strong></a></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: orange;">● <a href="#footnote5"><sup>5</sup</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><strong>Form Controls</strong></td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: orange;">● <a href="#footnote4"><sup>4</sup</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 0.5em;"><a href="#setGetSecurity"><strong>Security</strong></a></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">Protection (prevent editing)</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: green;">✔</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <td style="padding-left: 2em;">Encryption (prevent viewing)</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center;">N/A</td> <td style="text-align: center; color: red;">✖</td> <td style="text-align: center; color: red;">✖</td> </tr> <tr> <th></th> <th>XLS</th> <th>XLSX</th> <th>Ods</th> <th>CSV</th> <th>HTML</th> <th>PDF</th> </tr> <tr> <th></th> <th colspan="6">Writers</th> </tr> </table>

Setters and Getters

<table class="features-cross-reference"> <tr> <th></th> <th colspan="2">Methods</th> </tr> <tr> <th></th> <th>Getters</th> <th>Setters</th> </tr> <tr> <td id="setGetReaderOptions"><strong>Reader Options</strong></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 1em;">Read Data Only (no formatting)</td> <td>$reader-&gt;getReadDataOnly()</td> <td>$reader-&gt;setReadDataOnly()</td> </tr> <tr> <td style="padding-left: 1em;">Read Only Specified Worksheets</td> <td>$reader-&gt;getLoadSheetsOnly()</td> <td>$reader-&gt;setLoadSheetsOnly() $reader-&gt;setLoadAllSheets()</td> </tr> <tr> <td style="padding-left: 1em;">Read Only Specified Cells</td> <td>$reader-&gt;getReadFilter()</td> <td>$reader-&gt;setReadFilter()</td> </tr> <tr> <td><strong>Document Properties</strong></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 1em;" id="setGetStdProp">Standard Properties</td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">Creator</td> <td>$spreadsheet-&gt;getProperties()-&gt;getCreator()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setCreator()</td> </tr> <tr> <td style="padding-left: 2em;">Creation Date/Time</td> <td>$spreadsheet-&gt;getProperties()-&gt;getCreated()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setCreated()</td> </tr> <tr> <td style="padding-left: 2em;">Modifier</td> <td>$spreadsheet-&gt;getProperties()-&gt;getLastModifiedBy()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setLastModifiedBy()</td> </tr> <tr> <td style="padding-left: 2em;">Modified Date/Time</td> <td>$spreadsheet-&gt;getProperties()-&gt;getModified()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setModified()</td> </tr> <tr> <td style="padding-left: 2em;">Title</td> <td>$spreadsheet-&gt;getProperties()-&gt;getTitle()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setTitle()</td> </tr> <tr> <td style="padding-left: 2em;">Description</td> <td>$spreadsheet-&gt;getProperties()-&gt;getDescription()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setDescription()</td> </tr> <tr> <td style="padding-left: 2em;">Subject</td> <td>$spreadsheet-&gt;getProperties()-&gt;getSubject()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setSubject()</td> </tr> <tr> <td style="padding-left: 2em;">Keywords</td> <td>$spreadsheet-&gt;getProperties()-&gt;getKeywords()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setKeywords()</td> </tr> <tr> <td style="padding-left: 1em;" id="setGetExtProp">Extended Properties</td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">Category</td> <td>$spreadsheet-&gt;getProperties()-&gt;getCategory()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setCategory()</td> </tr> <tr> <td style="padding-left: 2em;">Company</td> <td>$spreadsheet-&gt;getProperties()-&gt;getCompany()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setCompany()</td> </tr> <tr> <td style="padding-left: 2em;">Manager</td> <td>$spreadsheet-&gt;getProperties()-&gt;getManager()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setManager()</td> </tr> <tr> <td style="padding-left: 1em;" id="setGetCustProp">User-Defined (Custom) Properties</td> <td>$spreadsheet-&gt;getProperties()-&gt;getCustomProperties() $spreadsheet-&gt;getProperties()-&gt;isCustomPropertySet() $spreadsheet-&gt;getProperties()-&gt;getCustomPropertyValue() $spreadsheet-&gt;getProperties()-&gt;getCustomPropertyType()</td> <td>$spreadsheet-&gt;getProperties()-&gt;setCustomProperty()</td> </tr> <tr> <td style="padding-left: 1em;" id="setGetDrawingHyperlink">Drawing hyperlink</td> <td>$drawing->getHyperlink()->getUrl()</td> <td>$drawing->setHyperlink()->setUrl($url)</td> </tr> <tr> <td style="padding-left: 1em;" id="setGetHyperlink">Hyperlinks</td> <td>$cell->getHyperlink()->getUrl($url)</td> <td>$cell->getHyperlink()->setUrl($url)</td> </tr> <tr> <td id="setGetComment"><strong>Cell Comments</strong></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">Background Image</td> <td>$comment->getBackgroundImage()</td> <td>$comment->setBackgroundImage()</td> </tr> <tr> <td id="setGetCellValidation"><strong>Cell Validation</strong></td> <td>$cell->getDataValidation()</td> <td>$cell->setDataValidation()</td> </tr> <tr> <td id="setGetAutoFilter"><strong>AutoFilters</strong></td> <td>$sheet->getAutoFilter()</td> <td>$sheet->setAutoFilter()</td> </tr> <tr> <td id="setGetMacro"><strong>Macros</strong></td> <td>$spreadsheet->getMacrosCode();<a href="#footnote5">⁵</td> <td>$spreadsheet->setMacrosCode();<a href="#footnote5">⁵</td> </tr> <tr> <td id="setGetSecurity"><strong>Security</strong></td> <td></td> <td></td> </tr> <tr> <td style="padding-left: 2em;">Protection (prevent editing)</td> <td>$sheet->getProtection()</td> <td>$sheet->getProtection()->setSheet(true)</td> </tr> <tr> <th></th> <th>Getters</th> <th>Setters</th> </tr> <tr> <th></th> <th colspan="2">Methods</th> </tr> </table>