{ "_id": "6a1d2d7a1d7bb097a0a395ca", "Package": "tidyxl", "Title": "Read Untidy Excel Files", "Version": "1.0.10", "Authors@R": "c(\nperson(\"Duncan\", \"Garmonsway\", email = \"nacnudus@gmail.com\", role = c(\"aut\", \"cre\")),\nperson(\"Hadley\", \"Wickham\", role = c(\"ctb\"), comment = \"Author of included readxl fragments\"),\nperson(\"Jenny\", \"Bryan\", role = c(\"ctb\"), comment = \"Author of included readxl fragments\"),\nperson(\"RStudio\", role = \"cph\", comment = \"Copyright holder of included readxl fragments\"),\nperson(\"Marcin\", \"Kalicinski\", role = c(\"ctb\", \"cph\"), comment = \"Author of included RapidXML code\")\n)", "Description": "Imports non-tabular from Excel files into R. Exposes cell\ncontent, position and formatting in a tidy structure for\nfurther manipulation. Tokenizes Excel formulas. Supports\n'.xlsx' and '.xlsm' via the embedded 'RapidXML' C++ library\n. Does not support '.xlsb'\nor '.xls'.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "LazyData": "true", "URL": "https://github.com/nacnudus/tidyxl,\nhttps://nacnudus.github.io/tidyxl/", "BugReports": "https://github.com/nacnudus/tidyxl/issues", "RoxygenNote": "7.2.3", "VignetteBuilder": "knitr", "Roxygen": "list(markdown = TRUE)", "Config/Needs/website": "tidyverse/tidytemplate", "Repository": "https://nacnudus.r-universe.dev", "Date/Publication": "2023-12-21 12:30:44 UTC", "RemoteUrl": "https://github.com/nacnudus/tidyxl", "RemoteRef": "HEAD", "RemoteSha": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-06-01 06:47:02 UTC", "User": "root" }, "Author": "Duncan Garmonsway [aut, cre],\nHadley Wickham [ctb] (Author of included readxl fragments),\nJenny Bryan [ctb] (Author of included readxl fragments),\nRStudio [cph] (Copyright holder of included readxl fragments),\nMarcin Kalicinski [ctb, cph] (Author of included RapidXML code)", "Maintainer": "Duncan Garmonsway ", "MD5sum": "6c8fb95bf47728f24f0139bd843d31bb", "_user": "nacnudus", "_type": "src", "_file": "tidyxl_1.0.10.tar.gz", "_fileid": "a22179b50e036bdff38eb05890305dbc92a40abf38cfabf9a98f08ff02a58142", "_filesize": 3160168, "_sha256": "a22179b50e036bdff38eb05890305dbc92a40abf38cfabf9a98f08ff02a58142", "_created": "2026-06-01T06:47:02.000Z", "_published": "2026-06-01T06:58:02.245Z", "_distro": "noble", "_jobs": [ { "job": 78800415903, "time": 176, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7325070757" }, { "job": 78800415922, "time": 174, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7325070340" }, { "job": 78800415872, "time": 163, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7325067275" }, { "job": 78800415958, "time": 173, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7325069836" }, { "job": 78800415907, "time": 197, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7325114087" }, { "job": 78800415852, "time": 349, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "7325126605" }, { "job": 78800415870, "time": 159, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7325093123" }, { "job": 78800415876, "time": 359, "config": "macos-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7325171902" }, { "job": 78799921900, "time": 243, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7325024129" }, { "job": 78800415785, "time": 135, "config": "wasm-release", "r": "4.6.0", "check": "FAIL", "artifact": "" }, { "job": 78800415819, "time": 213, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7325080408" }, { "job": 78800415830, "time": 185, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7325074070" }, { "job": 78800415818, "time": 175, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7325070455" } ], "_buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/nacnudus/tidyxl", "_commit": { "id": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "author": "Duncan Garmonsway ", "committer": "GitHub ", "message": "Merge pull request #93 from nacnudus/issue92\n\nSupport inline formatted strings", "time": 1703161844 }, "_maintainer": { "name": "Duncan Garmonsway", "email": "nacnudus@gmail.com", "login": "nacnudus", "description": "", "uuid": 3522552 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.2.0", "role": "Depends" }, { "package": "Rcpp", "role": "LinkingTo" }, { "package": "piton", "version": ">= 1.0.0", "role": "LinkingTo" }, { "package": "Rcpp", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "here", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "readxl", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "tidyr", "role": "Suggests" }, { "package": "purrr", "role": "Suggests" }, { "package": "tibble", "role": "Suggests" }, { "package": "ggplot2", "role": "Suggests" }, { "package": "cellranger", "role": "Suggests" }, { "package": "openxlsx", "role": "Suggests" }, { "package": "rlang", "role": "Suggests" } ], "_owner": "nacnudus", "_selfowned": true, "_usedby": 15, "_updates": [], "_tags": [], "_topics": [ "excelreader", "rcpp", "spreadsheet", "tidy", "cpp" ], "_stars": 255, "_contributors": [ { "user": "nacnudus", "count": 724, "uuid": 3522552 }, { "user": "enchufa2", "count": 1, "uuid": 4542928 }, { "user": "da11an", "count": 1, "uuid": 49221299 } ], "_userbio": { "uuid": 3522552, "type": "user", "name": "Duncan Garmonsway" }, "_downloads": { "count": 1516, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/tidyxl" }, "_devurl": "https://github.com/nacnudus/tidyxl", "_pkgdown": "https://nacnudus.github.io/tidyxl/", "_searchresults": 456, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/tidyxl.html", "manual.pdf" ], "_homeurl": "https://github.com/nacnudus/tidyxl", "_realowner": "nacnudus", "_cranurl": true, "_releases": [ { "version": "0.2.1", "date": "2017-01-29" }, { "version": "0.2.3", "date": "2017-07-08" }, { "version": "1.0.0", "date": "2017-11-25" }, { "version": "1.0.1", "date": "2018-03-28" }, { "version": "1.0.3", "date": "2018-06-21" }, { "version": "1.0.4", "date": "2019-01-02" }, { "version": "1.0.5", "date": "2020-04-02" }, { "version": "1.0.6", "date": "2020-05-09" }, { "version": "1.0.7", "date": "2020-11-16" }, { "version": "1.0.8", "date": "2022-09-02" }, { "version": "1.0.9", "date": "2023-10-30" }, { "version": "1.0.10", "date": "2023-12-22" } ], "_exports": [ "is_date_format", "is_range", "maybe_xlsx", "tidy_xlsx", "xlex", "xlsx_cells", "xlsx_color_theme", "xlsx_colour_theme", "xlsx_formats", "xlsx_names", "xlsx_sheet_names", "xlsx_validation" ], "_datasets": [ { "name": "excel_functions", "title": "Names of all Excel functions", "object": "excel_functions", "class": [ "character" ], "fields": [], "table": false, "tojson": true }, { "name": "xlsx_color_standard", "title": "Names and RGB values of Excel standard colours", "object": "xlsx_color_standard", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "name", "rgb" ], "rows": 10, "table": true, "tojson": true }, { "name": "xlsx_colour_standard", "title": "Names and RGB values of Excel standard colours", "object": "xlsx_colour_standard", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "name", "rgb" ], "rows": 10, "table": true, "tojson": true } ], "_help": [ { "page": "tidyxl-package", "title": "tidyxl: Import xlsx (Excel) spreadsheet data and formatting into tidy structures.", "topics": [ "tidyxl-package", "tidyxl" ] }, { "page": "excel_functions", "title": "Names of all Excel functions", "topics": [ "excel_functions" ] }, { "page": "is_date_format", "title": "Test that Excel number formats are date formats", "topics": [ "is_date_format" ] }, { "page": "is_range", "title": "Test that Excel formulas are ranges", "topics": [ "is_range" ] }, { "page": "maybe_xlsx", "title": "Determine file format", "topics": [ "maybe_xlsx" ] }, { "page": "tidy_xlsx", "title": "Import xlsx (Excel) cell contents into a tidy structure.", "topics": [ "tidy_xlsx" ] }, { "page": "xlex", "title": "Parse xlsx (Excel) formulas into tokens", "topics": [ "xlex" ] }, { "page": "xlsx_cells", "title": "Import xlsx (Excel) cell contents into a tidy structure.", "topics": [ "xlsx_cells" ] }, { "page": "xlsx_color_standard", "title": "Names and RGB values of Excel standard colours", "topics": [ "xlsx_color_standard", "xlsx_colour_standard" ] }, { "page": "xlsx_color_theme", "title": "Import theme color definitions from xlsx (Excel) files", "topics": [ "xlsx_color_theme", "xlsx_colour_theme" ] }, { "page": "xlsx_formats", "title": "Import xlsx (Excel) formatting definitions.", "topics": [ "xlsx_formats" ] }, { "page": "xlsx_names", "title": "Import named formulas from xlsx (Excel) files", "topics": [ "xlsx_names" ] }, { "page": "xlsx_sheet_names", "title": "List sheets in an xlsx (Excel) file", "topics": [ "xlsx_sheet_names" ] }, { "page": "xlsx_validation", "title": "Import data validation rules of cells in xlsx (Excel) files", "topics": [ "xlsx_validation" ] } ], "_readme": "https://github.com/nacnudus/tidyxl/raw/HEAD/README.md", "_rundeps": [ "piton", "Rcpp" ], "_sysdeps": [ { "shlib": "libstdc++", "package": "libstdc++6", "source": "gcc", "version": "14.2.0-4ubuntu2~24.04.1", "name": "c++", "homepage": "http://gcc.gnu.org/", "description": "GNU Standard C++ Library v3" } ], "_vignettes": [ { "source": "data-validation-rules.Rmd", "filename": "data-validation-rules.html", "title": "Data Validation Rules", "author": "Duncan Garmonsway", "engine": "knitr::rmarkdown", "headings": [ "What data validation rules are", "Joining rules to cells" ], "created": "2017-10-13 19:04:28", "modified": "2017-11-04 22:23:38", "commits": 3 }, { "source": "smells.Rmd", "filename": "smells.html", "title": "Detecting Spreadsheet Smells with xlex()", "author": "Duncan Garmonsway", "engine": "knitr::rmarkdown", "headings": [ "Inspecting the parse tree", "Detecting constants inside formulas", "One formula", "Many formulas", "Visualising constants", "Detecting deeply nested formulas" ], "created": "2017-09-01 00:21:34", "modified": "2020-11-09 14:04:46", "commits": 8 }, { "source": "tidyxl.Rmd", "filename": "tidyxl.html", "title": "Tidyxl", "author": "Duncan Garmonsway", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2017-01-18 21:41:55", "modified": "2023-10-29 00:05:08", "commits": 21 } ], "_score": 10.37653799288943, "_indexed": true, "_nocasepkg": "tidyxl", "_universes": [ "nacnudus" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.10", "date": "2026-06-01T06:49:55.000Z", "distro": "noble", "arch": "aarch64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "bf85cd4f5d4d701021dd49ca64c30516b3b62aaa04f1616d1441ff40a25325a9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.7.0", "os": "linux", "version": "1.0.10", "date": "2026-06-01T06:49:51.000Z", "distro": "noble", "arch": "x86_64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "e2cb7f0af3e2272c7adbb79fa74fb06bab248f4bf129cb50a48a1fdde8dbd148", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.6.0", "os": "linux", "version": "1.0.10", "date": "2026-06-01T06:49:41.000Z", "distro": "noble", "arch": "aarch64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "a9292e1dbc77169a8ab6a9cfd99841b0cfc44139d15c6aba707dbb462820f540", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.6.0", "os": "linux", "version": "1.0.10", "date": "2026-06-01T06:49:48.000Z", "distro": "noble", "arch": "x86_64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "679c601392791aefcf2f49492097e4f59ac607a718b76d61fa2e8843815135b5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.5.3", "os": "mac", "version": "1.0.10", "date": "2026-06-01T06:52:54.000Z", "arch": "aarch64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "0f7792533ce1c7ee01025e64010fc0b02b6f7fac1eac13bac1798006f899a6be", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.5.3", "os": "mac", "version": "1.0.10", "date": "2026-06-01T06:52:47.000Z", "arch": "x86_64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "ecb5d8fdc833b0764f01be38fa4a10cb6443f1d9c8d1d8f3a7a91d78a0aac300", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.6.0", "os": "mac", "version": "1.0.10", "date": "2026-06-01T06:51:41.000Z", "arch": "aarch64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "acdc7d1112a6c3c1d320501231b4bab1ed818772ea19fec650c452ca13167f6c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.6.0", "os": "mac", "version": "1.0.10", "date": "2026-06-01T06:55:22.000Z", "arch": "x86_64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "5b5b403cd28fb83ba105f8e9ecb1d372b02e12c359e8dc504de1fb4166ce8016", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.7.0", "os": "win", "version": "1.0.10", "date": "2026-06-01T06:49:00.000Z", "arch": "x86_64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "96153ed73758b3f42fbd858de6b6b88a83d40c652af0c2eb9ef8bf1339136faa", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.5.3", "os": "win", "version": "1.0.10", "date": "2026-06-01T06:49:06.000Z", "arch": "x86_64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "e5440ab30fb482300f676868d76c2dfcc58bc7c55ce706437bf4a9b25cf655f0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" }, { "r": "4.6.0", "os": "win", "version": "1.0.10", "date": "2026-06-01T06:48:54.000Z", "arch": "x86_64", "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5", "fileid": "1e9a2fa3c76cee87605677cf86435c9ab127070d7d68c4a57701bfd56f53a3de", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/26739493500" } ] }