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
Package: tidyxl 1.0.10
tidyxl: Read Untidy Excel Files
Imports non-tabular from Excel files into R. Exposes cell content, position and formatting in a tidy structure for further manipulation. Tokenizes Excel formulas. Supports '.xlsx' and '.xlsm' via the embedded 'RapidXML' C++ library <https://rapidxml.sourceforge.net>. Does not support '.xlsb' or '.xls'.
Authors:
tidyxl_1.0.10.tar.gz
tidyxl_1.0.10.zip(r-4.7)tidyxl_1.0.10.zip(r-4.6)tidyxl_1.0.10.zip(r-4.5)
tidyxl_1.0.10.tgz(r-4.6-x86_64)tidyxl_1.0.10.tgz(r-4.6-arm64)tidyxl_1.0.10.tgz(r-4.5-x86_64)tidyxl_1.0.10.tgz(r-4.5-arm64)
tidyxl_1.0.10.tar.gz(r-4.7-arm64)tidyxl_1.0.10.tar.gz(r-4.7-x86_64)tidyxl_1.0.10.tar.gz(r-4.6-arm64)tidyxl_1.0.10.tar.gz(r-4.6-x86_64)
tidyxl_1.0.10.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
tidyxl/json (API)
| # Install 'tidyxl' in R: |
| install.packages('tidyxl', repos = c('https://nacnudus.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/nacnudus/tidyxl/issues
Pkgdown/docs site:https://nacnudus.github.io
Datasets:
- excel_functions - Names of all Excel functions
- xlsx_color_standard - Names and RGB values of Excel standard colours
- xlsx_colour_standard - Names and RGB values of Excel standard colours
excelreaderrcppspreadsheettidycpp
Last updated from:7e2fbe7cc7. Checks:13 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-arm64 | OK | 181 | ||
| linux-devel-x86_64 | OK | 202 | ||
| source / vignettes | OK | 309 | ||
| linux-release-arm64 | OK | 180 | ||
| linux-release-x86_64 | OK | 219 | ||
| macos-release-arm64 | OK | 125 | ||
| macos-release-x86_64 | OK | 338 | ||
| macos-oldrel-arm64 | OK | 115 | ||
| macos-oldrel-x86_64 | OK | 245 | ||
| windows-devel | OK | 224 | ||
| windows-release | OK | 171 | ||
| windows-oldrel | OK | 173 | ||
| wasm-release | OK | 205 |
Exports:is_date_formatis_rangemaybe_xlsxtidy_xlsxxlexxlsx_cellsxlsx_color_themexlsx_colour_themexlsx_formatsxlsx_namesxlsx_sheet_namesxlsx_validation
Tidyxl
Last update: 2023-10-29
Started: 2017-01-18
Detecting Spreadsheet Smells with xlex()
Inspecting the parse tree | Detecting constants inside formulas | One formula | Many formulas | Visualising constants | Detecting deeply nested formulas
Last update: 2020-11-09
Started: 2017-09-01
Data Validation Rules
What data validation rules are | Joining rules to cells
Last update: 2017-11-04
Started: 2017-10-13
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| tidyxl: Import xlsx (Excel) spreadsheet data and formatting into tidy structures. | tidyxl-package tidyxl |
| Names of all Excel functions | excel_functions |
| Test that Excel number formats are date formats | is_date_format |
| Test that Excel formulas are ranges | is_range |
| Determine file format | maybe_xlsx |
| Import xlsx (Excel) cell contents into a tidy structure. | tidy_xlsx |
| Parse xlsx (Excel) formulas into tokens | xlex |
| Import xlsx (Excel) cell contents into a tidy structure. | xlsx_cells |
| Names and RGB values of Excel standard colours | xlsx_color_standard xlsx_colour_standard |
| Import theme color definitions from xlsx (Excel) files | xlsx_color_theme xlsx_colour_theme |
| Import xlsx (Excel) formatting definitions. | xlsx_formats |
| Import named formulas from xlsx (Excel) files | xlsx_names |
| List sheets in an xlsx (Excel) file | xlsx_sheet_names |
| Import data validation rules of cells in xlsx (Excel) files | xlsx_validation |
