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.5)tidyxl_1.0.10.zip(r-4.4)tidyxl_1.0.10.zip(r-4.3)
tidyxl_1.0.10.tgz(r-4.4-arm64)tidyxl_1.0.10.tgz(r-4.4-x86_64)tidyxl_1.0.10.tgz(r-4.3-arm64)tidyxl_1.0.10.tgz(r-4.3-x86_64)
tidyxl_1.0.10.tar.gz(r-4.5-noble)tidyxl_1.0.10.tar.gz(r-4.4-noble)
tidyxl.pdf |tidyxl.html✨
tidyxl/json (API)
NEWS
| # 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
- 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
excelreaderrcppspreadsheettidy
Last updated 7 months agofrom:7e2fbe7cc7
Exports:is_date_formatis_rangemaybe_xlsxtidy_xlsxxlexxlsx_cellsxlsx_color_themexlsx_colour_themexlsx_formatsxlsx_namesxlsx_sheet_namesxlsx_validation
Data Validation Rules
Rendered fromdata-validation-rules.Rmdusingknitr::rmarkdownon Jun 23 2024.Last update: 2017-11-04
Started: 2017-10-13
Detecting Spreadsheet Smells with xlex()
Rendered fromsmells.Rmdusingknitr::rmarkdownon Jun 23 2024.Last update: 2020-11-09
Started: 2017-09-01
Tidyxl
Rendered fromtidyxl.Rmdusingknitr::rmarkdownon Jun 23 2024.Last update: 2023-10-29
Started: 2017-01-18
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 |
