R Observatory: Metrics for joinXL version 1.0.1

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

joinXL

1.0.1

Perform Joins or Minus Queries on 'Excel' Files

0packages depend

2.5Kdownloads / year

–test coverage

13/13checks pass

Overview

About

Maintained by Yvonne GlanvilleFirst published 2016-08-302 releasesCRAN page ↗GitHub ↗

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.

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("joinXL", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("yvonneglanville/joinXL")

Development version from yvonneglanville/joinXL. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-joinxl

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-joinXL

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-joinXL

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 1.7 min · r-oldrel-windows-x86_64

Code health

None

Tests · ratio 0.00

not tracked

Coverage

100%

Documentation · exports

12

Dependencies · direct

Check history

OK2026-08-05
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-08-01
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-04-25
12 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-04-06
11 OK · 3 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-04-04
10 OK · 3 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE

Show 1 earlier snapshots

NOTE2026-03-10
11 OK · 3 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 372 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 67% structuredCode of conductNoContributing guideNo

Examples that run: 0%
Documented parameters: not tracked
Return-value docs: 100%
References docs: 0%

Downloads

2.5K

CRAN downloads in the past year

Rank #19,057 · ~7/day · ~212/mo

Releases R versions

Daily download trend is not available in this view yet.

16930 days

57690 days

2.5K1 year

Compare downloads with other packages →

Also on91 r2u

Repository

GitHub ↗ yvonneglanville/joinxl

1Stars

0Forks

0Open issues

0Open PRs

0Releases

31Commits

2Contributors

31 commits · Last activity 2016-09-12

Stars over time

2019-11-01 · 12026-07-07 · 1

Repository practices

Upstream repositoryBeta

4 development-tooling and community-health practices detected across 4 families in the upstream repository

Checks run against github.com/yvonneglanville/joinxl on 2026-08-16.

Continuous integration (1)

Travis CI

CRAN release process (1)

cran-comments.md

Docs source (1)

README.Rmd

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

11 external dependencies (excludes base and recommended)

Depends (1)

R >= 3.3.1

Imports (12)

readxl openxlsx timeSeries (>= 3022.101.2)data.table rChoiceDialogs R.utils rJavagraphicsRcppgrDevicesstatstimeDate

LinkingTo (0)

none

Suggests (2)

knitr rmarkdown

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (1)

Maintainer (1)

Yvonne Glanville

Author, Maintainer

Authors (1)

Yvonne Glanville

Author, Maintainer

Package Timeline

2 releases. Pick two to compare their code metrics. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
R
R 4.3.0 released · 2023-04-21
R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
R
R 4.0.0 released · 2020-04-24
R
R 3.6.0 released · 2019-04-26
R
R 3.5.0 released · 2018-04-23
R
R 3.4.0 released · 2017-04-21
1.0.1Latest
2016-09-19 · current release · diff ↗
1.0.0
2016-08-30
R
R 3.3.0 released · 2016-05-03

Package metadata

First published: 2016-08-30
Total releases: 2 / 10 yrs
License: GPL-3 OSI
Minimum R: ≥ 3.3.1
Download size: 8.4 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("joinXL")

Format

Glanville, Y. (2016). joinXL: Perform Joins or Minus Queries on 'Excel' Files (Version 1.0.1) [Computer software]. https://doi.org/10.32614/CRAN.package.joinXL

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for joinXL version 1.0.1 [Data set]. HJJB, LLC. Data release v2026-08-16. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-16, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →