CRAN
openxlsx 4.1.0.1
Read, Write and Edit XLSX Files
Released May 28, 2019 by ORPHANED
This package can be loaded by Renjin but 48 out 53 tests failed.
Dependencies
Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of 'Rcpp', read/write times are comparable to the 'xlsx' and 'XLConnect' packages with the added benefit of removing the dependency on Java.
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>openxlsx</artifactId> <version>4.1.0.1-b1</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:openxlsx')
Test Results
This package was last tested against Renjin 0.9.2726 on Jul 13, 2019.
- addFilter-examples
- addStyle-examples
- addWorksheet-examples
- conditionalFormatting-examples
- convertFromExcelRef-examples
- convertToDate-examples
- convertToDateTime-examples
- copyWorkbook-examples
- createComment-examples
- createNamedRegion-examples
- createStyle-examples
- createWorkbook-examples
- dataValidation-examples
- deleteData-examples
- freezePane-examples
- getBaseFont-examples
- getDateOrigin-examples
- getNamedRegions-examples
- getSheetNames-examples
- getStyles-examples
- getTables-examples
- insertImage-examples
- int2col-examples
- loadWorkbook-examples
- makeHyperlinkString-examples
- mergeCells-examples
- modifyBaseFont-examples
- names-examples
- openXL-examples
- pageBreak-examples
- pageSetup-examples
- read.xlsx-examples
- readWorkbook-examples
- removeColWidths-examples
- removeFilter-examples
- removeRowHeights-examples
- removeTable-examples
- removeWorksheet-examples
- renameWorksheet-examples
- replaceStyle-examples
- saveWorkbook-examples
- setColWidths-examples
- setHeaderFooter-examples
- setRowHeights-examples
- sheetVisibility-examples
- sheetVisible-examples
- sheets-examples
- showGridLines-examples
- testthat
- worksheetOrder-examples
- write.xlsx-examples
- writeComment-examples
- writeFormula-examples