{ "_id": "6a1293d3acfb0bcc41d0bbd6", "Package": "joinXL", "Title": "Perform Joins or Minus Queries on 'Excel' Files", "Version": "1.0.1", "Authors@R": "person(\"Yvonne\", \"Glanville\", email = \"yvonneglanville@gmail.com\", role = c(\"aut\", \"cre\"))", "Description": "Performs Joins and Minus Queries on 'Excel' Files\nfulljoinXL() Merges all rows of 2 'Excel' files based upon a\ncommon column in the files. innerjoinXL() Merges all rows from\nbase file and join file when the join condition is met.\nleftjoinXL() Merges all rows from the base file, and all rows\nfrom the join file if the join condition is met. rightjoinXL()\nMerges all rows from the join file, and all rows from the base\nfile if the join condition is met. minusXL() Performs 2\noperations source-minus-target and target-minus-source If the\nfiles are identical all output files will be empty. Choose two\n'Excel' files via a dialog box, and then follow prompts at the\nconsole to choose a base or source file and columns to merge or\nminus on.", "VignetteBuilder": "knitr", "License": "GPL-3", "Encoding": "UTF-8", "URL": "http://github.com/yvonneglanville/joinXL", "BugReports": "http://github.com/yvonneglanville/joinXL/issues", "RoxygenNote": "5.0.1", "Config/pak/sysreqs": "make default-jdk libicu-dev", "Repository": "https://yvonneglanville.r-universe.dev", "Date/Publication": "2016-09-12 00:03:09 UTC", "RemoteUrl": "https://github.com/yvonneglanville/joinxl", "RemoteRef": "HEAD", "RemoteSha": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-24 05:56:48 UTC", "User": "root" }, "Author": "Yvonne Glanville [aut, cre]", "Maintainer": "Yvonne Glanville ", "MD5sum": "2ce0b0271fb517fd7694b5b466bb70a0", "_user": "yvonneglanville", "_type": "src", "_file": "joinXL_1.0.1.tar.gz", "_fileid": "ddbaaf0715df254f2de7a60e593d8a4025e42906840fc815cd07377da0d2ea35", "_filesize": 91240, "_sha256": "ddbaaf0715df254f2de7a60e593d8a4025e42906840fc815cd07377da0d2ea35", "_created": "2026-05-24T05:56:48.000Z", "_published": "2026-05-24T05:59:47.346Z", "_distro": "noble", "_jobs": [ { "job": 77575640883, "time": 144, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7182690906" }, { "job": 77575640878, "time": 141, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7182690669" }, { "job": 77575640875, "time": 139, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7182688579" }, { "job": 77575640876, "time": 128, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7182687430" }, { "job": 77575474562, "time": 188, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7182675719" }, { "job": 77575640870, "time": 124, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7182688882" }, { "job": 77575640877, "time": 97, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7182686608" }, { "job": 77575640891, "time": 80, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7182684455" }, { "job": 77575640887, "time": 95, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7182686039" } ], "_buildurl": "https://github.com/r-universe/yvonneglanville/actions/runs/26353381369", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/yvonneglanville/joinxl", "_commit": { "id": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "author": "Yvonne Glanville ", "committer": "Yvonne Glanville ", "message": "added examples to man\n", "time": 1473638589 }, "_maintainer": { "name": "Yvonne Glanville", "email": "yvonneglanville@gmail.com", "login": "yvonneglanville", "description": "", "uuid": 21081538 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.3.1", "role": "Depends" }, { "package": "readxl", "version": ">= 0.1.1", "role": "Imports" }, { "package": "openxlsx", "version": ">= 3.0.0", "role": "Imports" }, { "package": "timeSeries", "version": ">= 3022.101.2", "role": "Imports" }, { "package": "data.table", "version": ">= 1.9.6", "role": "Imports" }, { "package": "rChoiceDialogs", "version": ">= 1.0.6", "role": "Imports" }, { "package": "R.utils", "version": ">= 2.3.0", "role": "Imports" }, { "package": "rJava", "version": ">= 0.9-8", "role": "Imports" }, { "package": "graphics", "version": ">= 3.3.1", "role": "Imports" }, { "package": "Rcpp", "version": ">= 0.11.1", "role": "Imports" }, { "package": "grDevices", "version": ">= 3.3.1", "role": "Imports" }, { "package": "stats", "version": ">= 3.3.1", "role": "Imports" }, { "package": "timeDate", "version": ">= 2150.95", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "yvonneglanville", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 1, "_contributors": [ { "user": "yvonneglanville", "count": 24, "uuid": 21081538 } ], "_userbio": { "uuid": 21081538, "type": "user", "name": "yvonneglanville" }, "_downloads": { "count": 201, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/joinXL" }, "_devurl": "https://github.com/yvonneglanville/joinxl", "_searchresults": 5, "_topics": [ "openjdk" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/joinXL.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/yvonneglanville/joinxl", "_realowner": "yvonneglanville", "_cranurl": true, "_releases": [ { "version": "1.0.0", "date": "2016-08-29" }, { "version": "1.0.1", "date": "2016-09-18" } ], "_exports": [ "fulljoinXL", "innerjoinXL", "leftjoinXL", "minusXL", "rightjoinXL" ], "_help": [ { "page": "fulljoinXL", "title": "Performs a SQL type full join on 2 Excel files", "topics": [ "fulljoinXL", "fulljoinXL()" ] }, { "page": "innerjoinXL", "title": "Performs a SQL type inner join on 2 Excel files", "topics": [ "innerjoinXL", "innerjoinXL()" ] }, { "page": "leftjoinXL", "title": "Performs a SQL type left join on 2 Excel files", "topics": [ "leftjoinXL", "leftjoinXL()" ] }, { "page": "minusXL", "title": "Performs a SQL type minus query on 2 Excel files", "topics": [ "minusXL", "minusXL()" ] }, { "page": "rightjoinXL", "title": "Performs a SQL type right join on 2 Excel files", "topics": [ "rightjoinXL", "rightjoinXL()" ] } ], "_readme": "https://github.com/yvonneglanville/joinxl/raw/HEAD/README.md", "_rundeps": [ "cellranger", "cli", "cpp11", "crayon", "data.table", "glue", "hms", "lifecycle", "magrittr", "openxlsx", "pillar", "pkgconfig", "prettyunits", "progress", "R.methodsS3", "R.oo", "R.utils", "R6", "rChoiceDialogs", "Rcpp", "readxl", "rematch", "rJava", "rlang", "stringi", "tibble", "timeDate", "timeSeries", "utf8", "vctrs", "zip" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-21-jre-headless", "headers": "openjdk-21-jre-headless", "source": "openjdk", "version": "21.0.10+7-1~24.04", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_vignettes": [ { "source": "Functionality.Rmd", "filename": "Functionality.html", "title": "joinXL Functions", "author": "Yvonne Glanville", "engine": "knitr::rmarkdown", "headings": [ "joinXL functions perform 'SQL' type joins of 'Excel' files", "Minus Query" ], "created": "2016-08-29 13:23:05", "modified": "2016-08-29 18:07:45", "commits": 2 } ], "_score": 3.6989700043360187, "_indexed": true, "_nocasepkg": "joinxl", "_universes": [ "yvonneglanville" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.1", "date": "2026-05-24T05:59:04.000Z", "distro": "noble", "commit": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "fileid": "dc6cbb635dccaa2b3a68af15714406e9383a40095fac8a473d504cd992b90367", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/yvonneglanville/actions/runs/26353381369" }, { "r": "4.6.0", "os": "linux", "version": "1.0.1", "date": "2026-05-24T05:59:02.000Z", "distro": "noble", "commit": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "fileid": "b746f1dc6a74b1c2ee03dd6fd79409da8af7ece09823534a3c844834228be9af", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/yvonneglanville/actions/runs/26353381369" }, { "r": "4.5.3", "os": "mac", "version": "1.0.1", "date": "2026-05-24T05:58:52.000Z", "commit": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "fileid": "3d959935627c16d91ce68db9bbb459fa67fc5a6d0aa6c5a335b4fb1a35f082c7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/yvonneglanville/actions/runs/26353381369" }, { "r": "4.6.0", "os": "mac", "version": "1.0.1", "date": "2026-05-24T05:58:39.000Z", "commit": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "fileid": "16f78f850f94f7b2a61e96d84d3496a25efab9cf1b3743d6000a20b41ffd56f5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/yvonneglanville/actions/runs/26353381369" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.1", "date": "2026-05-24T05:59:08.000Z", "commit": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "fileid": "b0eeb29ecc564c41562fd904c75ab75cd100eb9aee5e77f579ce96b2a4c8f99f", "status": "success", "buildurl": "https://github.com/r-universe/yvonneglanville/actions/runs/26353381369" }, { "r": "4.7.0", "os": "win", "version": "1.0.1", "date": "2026-05-24T05:58:18.000Z", "commit": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "fileid": "cc2133383e9b7723925e2f48e36ce5db6c8f34a06493a90a6d7632a2835fffcd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/yvonneglanville/actions/runs/26353381369" }, { "r": "4.5.3", "os": "win", "version": "1.0.1", "date": "2026-05-24T05:57:57.000Z", "commit": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "fileid": "40cce22bae5f850145df62909b27e027228b18eea1302a640889bdc8592b087a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/yvonneglanville/actions/runs/26353381369" }, { "r": "4.6.0", "os": "win", "version": "1.0.1", "date": "2026-05-24T05:58:12.000Z", "commit": "741f6eaa611bc1d290a5edea40f09ed9411f8dfb", "fileid": "34d83761af34681dadce326333882860ef10855699e8570c3c3630f6d486f1bf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/yvonneglanville/actions/runs/26353381369" } ] }