Package: xlsx 0.6.5.9000

xlsx: Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files

Provide R functions to read/write/format Excel 2007 and Excel 97/2000/XP/2003 file formats.

Authors:Adrian Dragulescu [aut], Cole Arendt [aut, cre]

xlsx_0.6.5.9000.tar.gz
xlsx_0.6.5.9000.zip(r-4.7)xlsx_0.6.5.9000.zip(r-4.6)xlsx_0.6.5.9000.zip(r-4.5)
xlsx_0.6.5.9000.tgz(r-4.6-any)xlsx_0.6.5.9000.tgz(r-4.5-any)
xlsx_0.6.5.9000.tar.gz(r-4.7-any)xlsx_0.6.5.9000.tar.gz(r-4.6-any)
xlsx_0.6.5.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
xlsx/json (API)

# Install 'xlsx' in R:

install.packages('xlsx', repos = c('https://colearendt.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/colearendt/xlsx/issues

Uses libs:

openjdk– OpenJDK Java runtime, using Hotspot JIT

On CRAN:

excel java rjava xlsx openjdk

14.06 score 83 stars 32 packages 12k scripts 33k downloads 95 mentions 73 exports 2 dependencies

Last updated from:4ed1d0127f. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	148
source / vignettes	OK	201
linux-release-x86_64	OK	150
macos-release-arm64	OK	89
macos-oldrel-arm64	OK	218
windows-devel	OK	118
windows-release	OK	111
windows-oldrel	OK	101
wasm-release	OK	105

Exports:addAutoFilter addDataFrame addHyperlink addMergedRegion addPicture Alignment autoSizeColumn Border BORDER_STYLES_CB.setBorder CB.setColData CB.setFill CB.setFont CB.setMatrixData CB.setRowData CELL_STYLES_CellBlock CellProtection CellStyle createCell createCellComment createFreezePane createRange createRow createSheet createSplitPane createWorkbook DataFormat Fill FILL_STYLES_Font forceFormulaRefresh forcePivotTableRefresh get_java_tmp_dir getCellComment getCells getCellStyle getCellValue getRanges getRows getSheets HALIGN_STYLES_INDEXED_COLORS_is.Alignment is.Border is.CellBlock is.CellProtection is.CellStyle is.DataFormat is.Fill is.Font loadWorkbook printSetup read.xlsx read.xlsx2 readColumns readRange readRows removeCellComment removeMergedRegion removeRow removeSheet saveWorkbook set_java_tmp_dir setCellStyle setCellValue setColumnWidth setPrintArea setRowHeight setZoom VALIGN_STYLES_write.xlsx write.xlsx2

Dependencies:rJava xlsxjars

Build Excel Reports from R

Building Excel Reports in R | From Scratch | Functional Cell Styles

Rendered fromexcel_report.Rmdusingknitr::rmarkdown

Last update: 2020-09-12
Started: 2020-02-06

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files	xlsx-package xlsx
Add a 'data.frame' to a sheet.	addDataFrame
Add a hyperlink to a cell.	addHyperlink
Functions to manipulate cells.	Cell createCell getCells getCellValue setCellValue
Create and style a block of cells.	CB.setBorder CB.setColData CB.setFill CB.setFont CB.setMatrixData CB.setRowData CellBlock CellBlock.default is.CellBlock
Functions to manipulate cells.	CellStyle CellStyle.default getCellStyle is.CellStyle setCellStyle
CellStyle construction.	+.CellStyle CellStyle-plus
Functions to manipulate cell comments.	Comment createCellComment getCellComment removeCellComment
Force Refresh Pivot Tables and Formulae	forceFormulaRefresh forcePivotTableRefresh
Create an Alignment object.	Alignment is.Alignment
Create an Border object.	Border is.Border
Create a CellProtection object.	CellProtection is.CellProtection
Create an DataFormat object.	DataFormat is.DataFormat
Create an Fill object.	Fill is.Fill
Create a Font object.	Font is.Font
Functions to manipulate (contiguous) named ranges.	createRange getRanges NamedRanges readRange
Functions to do various spreadsheets effects.	addAutoFilter addMergedRegion autoSizeColumn createFreezePane createSplitPane OtherEffects removeMergedRegion setColumnWidth setPrintArea setZoom
Functions to manipulate images in a spreadsheet.	addPicture Picture
Constants used in the project.	BORDER_STYLES_ CELL_STYLES_ FILL_STYLES_ HALIGN_STYLES_ INDEXED_COLORS_ POI_constants VALIGN_STYLES_
Function to manipulate print setup.	PrintSetup printSetup
Read the contents of a worksheet into an R 'data.frame'.	read.xlsx read.xlsx2
Read a contiguous set of columns from sheet into an R data.frame	readColumns
Read a contiguous set of rows into an R matrix	readRows
Functions to manipulate rows of a worksheet.	createRow getRows removeRow Row setRowHeight
Set Java Temp Directory	get_java_tmp_dir set_java_tmp_dir
Functions to manipulate worksheets.	createSheet getSheets removeSheet Sheet Worksheet
Functions to manipulate Excel 2007 workbooks.	createWorkbook loadWorkbook saveWorkbook Workbook
Write a data.frame to an Excel workbook.	write.xlsx write.xlsx2