CRAN
xltabr 0.1.2
Automatically Write Beautifully Formatted Cross Tabulations/Contingency Tables to Excel
Released Nov 28, 2017 by Robin Linacre
Dependencies
Writes beautifully formatted cross tabulations to Excel using 'openxlsx'. It has been developed to help automate the process of publishing Official Statistics. The user provides a dataframe, which is outputted to Excel with various types of rich formatting which are automatically detected from the structure of the cross tabulation. Documentation can be found at the following url
Installation
Maven
This package can be included as a dependency from a Java or Scala project by including
the following your project's pom.xml file.
Read more
about embedding Renjin in JVM-based projects.
<dependencies>
<dependency>
<groupId>org.renjin.cran</groupId>
<artifactId>xltabr</artifactId>
<version>0.1.2-b7</version>
</dependency>
</dependencies>
<repositories>
<repository>
<id>bedatadriven</id>
<name>bedatadriven public repo</name>
<url>https://nexus.bedatadriven.com/content/groups/public/</url>
</repository>
</repositories>
Renjin CLI
If you're using Renjin from the command line, you load this library by invoking:
library('org.renjin.cran:xltabr')
Test Results
This package was last tested against Renjin 0.9.2644 on Jun 2, 2018.
- Test_autodetection.Test_meta_columns_are_populated
- Test_body.column_widths_work_as_expected
- add_body-examples
- add_footer-examples
- add_title-examples
- add_top_headers-examples
- auto_crosstab_to_tab-examples
- auto_crosstab_to_wb-examples
- auto_detect_body_title_level-examples
- auto_detect_left_headers-examples
- auto_df_to_wb-examples
- auto_merge_footer_cells-examples
- auto_merge_title_cells-examples
- auto_style_indent-examples
- initialise-examples
- set_wb_widths-examples
- style_catalogue_add_excel_num_format-examples
- style_catalogue_add_openxlsx_style-examples
- testthat
- write_data_and_styles_to_wb-examples