{
  "_id": "6ac65867f511ae58c09aa61b",
  "Package": "excelsior",
  "Title": "Streamlines Excel File Automation",
  "Version": "0.0.1",
  "Authors@R": "person(\"Collin\", \"Edwards\", , \"Collin.Edwards@dfw.wa.gov\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-4937-5159\"))",
  "Description": "Useful tools for automation of excel file data entry,\nespecially transferring parts of one sheet into a sheet of\nanother file.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.2",
  "URL": "https://github.com/cbedwards-dfw/excelsior,\nhttps://cbedwards-dfw.github.io/excelsior/,\nhttps://framverse.r-universe.dev/excelsior,",
  "BugReports": "https://github.com/cbedwards-dfw/excelsior/issues",
  "Config/testthat/edition": "3",
  "Language": "en-US",
  "Remotes": [
    "cbedwards-dfw/xldiff"
  ],
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "libcairo2-dev cmake libfontconfig1-dev\nlibfreetype6-dev libfribidi-dev make libharfbuzz-dev libicu-dev\nlibjpeg-dev libpng-dev libtiff-dev libuv1-dev libwebp-dev\nlibxml2-dev libssl-dev",
  "Repository": "https://framverse.r-universe.dev",
  "Date/Publication": "2026-06-04 00:17:45 UTC",
  "RemoteUrl": "https://github.com/cbedwards-dfw/excelsior",
  "RemoteRef": "HEAD",
  "RemoteSha": "283cdb863e07d7fe5dba710f4d9ff51688607438",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-07 11:56:03 UTC",
    "User": "root"
  },
  "Author": "Collin Edwards [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-4937-5159>)",
  "Maintainer": "Collin Edwards <Collin.Edwards@dfw.wa.gov>",
  "_user": "framverse",
  "_type": "src",
  "_file": "excelsior_0.0.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/35836bea3143b481d85f32c4b89f7200a72dac5f46c5c98edc54d4ef2cb4daaa",
  "_filesize": 271892,
  "_sha256": "35836bea3143b481d85f32c4b89f7200a72dac5f46c5c98edc54d4ef2cb4daaa",
  "_expires": "2027-01-15T14:34:13.000Z",
  "_created": "2026-10-07T11:56:03.000Z",
  "_published": "2026-10-07T14:34:15.331Z",
  "_buildurl": "https://github.com/r-universe/framverse/actions/runs/37616757810",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 112779233730,
      "time": 122,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11480163155"
    },
    {
      "job": 112779233819,
      "time": 127,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11481007010"
    },
    {
      "job": 112779233788,
      "time": 91,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11490771809"
    },
    {
      "job": 112779233752,
      "time": 105,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11489368706"
    },
    {
      "job": 112776989549,
      "time": 359,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11479947578"
    },
    {
      "job": 112779233764,
      "time": 132,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11480277328"
    },
    {
      "job": 112779233716,
      "time": 75,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11479808190"
    },
    {
      "job": 112779233688,
      "time": 76,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11480771992"
    },
    {
      "job": 112779233817,
      "time": 94,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11480562821"
    }
  ],
  "_upstream": "https://github.com/cbedwards-dfw/excelsior",
  "_commit": {
    "id": "283cdb863e07d7fe5dba710f4d9ff51688607438",
    "author": "cbedwards-dfw <155684316+cbedwards-dfw@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #15 from cbedwards-dfw/input_validation\n\nfinished integration of validations",
    "time": 1780532265
  },
  "_maintainer": {
    "name": "Collin Edwards",
    "email": "collin.edwards@dfw.wa.gov",
    "login": "cbedwards-dfw",
    "description": "",
    "uuid": 155684316,
    "orcid": "0000-0002-4937-5159"
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "openxlsx2",
      "role": "Imports"
    },
    {
      "package": "readxl",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "tidyxl",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "xldiff",
      "version": ">= 0.2.0",
      "role": "Imports"
    },
    {
      "package": "zoo",
      "role": "Imports"
    },
    {
      "package": "janitor",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "spelling",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    }
  ],
  "_owner": "cbedwards-dfw",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-05",
      "n": 9
    },
    {
      "week": "2026-06",
      "n": 3
    },
    {
      "week": "2026-22",
      "n": 2
    },
    {
      "week": "2026-23",
      "n": 7
    }
  ],
  "_tags": [],
  "_stars": 1,
  "_contributors": [
    {
      "user": "cbedwards-dfw",
      "count": 33,
      "uuid": 155684316
    }
  ],
  "_userbio": {
    "uuid": 72824513,
    "type": "organization",
    "name": "FRAMverse",
    "followers": 13,
    "description": "FRAM (Fisheries Regulation Assessment Model) Users"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/excelsior"
  },
  "_devurl": "https://github.com/cbedwards-dfw/excelsior",
  "_pkgdown": "https://cbedwards-dfw.github.io/excelsior/",
  "_searchresults": 0,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/excelsior.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_cranurl": false,
  "_exports": [
    "as_numeric_smart",
    "cell_range_translate",
    "clip_to_vec",
    "copy_columns",
    "copy_section",
    "find_fill_color",
    "implant_df",
    "read_excel_tiered_headers",
    "row_finder",
    "row_finder_by_color"
  ],
  "_help": [
    {
      "page": "as_numeric_smart",
      "title": "Convert character vector to numeric with intelligent handling",
      "topics": [
        "as_numeric_smart"
      ]
    },
    {
      "page": "clip_to_vec",
      "title": "Translate copied excel row/column into code to make an R vector",
      "topics": [
        "clip_to_vec"
      ]
    },
    {
      "page": "copy_columns",
      "title": "Copy columns from one Excel file to another with change tracking",
      "topics": [
        "copy_columns"
      ]
    },
    {
      "page": "copy_section",
      "title": "Copy data section between locations in Excel workbook",
      "topics": [
        "copy_section"
      ]
    },
    {
      "page": "find_fill_color",
      "title": "Find fill color of specified cell",
      "topics": [
        "find_fill_color"
      ]
    },
    {
      "page": "implant_df",
      "title": "Directly implant data from dataframe to openxlsx2 workbook",
      "topics": [
        "implant_df"
      ]
    },
    {
      "page": "read_excel_tiered_headers",
      "title": "Read an Excel file with multi-row headers",
      "topics": [
        "read_excel_tiered_headers"
      ]
    },
    {
      "page": "row_finder",
      "title": "Find row number based on an \"anchor cell\"",
      "topics": [
        "row_finder"
      ]
    },
    {
      "page": "row_finder_by_color",
      "title": "Find anchor cell based on fill color",
      "topics": [
        "row_finder_by_color"
      ]
    }
  ],
  "_readme": "https://github.com/cbedwards-dfw/excelsior/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "base64enc",
    "bslib",
    "cachem",
    "cellranger",
    "cli",
    "cpp11",
    "crayon",
    "data.table",
    "digest",
    "dplyr",
    "evaluate",
    "fastmap",
    "flextable",
    "fontawesome",
    "fontBitstreamVera",
    "fontLiberation",
    "fontquiver",
    "fs",
    "gdtools",
    "generics",
    "glue",
    "highr",
    "hms",
    "htmltools",
    "jquerylib",
    "jsonlite",
    "knitr",
    "lattice",
    "lifecycle",
    "magrittr",
    "memoise",
    "mime",
    "officer",
    "openssl",
    "openxlsx2",
    "pillar",
    "piton",
    "pkgconfig",
    "prettyunits",
    "progress",
    "purrr",
    "R6",
    "ragg",
    "rappdirs",
    "Rcpp",
    "readxl",
    "rematch",
    "rlang",
    "rmarkdown",
    "sass",
    "stringi",
    "stringr",
    "sys",
    "systemfonts",
    "textshaping",
    "tibble",
    "tidyr",
    "tidyselect",
    "tidyxl",
    "tinytex",
    "utf8",
    "uuid",
    "vctrs",
    "withr",
    "xfun",
    "xldiff",
    "xml2",
    "yaml",
    "zip",
    "zoo"
  ],
  "_vignettes": [
    {
      "source": "excelsior.Rmd",
      "filename": "excelsior.html",
      "title": "Getting Started with Excelsior",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Overview",
        "Importing from Excel",
        "Dealing with multi-tier headers",
        "Identifying rows via \"anchor cells\"",
        "row_finder()",
        "row_finder_by_color",
        "Putting it all together",
        "Caution",
        "Helper functions",
        "I need to replicate contents from an excel file into an R script",
        "Help, the numeric contents I read in from excel have a weird mix of formatting!",
        "Exporting to Excel / Copying between Excel",
        "Dataframe into Excel",
        "Copying contents safely",
        "Update columns from one file to another"
      ],
      "created": "2026-06-03 19:04:42",
      "modified": "2026-06-03 19:04:42",
      "commits": 1
    }
  ],
  "_score": 3.3010299956639813,
  "_indexed": true,
  "_nocasepkg": "excelsior",
  "_universes": [
    "framverse",
    "cbedwards-dfw"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.0.1",
      "date": "2026-10-07T11:58:07.000Z",
      "distro": "resolute",
      "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438",
      "fileid": "https://r2.ropensci.org/b57fbdef5a0df49590b1113d8c67c23978dbd0b882255f2375061d0e0243c337",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/framverse/actions/runs/37616757810"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.0.1",
      "date": "2026-10-07T11:58:14.000Z",
      "distro": "resolute",
      "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438",
      "fileid": "https://r2.ropensci.org/7f2701cf82c7bbaec70a62075f14492d90b3abaa648fcdc1795b13c3b64bec9c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/framverse/actions/runs/37616757810"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.0.1",
      "date": "2026-10-07T14:33:26.000Z",
      "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438",
      "fileid": "https://r2.ropensci.org/d640f655f03f9f7cb4227493743e94be02761ac92be72abf01c990e2e219d47e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/framverse/actions/runs/37616757810"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.0.1",
      "date": "2026-10-07T14:33:12.000Z",
      "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438",
      "fileid": "https://r2.ropensci.org/d11bd41c33a969278470e80578f69d26db7bc20979bff3fb060324cd852a9b02",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/framverse/actions/runs/37616757810"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.0.1",
      "date": "2026-10-07T11:58:32.000Z",
      "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438",
      "fileid": "https://r2.ropensci.org/80e980e4e496641d20c41c50b8d4d61fae392f2e3f1d9ee440bf70164d3ae564",
      "status": "success",
      "buildurl": "https://github.com/r-universe/framverse/actions/runs/37616757810"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.0.1",
      "date": "2026-10-07T11:57:15.000Z",
      "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438",
      "fileid": "https://r2.ropensci.org/c885a98df9fb3377a4f87b7824ba9f9bff546168ccc94e9dc6b2a439a1c8a671",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/framverse/actions/runs/37616757810"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.0.1",
      "date": "2026-10-07T11:57:22.000Z",
      "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438",
      "fileid": "https://r2.ropensci.org/b505d89026af7113498ecd88785ee536eb1e2a50aef65c1776759230d3d23e5e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/framverse/actions/runs/37616757810"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.0.1",
      "date": "2026-10-07T11:57:28.000Z",
      "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438",
      "fileid": "https://r2.ropensci.org/f69d61e8bc9c619d3e40254603e2ea474bb60244709c439b22e78da960d33a3a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/framverse/actions/runs/37616757810"
    }
  ]
}