The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

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:

Reference manual: joinXL.pdf
Vignettes: joinXL Functions

Downloads:

Package source: joinXL_1.0.1.tar.gz
Windows binaries: r-devel: joinXL_1.0.1.zip, r-release: joinXL_1.0.1.zip, r-oldrel: joinXL_1.0.1.zip
macOS binaries: r-release (arm64): joinXL_1.0.1.tgz, r-oldrel (arm64): joinXL_1.0.1.tgz, r-release (x86_64): joinXL_1.0.1.tgz, r-oldrel (x86_64): joinXL_1.0.1.tgz
Old sources: joinXL archive

Linking:

Please use the canonical form https://CRAN.R-project.org/package=joinXL to link to this page.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.