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.5)xlsx_0.6.5.9000.zip(r-4.4)xlsx_0.6.5.9000.zip(r-4.3)
xlsx_0.6.5.9000.tgz(r-4.4-any)xlsx_0.6.5.9000.tgz(r-4.3-any)
xlsx_0.6.5.9000.tar.gz(r-4.5-noble)xlsx_0.6.5.9000.tar.gz(r-4.4-noble)
xlsx_0.6.5.9000.tgz(r-4.4-emscripten)xlsx_0.6.5.9000.tgz(r-4.3-emscripten)
xlsx.pdf |xlsx.html✨
xlsx/json (API)
NEWS

# 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

73 exports 85 stars 7.48 score 2 dependencies 35 dependents 95 mentions 12.7k scripts 55.7k downloads

Last updated 3 years agofrom:4ed1d0127f. Checks:OK: 7. Indexed: yes.

Target	Result	Date
Doc / Vignettes	OK	Sep 04 2024
R-4.5-win	OK	Sep 04 2024
R-4.5-linux	OK	Sep 04 2024
R-4.4-win	OK	Sep 04 2024
R-4.4-mac	OK	Sep 04 2024
R-4.3-win	OK	Sep 04 2024
R-4.3-mac	OK	Sep 04 2024

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

Cole Arendt

Rendered fromexcel_report.Rmdusingknitr::rmarkdownon Sep 04 2024.

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