joinXL functions perform 'SQL' type joins of 'Excel' files | Minus Query
Package: joinXL 1.0.1
joinXL: Perform Joins or Minus Queries on 'Excel' Files
Performs Joins and Minus Queries on 'Excel' Files fulljoinXL() Merges all rows of 2 'Excel' files based upon a common column in the files. innerjoinXL() Merges all rows from base file and join file when the join condition is met. leftjoinXL() Merges all rows from the base file, and all rows from the join file if the join condition is met. rightjoinXL() Merges all rows from the join file, and all rows from the base file if the join condition is met. minusXL() Performs 2 operations source-minus-target and target-minus-source If the files are identical all output files will be empty. Choose two 'Excel' files via a dialog box, and then follow prompts at the console to choose a base or source file and columns to merge or minus on.
Authors:
joinXL_1.0.1.tar.gz
joinXL_1.0.1.zip(r-4.7)joinXL_1.0.1.zip(r-4.6)joinXL_1.0.1.zip(r-4.5)
joinXL_1.0.1.tgz(r-4.6-any)joinXL_1.0.1.tgz(r-4.5-any)
joinXL_1.0.1.tar.gz(r-4.7-any)joinXL_1.0.1.tar.gz(r-4.6-any)
joinXL_1.0.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
joinXL/json (API)
| # Install 'joinXL' in R: |
| install.packages('joinXL', repos = c('https://yvonneglanville.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/yvonneglanville/joinxl/issues
Last updated from:741f6eaa61. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 149 | ||
| source / vignettes | OK | 147 | ||
| linux-release-x86_64 | OK | 129 | ||
| macos-release-arm64 | OK | 154 | ||
| macos-oldrel-arm64 | OK | 180 | ||
| windows-devel | OK | 104 | ||
| windows-release | OK | 88 | ||
| windows-oldrel | OK | 124 | ||
| wasm-release | OK | 351 |
Exports:fulljoinXLinnerjoinXLleftjoinXLminusXLrightjoinXL
Dependencies:cellrangerclicpp11crayondata.tablegluehmslifecyclemagrittropenxlsxpillarpkgconfigprettyunitsprogressR.methodsS3R.ooR.utilsR6rChoiceDialogsRcppreadxlrematchrJavarlangstringitibbletimeDatetimeSeriesutf8vctrszip
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Performs a SQL type full join on 2 Excel files | fulljoinXL fulljoinXL() |
| Performs a SQL type inner join on 2 Excel files | innerjoinXL innerjoinXL() |
| Performs a SQL type left join on 2 Excel files | leftjoinXL leftjoinXL() |
| Performs a SQL type minus query on 2 Excel files | minusXL minusXL() |
| Performs a SQL type right join on 2 Excel files | rightjoinXL rightjoinXL() |
