Package: joinXL 1.0.1

Yvonne Glanville

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:Yvonne Glanville [aut, cre]

joinXL_1.0.1.tar.gz
joinXL_1.0.1.tar.gz(r-4.5-noble)joinXL_1.0.1.tar.gz(r-4.4-noble)
joinXL_1.0.1.tgz(r-4.4-emscripten)joinXL_1.0.1.tgz(r-4.3-emscripten)
joinXL.pdf |joinXL.html✨
joinXL/json (API)
NEWS

# Install 'joinXL' in R:
install.packages('joinXL', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/yvonneglanville/joinxl/issues

Uses libs:
  • openjdk– OpenJDK Java runtime, using Hotspot JIT

openjdk

2.70 score 1 stars 5 scripts 174 downloads 5 exports 32 dependencies

Last updated 8 years agofrom:e26c8b6414. Checks:OK: 2. Indexed: no.

TargetResultDate
Doc / VignettesOKDec 17 2024
R-4.5-linuxOKDec 17 2024

Exports:fulljoinXLinnerjoinXLleftjoinXLminusXLrightjoinXL

Dependencies:cellrangerclicpp11crayondata.tablefansigluehmslifecyclemagrittropenxlsxpillarpkgconfigprettyunitsprogressR.methodsS3R.ooR.utilsR6rChoiceDialogsRcppreadxlrematchrJavarlangstringitibbletimeDatetimeSeriesutf8vctrszip

joinXL Functions

Yvonne Glanville

Rendered fromFunctionality.Rmdusingknitr::rmarkdownon Dec 17 2024.

Last update: 2016-08-30
Started: 2016-08-30