### ExcelR Package Source: [A Wrapper of the JavaScript Library jExcel • excelR (swechhya.github.io)](https://swechhya.github.io/excelR/) An R interface to [jExcel](https://bossanova.uk/jexcel/v3/) library to create web-based interactive tables and spreadsheets compatible with Excel or any other spreadsheet software. To install the stable CRAN version: ``` install.packages('excelR') ``` ### pivottabler Package Source: [A Wrapper of the JavaScript Library jExcel • excelR (swechhya.github.io)](https://swechhya.github.io/excelR/) The `pivottabler` package enables pivot tables to be created with just a few lines of R. The `pivottabler` package aims to: - Provide an easy way of creating pivot tables, without requiring the user to specify low-level layout logic. - Provide multiple ways of specifying calculation logic to cover both simple and more sophisticated requirements. - Provide styling options so the pivot tables can be themed/branded as needed. All calculations for the pivot tables take place inside R, enabling the use of a wide-range of R functions in the calculation logic. Pivot tables are rendered as htmlwidgets, Latex or plain text. The HTML/Latex/text can be exported for use outside of R. Pivot tables can be converted to a standard R matrix or data frame. Pivot tables can be exported to Excel. Pivot tables can also be converted to a `basictabler` table for further manipulation. Using the `flextabler` package it is also possible to output tables to Word and PowerPoint. `pivottabler` is a companion package to the `basictabler` package. `pivottabler` is focussed on generating pivot tables and can aggregate data. `basictabler` does not aggregate data but offers more control of table structure. For more detailed information see [http://www.pivottabler.org.uk/articles](http://www.pivottabler.org.uk/articles). You can install the latest released version from CRAN with ``` install.packages("pivottabler") ``` *** 2023 cloudedknowledge.net