{ "_id": "6a4fd205c30f0868bbf1eef0", "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-07-09 16:49:10 UTC", "User": "root" }, "Author": "Collin Edwards [aut, cre] (ORCID:\n)", "Maintainer": "Collin Edwards ", "_user": "framverse", "_type": "src", "_file": "excelsior_0.0.1.tar.gz", "_fileid": "https://r2.ropensci.org/572175e4e010bdcf97e3d03b6bd990acf52e258376e2e4e3dd0a86adebc9ac56", "_filesize": 273728, "_sha256": "572175e4e010bdcf97e3d03b6bd990acf52e258376e2e4e3dd0a86adebc9ac56", "_expires": "2026-10-17T16:53:23.000Z", "_created": "2026-07-09T16:49:10.000Z", "_published": "2026-07-09T16:53:25.612Z", "_jobs": [ { "job": 86176775284, "time": 144, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8205464584" }, { "job": 86176775264, "time": 151, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8205467702" }, { "job": 86176775429, "time": 218, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8205483984" }, { "job": 86176775258, "time": 190, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8205473914" }, { "job": 86175829955, "time": 265, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8205402769" }, { "job": 86176775140, "time": 158, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8205470244" }, { "job": 86176775212, "time": 102, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8205446552" }, { "job": 86176775244, "time": 105, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8205448830" }, { "job": 86176775190, "time": 117, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8205454953" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/framverse/actions/runs/29034521374", "_status": "success", "_upstream": "https://github.com/cbedwards-dfw/excelsior", "_commit": { "id": "283cdb863e07d7fe5dba710f4d9ff51688607438", "author": "cbedwards-dfw <155684316+cbedwards-dfw@users.noreply.github.com>", "committer": "GitHub ", "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/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE", "manual.pdf" ], "_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": [ "cellranger", "cli", "cpp11", "crayon", "dplyr", "generics", "glue", "hms", "lattice", "lifecycle", "magrittr", "openxlsx2", "pillar", "piton", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "Rcpp", "readxl", "rematch", "rlang", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "tidyxl", "utf8", "vctrs", "withr", "xldiff", "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-07-09T16:51:36.000Z", "distro": "resolute", "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438", "fileid": "https://r2.ropensci.org/85e57c575485ec9ddf66e84d1ea9b4737165cf675594a6cd9651f457c807a1d6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/framverse/actions/runs/29034521374" }, { "r": "4.6.1", "os": "linux", "version": "0.0.1", "date": "2026-07-09T16:51:42.000Z", "distro": "resolute", "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438", "fileid": "https://r2.ropensci.org/dc3d65605e8c965db33fb8707ed07126b8424807514e2612c13e321b5ee265e2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/framverse/actions/runs/29034521374" }, { "r": "4.5.3", "os": "mac", "version": "0.0.1", "date": "2026-07-09T16:52:18.000Z", "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438", "fileid": "https://r2.ropensci.org/09959c80bdb702f28fae2530cc0bb981dfd1f16b0df846237a94ba24df04d29f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/framverse/actions/runs/29034521374" }, { "r": "4.6.1", "os": "mac", "version": "0.0.1", "date": "2026-07-09T16:51:48.000Z", "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438", "fileid": "https://r2.ropensci.org/816eb3646547cbc4c2ee8ffd20e385b1c12eafe7d0f64c59af51f06f1ad15840", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/framverse/actions/runs/29034521374" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.1", "date": "2026-07-09T16:52:01.000Z", "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438", "fileid": "https://r2.ropensci.org/ba32bc358e6436010dc5cd89e2a72c10e95bf3fa1cb441cece18592023ec4751", "status": "success", "buildurl": "https://github.com/r-universe/framverse/actions/runs/29034521374" }, { "r": "4.7.0", "os": "win", "version": "0.0.1", "date": "2026-07-09T16:50:46.000Z", "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438", "fileid": "https://r2.ropensci.org/11ed7d6bd9a1aabd985e32897803d7a0b6abcfbc36066e4dcddcc3ba87bd1c5b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/framverse/actions/runs/29034521374" }, { "r": "4.5.3", "os": "win", "version": "0.0.1", "date": "2026-07-09T16:50:52.000Z", "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438", "fileid": "https://r2.ropensci.org/dae4cb724a5e21f0627f5a63b59640e92e84c8b03bd91cdf9c7a1c8e5e161ed2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/framverse/actions/runs/29034521374" }, { "r": "4.6.1", "os": "win", "version": "0.0.1", "date": "2026-07-09T16:51:06.000Z", "commit": "283cdb863e07d7fe5dba710f4d9ff51688607438", "fileid": "https://r2.ropensci.org/085c57fbf48a8daa535311fa13983a64e6049689be7ba0f0b00c34e04aa15694", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/framverse/actions/runs/29034521374" } ] }