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.
| Version: |
1.0.1 |
| Depends: |
R (≥ 3.3.1) |
| Imports: |
readxl (≥ 0.1.1), openxlsx (≥ 3.0.0), timeSeries (≥
3022.101.2), data.table (≥ 1.9.6), rChoiceDialogs (≥ 1.0.6), R.utils (≥ 2.3.0), rJava (≥ 0.9-8), graphics (≥ 3.3.1), Rcpp (≥ 0.11.1), grDevices (≥ 3.3.1), stats (≥ 3.3.1), timeDate (≥ 2150.95) |
| Suggests: |
knitr, rmarkdown |
| Published: |
2016-09-19 |
| DOI: |
10.32614/CRAN.package.joinXL |
| Author: |
Yvonne Glanville [aut, cre] |
| Maintainer: |
Yvonne Glanville <yvonneglanville at gmail.com> |
| BugReports: |
http://github.com/yvonneglanville/joinXL/issues |
| License: |
GPL-3 |
| URL: |
http://github.com/yvonneglanville/joinXL |
| NeedsCompilation: |
no |
| Materials: |
README NEWS |
| CRAN checks: |
joinXL results |
Documentation:
Downloads:
Linking:
Please use the canonical form
https://CRAN.R-project.org/package=joinXL
to link to this page.