Read, Write and Edit XLSX Files

Documentation for package ‘openxlsx’ version 4.1.0

Help Pages

openxlsx-package	xlsx reading, writing and editing.
addFilter	Add column filters
addStyle	Add a style to a set of cells
addWorksheet	Add a worksheet to a workbook
all.equal	Check equality of workbooks
all.equal.Workbook	Check equality of workbooks
conditionalFormat	Add conditional formatting to cells
conditionalFormatting	Add conditional formatting to cells
convertFromExcelRef	Convert excel column name to integer index
convertToDate	Convert from excel date number to R Date type
convertToDateTime	Convert from excel time number to R POSIXct type.
copyWorkbook	Copy a Workbook object.
createComment	create a Comment object
createNamedRegion	Create a named region.
createStyle	Create a cell style
createWorkbook	Create a new Workbook object
databar	Add conditional formatting to cells
dataValidation	Add data validation to cells
deleteData	Delete cell data
freezePane	Freeze a worksheet pane
getBaseFont	Return the workbook default font
getCellRefs	Return excel cell coordinates from (x,y) coordinates
getDateOrigin	Get the date origin an xlsx file is using
getNamedRegions	Get named regions
getSheetNames	Get names of worksheets
getStyles	Returns a list of all styles in the workbook
getTables	List Excel tables in a workbook
insertImage	Insert an image into a worksheet
insertPlot	Insert the current plot into a worksheet
int2col	Convert integer to Excel column
loadWorkbook	Load an existing .xlsx file
makeHyperlinkString	create Excel hyperlink string
mergeCells	Merge cells within a worksheet
modifyBaseFont	Modify the default font
names	get or set worksheet names
names.Workbook	get or set worksheet names
names<-.Workbook	get or set worksheet names
openXL	Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook
openxlsx	xlsx reading, writing and editing.
pageBreak	add a page break to a worksheet
pageSetup	Set page margins, orientation and print scaling
read.xlsx	Read from an Excel file or Workbook object
readWorkbook	Read from an Excel file or Workbook object
removeCellMerge	Create a new Workbook object
removeColWidths	Remove column widths from a worksheet
removeComment	Remove a comment from a cell
removeFilter	Remove a worksheet filter
removeRowHeights	Remove custom row heights from a worksheet
removeTable	Remove an Excel table in a workbook
removeWorksheet	Remove a worksheet from a workbook
renameWorksheet	Rename a worksheet
replaceStyle	Replace an existing cell style
saveWorkbook	save Workbook to file
setColWidths	Set worksheet column widths
setFooter	Set footer for all worksheets
setHeader	Set header for all worksheets
setHeaderFooter	Set document headers and footers
setRowHeights	Set worksheet row heights
sheets	Returns names of worksheets.
sheetVisibility	Get/set worksheet visible state
sheetVisibility<-	Get/set worksheet visible state
sheetVisible	Get worksheet visible state.
sheetVisible<-	Get worksheet visible state.
showGridLines	Set worksheet gridlines to show or hide.
worksheetOrder	Order of worksheets in xlsx file
worksheetOrder<-	Order of worksheets in xlsx file
write.xlsx	write data to an xlsx file
writeComment	write a cell comment
writeData	Write an object to a worksheet
writeDataTable	Write to a worksheet as an Excel table
writeFormula	Write a character vector as an Excel Formula