tidyxl | Mailing list | Installation | Examples | Formatting | Comments | Formulas | Shared formulas | Array formulas | Formulas referring to other files | Tokenizing formulas | Named ranges | Data validation rules | Philosophy | Similar projects

Preface | 1. Reading easy spreadsheets with | 2. Trying to read a hard spreadsheet with | 3. Demonstration of | 4. Explanation of tidyxl::xlsx_cells() | 5. Explanation of unpivotr::behead() | 6. Continuing unpivotr::behead() | 7. Handling meaningful formatting with unpivotr::behead_if() | 8. Finishing and cleaning up | Review

Introduction | Preparation | Main | Importing the data | Importing one of the multiples | 34-line code listing

Inspecting the parse tree | Detecting constants inside formulas | One formula | Many formulas | Visualising constants | Detecting deeply nested formulas

Rowspan and colspan examples | Rowspan | Colspan | Both rowspan and colspan: non-square | Nested example | URL example

What data validation rules are | Joining rules to cells