Showing 13 of total 13 results (show query)
ycphs
openxlsx:Read, Write and Edit xlsx Files
Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of 'Rcpp', read/write times are comparable to the 'xlsx' and 'XLConnect' packages with the added benefit of removing the dependency on Java.
Maintained by Jan Marvin Garbuszus. Last updated 2 months ago.
61.2 match 232 stars 18.98 score 20k scripts 270 dependents
janmarvin
openxlsx2:Read, Write and Edit 'xlsx' Files
Simplifies the creation of 'xlsx' files by providing a high level interface to writing, styling and editing worksheets.
Maintained by Jan Marvin Garbuszus. Last updated 2 days ago.
7.3 match 138 stars 13.67 score 194 scripts 11 dependents
best-practice-and-impact
aftables:Create Spreadsheet Publications Following Best Practice
Generate spreadsheet publications that follow best practice guidance from the UK government's Analysis Function, available at <https://analysisfunction.civilservice.gov.uk/policy-store/releasing-statistics-in-spreadsheets/>, with a focus on accessibility. See also the 'Python' package 'gptables'.
Maintained by Olivia Box Power. Last updated 25 days ago.
accessibilityopenxlsxreproducible-analytical-pipelinespreadsheetuk-gov-data-science
11.0 match 44 stars 6.72 score 4 scripts
cbailiss
pivottabler:Create Pivot Tables
Create regular pivot tables with just a few lines of R. More complex pivot tables can also be created, e.g. pivot tables with irregular layouts, multiple calculations and/or derived calculations based on multiple data frames. Pivot tables are constructed using R only and can be written to a range of output formats (plain text, 'HTML', 'Latex' and 'Excel'), including with styling/formatting.
Maintained by Christopher Bailiss. Last updated 1 years ago.
calculationshtmlhtmlwidgetlatexpivot-tablesvisualization
6.8 match 122 stars 8.08 score 358 scripts 1 dependentscbailiss
basictabler:Construct Rich Tables for Output to 'HTML'/'Excel'
Easily create tables from data frames/matrices. Create/manipulate tables row-by-row, column-by-column or cell-by-cell. Use common formatting/styling to output rich tables as 'HTML', 'HTML widgets' or to 'Excel'.
Maintained by Christopher Bailiss. Last updated 4 years ago.
htmlhtmlwidgettablesvisualization
6.8 match 37 stars 7.09 score 94 scripts
danchaltiel
crosstable:Crosstables for Descriptive Analyses
Create descriptive tables for continuous and categorical variables. Apply summary statistics and counting function, with or without a grouping variable, and create beautiful reports using 'rmarkdown' or 'officer'. You can also compute effect sizes and statistical tests if needed.
Maintained by Dan Chaltiel. Last updated 2 months ago.
descriptive-statisticsflextablefrequency-tablehtml-reportmswordofficer
1.7 match 116 stars 10.37 score 340 scripts
framverse
xldiff:Compare excel sheets
`xldiff` provides tools to compare excel sheets, broadly inspired by "diff"-type functions. Provided functions can read sheets of two excel files and produce a third file that highlights cells that have changed. In the case of numeric changes, the direction of change is highlighted. These tools do not account for structural changes in the sheets (e.g., the addition of a column), but are useful in tracking changed values in tables or parameter files. Utility functions developed to streamline formatting output files are also more broadly useful in programmatically formatting excel files using openxlsx.
Maintained by Collin Edwards. Last updated 2 days ago.
4.1 match 3.02 score 1 dependents
maple-health-group
easysurv:Simplify Survival Data Analysis and Model Fitting
Inspect survival data, plot Kaplan-Meier curves, assess the proportional hazards assumption, fit parametric survival models, predict and plot survival and hazards, and export the outputs to 'Excel'. A simple interface for fitting survival models using flexsurv::flexsurvreg(), flexsurv::flexsurvspline(), flexsurvcure::flexsurvcure(), and survival::survreg().
Maintained by Niall Davison. Last updated 9 months ago.
1.8 match 4 stars 4.60 score 7 scripts
harrison4192
presenter:Present Data with Style
Consists of custom wrapper functions using packages 'openxlsx', 'flextable', and 'officer' to create highly formatted MS office friendly output of your data frames. These viewer friendly outputs are intended to match expectations of professional looking presentations in business and consulting scenarios. The functions are opinionated in the sense that they expect the input data frame to have certain properties in order to take advantage of the automated formatting.
Maintained by Harrison Tietze. Last updated 2 years ago.
0.5 match 11 stars 6.69 score 15 scripts 4 dependents
statistikat
tatoo:Combine and Export Data Frames
Functions to combine data.frames in ways that require additional effort in base R, and to add metadata (id, title, ...) that can be used for printing and xlsx export. The 'Tatoo_report' class is provided as a convenient helper to write several such tables to a workbook, one table per worksheet. Tatoo is built on top of 'openxlsx', but intimate knowledge of that package is not required to use tatoo.
Maintained by Stefan Fleck. Last updated 2 years ago.
0.5 match 7 stars 5.53 score 24 scripts
jhorzek
tablespan:Create Satisficing 'Excel', 'HTML', 'LaTeX', and 'RTF' Tables using a Simple Formula
Create "good enough" tables with a single formula. 'tablespan' tables can be exported to 'Excel', 'HTML', 'LaTeX', and 'RTF' by leveraging the packages 'openxlsx' and 'gt'. See <https://jhorzek.github.io/tablespan/> for an introduction.
Maintained by Jannik H. Orzek. Last updated 1 months ago.
0.5 match 14 stars 5.36 score 30 scripts
nhilder
xlr:Create Table Summaries and Export Neat Tables to 'Excel'
A high-level interface for creating and exporting summary tables to 'Excel'. Built on 'dplyr' and 'openxlsx', it provides tools for generating one-way to n-way tables, and summarizing multiple response questions and question blocks. Tables are exported with native 'Excel' formatting, including titles, footnotes, and basic styling options.
Maintained by Nicholas Hilderson. Last updated 7 days ago.
0.5 match 4.18 score
epicentre-msf
qxl:Quick Customized Excel Files
A wrapper to the openxlsx package optimized for writing flat data structures.
Maintained by Patrick Barks. Last updated 12 months ago.
0.6 match 5 stars 2.88 score 7 scripts