{
  "_id": "6ad0afc4f55ded6d77dfa3f6",
  "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<https://rapidxml.sourceforge.net>.  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-10-15 10:41:34 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 <nacnudus@gmail.com>",
  "_user": "nacnudus",
  "_type": "src",
  "_file": "tidyxl_1.0.10.tar.gz",
  "_fileid": "https://r2.ropensci.org/e758b788a7344cf5d3f8d087f65568cd9198c58d901cdc20e23d6ff06904aab5",
  "_filesize": 3155742,
  "_sha256": "e758b788a7344cf5d3f8d087f65568cd9198c58d901cdc20e23d6ff06904aab5",
  "_expires": "2027-01-23T10:49:38.000Z",
  "_created": "2026-10-15T10:41:34.000Z",
  "_published": "2026-10-15T10:49:40.758Z",
  "_buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 116379154992,
      "time": 139,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11966112911"
    },
    {
      "job": 116379155548,
      "time": 212,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11965903266"
    },
    {
      "job": 116379154927,
      "time": 131,
      "config": "linux-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11965563171"
    },
    {
      "job": 116379155010,
      "time": 213,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11966926679"
    },
    {
      "job": 116379154876,
      "time": 160,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11966117922"
    },
    {
      "job": 116379154893,
      "time": 330,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11966492356"
    },
    {
      "job": 116379154774,
      "time": 146,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11965958064"
    },
    {
      "job": 116379154758,
      "time": 318,
      "config": "macos-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11966517484"
    },
    {
      "job": 116377400115,
      "time": 268,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11966901119"
    },
    {
      "job": 116379154679,
      "time": 138,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11967216130"
    },
    {
      "job": 116379154873,
      "time": 398,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11966502450"
    },
    {
      "job": 116379154739,
      "time": 216,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11966646886"
    },
    {
      "job": 116379154808,
      "time": 199,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11966547000"
    },
    {
      "job": 116379155087,
      "time": 412,
      "config": "windows-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11966477527"
    },
    {
      "job": 116379154960,
      "time": 181,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11966571941"
    }
  ],
  "_upstream": "https://github.com/nacnudus/tidyxl",
  "_commit": {
    "id": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
    "author": "Duncan Garmonsway <nacnudus@gmail.com>",
    "committer": "GitHub <noreply@github.com>",
    "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
  },
  "_distro": "resolute",
  "_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": 257,
  "_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",
    "followers": 121
  },
  "_downloads": {
    "count": 2055,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/tidyxl"
  },
  "_devurl": "https://github.com/nacnudus/tidyxl",
  "_pkgdown": "https://nacnudus.github.io/tidyxl/",
  "_searchresults": 423,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/tidyxl.html",
    "LICENSE"
  ],
  "_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": "16-20260322-1ubuntu1",
      "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.47941908541343,
  "_indexed": true,
  "_nocasepkg": "tidyxl",
  "_universes": [
    "nacnudus"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.0.10",
      "date": "2026-10-15T10:43:53.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/0734028b47aa9ff4c54c644cd045908a14221daa5967164dc3ceee8a9b8d084d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.0.10",
      "date": "2026-10-15T10:44:53.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/d694f12987657bec02d515140ac9275c6a76ca2b7576245410eeb1abc4627f99",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.0.10",
      "date": "2026-10-15T10:43:50.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/6bc43f9e65f6516c7cf249d5a61918f63f464378a0457bafcbbff8342b2e422d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.0.10",
      "date": "2026-10-15T10:44:53.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/a76dac4b53922480782dec3dcf66581a8b77bf22c56196e0386a63950fb208d0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.10",
      "date": "2026-10-15T10:44:06.000Z",
      "arch": "aarch64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/f8dc547dd23cde1d01fb12673fb5d9c6e3f92bf9cc4d72c17a979b3398da65d5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.10",
      "date": "2026-10-15T10:45:33.000Z",
      "arch": "x86_64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/9890cbcfddcd917bad6b22521a2d4e6860db405996f30db8f3b054725662dc3e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.0.10",
      "date": "2026-10-15T10:43:57.000Z",
      "arch": "aarch64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/25f2e160fd8298a5dbb981b1c91a8c6171eca91b762f24687911ef95d97c3c8f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.0.10",
      "date": "2026-10-15T10:45:54.000Z",
      "arch": "x86_64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/aec960c4e78dd977a54cee66d8b58b1a66d9a3a74d8fcb0de4e6647bab8b8634",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.0.10",
      "date": "2026-10-15T10:44:03.000Z",
      "arch": "emscripten",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/1da5f9545496859d5f7524f86ff19340e4fe1aea553e0740b4ea98a5392143a0",
      "status": "success",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.10",
      "date": "2026-10-15T10:46:53.000Z",
      "arch": "aarch64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/9a6263a654a3ed98ff7b1937ff3070be71b5c9e7823de732eb141a0e8c6755b0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.10",
      "date": "2026-10-15T10:43:43.000Z",
      "arch": "x86_64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/8ddf0174d2807fdc519253e2119876f905d514157b0b54edcb912145fefcdede",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.0.10",
      "date": "2026-10-15T10:43:38.000Z",
      "arch": "x86_64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/89e3117cd9e32ad9528faa2e65b954b5d6b91f9f11b77db4bb4804f3ec3c9ad2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.0.10",
      "date": "2026-10-15T10:47:16.000Z",
      "arch": "aarch64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/85f371cd92e3248427dac9c514999a9b56fcdb40d4c206c8ba78b426294b4e28",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.0.10",
      "date": "2026-10-15T10:43:27.000Z",
      "arch": "x86_64",
      "commit": "7e2fbe7cc76b29be6c2f96f86674633f57fb31e5",
      "fileid": "https://r2.ropensci.org/e803a0b4e83202a3f796373852f48c1a75d77846e43ebe1bd9e3e885e9fe22d2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nacnudus/actions/runs/38721582914"
    }
  ]
}