Create Pivot Tables

---

Documentation for package ‘pivottabler’ version 1.5.5

• DESCRIPTION file.
• User guides, package vignettes and other documentation.
• Package NEWS.

Help Pages

bhmtraindisruption	Birmingham Train Disruptions, Dec 2016-Feb 2017.
bhmtrains	Birmingham Trains, Dec 2016-Feb 2017.
checkArgument	Perform basic checks on a function argument.
cleanCssValue	Cleans up a CSS attribute value.
cleanOutlineArg	Clean the arguments specified for an outline group
containsText	Check whether a text value is present in another text value.
convertPvtStyleToBasicStyle	Convert a pivot table style to a basictabler style.
convertPvtTblToBasicTbl	Convert a pivot table to a basic table.
exportValueAs	Replace the current value with a placeholder during export.
getBlankTheme	Get an empty theme for applying no styling to a table.
getCompactTheme	Get the compact theme for styling a pivot table.
getDefaultTheme	Get the default theme for styling a pivot table.
getLargePlainTheme	Get the large plain theme for styling a pivot table.
getNextPosition	Find the first value in an array that is larger than the specified value.
getPvtStyleDeclarations	Get pivot table style declarations from a pivot table style.
getSimpleColoredTheme	Get a simple coloured theme.
getStandardTableTheme	Get the a theme for styling to a pivot table that looks more like a standard table (i.e. no row column headings).
getTheme	Get a built-in theme for styling a pivot table.
getXlBorderFromCssBorder	Convert CSS border values to those used by the openxlsx package.
getXlBorderStyleFromCssBorder	Convert CSS border values to those used by the openxlsx package.
isNumericValue	Check whether a numeric value is present.
isTextValue	Check whether a text value is present.
oneToNULL	Convert a value of 1 to a NULL value.
parseColor	Convert a CSS colour into a hex based colour code.
parseCssBorder	Parse a CSS border value.
parseCssSizeToPt	Convert a CSS size value into points.
parseCssSizeToPx	Convert a CSS size value into pixels
parseCssString	Split a CSS attribute value into a vector/array.
parseXlBorder	Parse an xl-border value.
PivotBatch	R6 class the represents a Calculation Batch
PivotBatchCalculator	R6 class that calculates the values for multiple cells in batches.
PivotBatchStatistics	R6 class that provides summary statistics for batch calculations.
PivotCalculation	R6 class that defines a calculation.
PivotCalculationGroup	R6 class that defines a group of calculations.
PivotCalculationGroups	R6 class that contains multiple calculation groups.
PivotCalculator	R6 class that computes the value of a cell or cells.
PivotCell	R6 class that represents a cell in a pivot table.
PivotCells	R6 class that contains the cells in a pivot table.
PivotData	R6 class that contains named data frames and associated totals.
PivotDataGroup	R6 class that defines a row or column data group.
PivotFilter	R6 class that defines a filter condition.
PivotFilterOverrides	R6 class that defines a set of filter overrides.
PivotFilters	R6 class that defines a set of filter conditions.
PivotHtmlRenderer	R6 class that renders a pivot table in HTML.
PivotLatexRenderer	R6 class that renders a pivot table in Latex.
PivotOpenXlsxRenderer	R6 class that renders a pivot table into an Excel worksheet.
PivotOpenXlsxStyle	R6 class that specifies Excel styling as used by the openxlsx package.
PivotOpenXlsxStyles	R6 class that defines a collection of Excel styles as used by the openxlsx package.
PivotStyle	R6 class that specifies styling.
PivotStyles	R6 class that defines a collection of styles.
PivotTable	R6 class that represents a pivot table.
pivottabler	Render a pivot table as a HTML widget.
pivottablerOutput	Standard function for Shiny scaffolding.
processIdentifier	Handle an identifier that may be illegal (e.g. containing spaces).
processIdentifiers	Handle identifiers that may be illegal (e.g. containing spaces).
pvtperfresults	Performance Comparison Results
pvtperfsummary	Performance Comparison Summary
qhpvt	Quickly render a basic pivot table in HTML.
qlpvt	Quickly get a Latex representation of a basic pivot table.
qpvt	Quickly build a basic pivot table.
renderBasicTable	Output a table into a package vignette.
renderPivottabler	Standard function for Shiny scaffolding.
skipExportingValue	Should the current value be skipped during export?
trainstations	Train Stations
typeSafeIntersect	Intersect two vectors without changing their data types.
typeSafeUnion	Union two vectors without changing their data types.
typeSafeUnlist	Unlist a list into a vector in a type-safe way where possible.
vreConvertSimpleNumericRange	Convert a simple range expression to a standard R logical expression.
vreGetSingleValue	Read the value from a single-valued value range expression.
vreHexToClr	Convert a colour in hex format (#RRGGBB) into a list.
vreIsEqual	Test if two numeric values are equal within tolerance.
vreIsMatch	Test whether a value matches a value range expression.
vreIsSimpleNumericRange	Determine if a value range expression is a simple range expression.
vreIsSingleValue	Determine if a value range expression is a single value.
vreScale2Colours	Scale a number from a range into a colour gradient.
vreScaleNumber	Rescale a number from one range into another range.