splitr

0.1.0

Fast Utilities for Splitting Excel Sheets

0packages depend

2Kdownloads / year

–test coverage

13/13checks pass

Overview

About

Maintained by Daniel AmahFirst published 2026-03-261 releasesCRAN page ↗

Provides tools for splitting large Excel worksheets into multiple smaller sheets based on a specified number of rows per chunk. The package reads Excel files, partitions the data efficiently using the 'data.table' package, and writes the resulting subsets into a single workbook with multiple sheets using the 'openxlsx' package. This is useful for handling large datasets, preparing data for reporting, and exporting manageable Excel files for downstream analysis.

Install

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

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

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

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-splitr

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-splitr

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-splitr

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

Health

CRAN checks

13OK

Slowest check: 44 s · r-oldrel-windows-x86_64

Code health

Yes

Tests · ratio 1.85

not tracked

Coverage

100%

Documentation · exports

None

Vignettes

Yes

README

Dependencies · direct

Check history

OK2026-03-26
5 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Downloads

CRAN downloads in the past year

Rank #6,883 · ~5/day · ~166/mo

splitr Releases R versions

Daily download trend is not available in this view yet.

50430 days

1.7K90 days

2K1 year

Compare downloads with other packages →

Also on26 r2u4 autocran

Dependencies

Declared dependencies

2 external dependencies (excludes base and recommended)

Depends (0)

none

Imports (2)

data.table openxlsx

LinkingTo (0)

none

Suggests (0)

none

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

Code Composition

R 578 (93%)Rd 45 (7%)

Code characteristics

Cyclomatic complexity: 6.0 median / 6 max
Test cases: 38 / 1.85 per code line
Documented parameters: 100%

Test coverage

Line coverage

–

Expression

–

Tests / Examples

–

Functions

1 1 exported

Complexity

6 avg / 6 max

Call network

1 nodes / 0 edges

Test coverage has not been measured for this package yet; nodes fall back to a neutral fill.

Call graph

Open call graph →

Loading call graph…

Lowest coverage

Per-function coverage is not measured for this package yet.

People & History

People (1)

Maintainer (1)

Daniel Amah

Author, Maintainer

Authors (1)

Daniel Amah

Author, Maintainer

Release timeline

1 release. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
0.1.0Latest
2026-03-26 · current release
R
R 4.5.0 released · 2025-04-11

Package metadata

First published: 2026-03-26
Total releases: 1 / 1 yrs
License: MIT + file LICENSE OSI
Download size: not tracked yet
Installed size: not tracked yet
With dependencies: not tracked yet