Package index • openxlsx

All functions

createNamedRegion() deleteNamedRegion(): Create / delete a named region.
activeSheet() `activeSheet<-`(): Get/set active sheet of the workbook
addCreator(): Add another author to the meta data of the file.
addFilter(): Add column filters
addStyle(): Add a style to a set of cells
addWorksheet(): Add a worksheet to a workbook
all.equal(<Workbook>): Check equality of workbooks
as.character(<formula>): as.character.formula()
auto_heights(): Compute optimal row heights
buildWorkbook(): Build Workbook
cloneWorksheet(): Clone a worksheet to a workbook
col2int(): Convert Excel column to integer
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
createStyle(): Create a cell style
createWorkbook(): Create a new Workbook object
dataValidation(): Add data validation to cells
deleteData(): Delete cell data
deleteDataColumn(): Deletes a whole column from a workbook
freezePane(): Freeze a worksheet pane
getBaseFont(): Return the workbook default font
getCellRefs(): Return excel cell coordinates from (x,y) coordinates
getCreators(): Get the names of the authors from the meta data of the file.
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
get_worksheet_entries(): Get entries from workbook worksheet
groupColumns(): Group columns
groupRows(): Group Rows
`%||%`: If NULL then ...
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(<Workbook>) `names<-`(<Workbook>): get or set worksheet names
openXL(): Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook
openxlsx-package openxlsx: xlsx reading, writing and editing.
openxlsxFontSizeLookupTable openxlsxFontSizeLookupTableBold: Font Size Lookup tables
op.openxlsx openxlsx_getOp() openxlsx_setOp(): openxlsx Options
pageBreak(): add a page break to a worksheet
pageSetup(): Set page margins, orientation and print scaling
protectWorkbook(): Protect a workbook from modifications
protectWorksheet(): Protect a worksheet from modifications
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
setLastModifiedBy(): Set the author who modified the file last.
setRowHeights(): Set worksheet row heights
setWindowSize() getWindowSize(): Set and Get Window Size for xlsx file
sheetVisibility() `sheetVisibility<-`(): Get/set worksheet visible state
sheetVisible() `sheetVisible<-`(): Get worksheet visible state.
sheets(): Returns names of worksheets.
showGridLines(): Set worksheet gridlines to show or hide.
temp_xlsx(): helper function to create tempory directory for testing purpose
ungroupColumns(): Ungroup Columns
ungroupRows(): Ungroup Rows
worksheetOrder() `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