Create Pivot Tables
Perform basic checks on a function argument.
Cleans up a CSS attribute value.
Clean the arguments specified for an outline group
Check whether a text value is present in another text value.
Convert a pivot table style to a basictabler style.
Convert a pivot table to a basic table.
Replace the current value with a placeholder during export.
Get an empty theme for applying no styling to a table.
Get the compact theme for styling a pivot table.
Get the default theme for styling a pivot table.
Get the large plain theme for styling a pivot table.
Find the first value in an array that is larger than the specified val...
Get pivot table style declarations from a pivot table style.
Get a simple coloured theme.
Get the a theme for styling to a pivot table that looks more like a st...
Get a built-in theme for styling a pivot table.
Convert CSS border values to those used by the openxlsx package.
Convert CSS border values to those used by the openxlsx package.
Check whether a numeric value is present.
Check whether a text value is present.
Convert a value of 1 to a NULL value.
Convert a CSS colour into a hex based colour code.
Parse a CSS border value.
Convert a CSS size value into points.
Convert a CSS size value into pixels
Split a CSS attribute value into a vector/array.
Parse an xl-border value.
R6 class the represents a Calculation Batch
R6 class that calculates the values for multiple cells in batches.
R6 class that provides summary statistics for batch calculations.
R6 class that defines a calculation.
R6 class that defines a group of calculations.
R6 class that contains multiple calculation groups.
R6 class that computes the value of a cell or cells.
R6 class that represents a cell in a pivot table.
R6 class that contains the cells in a pivot table.
R6 class that contains named data frames and associated totals.
R6 class that defines a row or column data group.
R6 class that defines a filter condition.
R6 class that defines a set of filter overrides.
R6 class that defines a set of filter conditions.
R6 class that renders a pivot table in HTML.
R6 class that renders a pivot table in Latex.
R6 class that renders a pivot table into an Excel worksheet.
R6 class that specifies Excel styling as used by the openxlsx package.
R6 class that defines a collection of Excel styles as used by the open...
R6 class that specifies styling.
R6 class that defines a collection of styles.
R6 class that represents a pivot table.
Render a pivot table as a HTML widget.
Standard function for Shiny scaffolding.
Handle an identifier that may be illegal (e.g. containing spaces).
Handle identifiers that may be illegal (e.g. containing spaces).
Quickly render a basic pivot table in HTML.
Quickly get a Latex representation of a basic pivot table.
Quickly build a basic pivot table.
Output a table into a package vignette.
Standard function for Shiny scaffolding.
Should the current value be skipped during export?
Intersect two vectors without changing their data types.
Union two vectors without changing their data types.
Unlist a list into a vector in a type-safe way where possible.
Convert a simple range expression to a standard R logical expression.
Read the value from a single-valued value range expression.
Convert a colour in hex format (#RRGGBB) into a list.
Test if two numeric values are equal within tolerance.
Test whether a value matches a value range expression.
Determine if a value range expression is a simple range expression.
Determine if a value range expression is a single value.
Scale a number from a range into a colour gradient.
Rescale a number from one range into another range.
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.
Useful links