pivottabler v1.5.0

0

Monthly downloads

0th

Percentile

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.

Functions in pivottabler

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

Vignettes of pivottabler

Name
data-group-hierarchy1.png
data-group-hierarchy2.png
excel1.png
excel2.png
excel3.png
excel4.png
excel5.png
excel6.png
intro-01.png
intro-02.png
intro-03.png
intro-04.png
intro-05.png
intro-06.png
intro-07.png
intro-08.png
intro-09.png
intro-10.png
intro-11.png
intro-12.png
intro-13.png
intro-14.png
intro-15.png
intro-16.png
intro-17.png
intro-18.png
intro-19.png
intro-20.png
intro-21.png
intro-22.png
intro-23.png
intro-24.png
intro-25.png
intro-26.png
intro-27.png
intro-28.png
intro-29.png
intro-30.png
intro-31.png
intro-32.png
latex1.png
latex2.png
latex3.png
latex4.png
layout1.png
layout2.png
layout3.png
layout4.png
layout5.png
readme1.png
shiny1.png
shiny2.png
shiny3.png
v00-vignettes.Rmd
No Results!

Last month downloads

Details

Type Package
License GPL-3
Encoding UTF-8
LazyData true
URL http://www.pivottabler.org.uk/, https://github.com/cbailiss/pivottabler
BugReports https://github.com/cbailiss/pivottabler/issues
VignetteBuilder knitr
RoxygenNote 7.1.0
NeedsCompilation no
Packaged 2020-06-16 10:08:18 UTC; Chris
Repository CRAN
Date/Publication 2020-06-16 16:20:03 UTC

Include our badge in your README

[![Rdoc](http://www.rdocumentation.org/badges/version/pivottabler)](http://www.rdocumentation.org/packages/pivottabler)