Function reference • xlsx

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

Reference

All functions