Add column filters
Add a worksheet to a workbook
Add another author to the meta data of the file.
Build Workbook
Check equality of workbooks
Get/set active sheet of the workbook
Clone a worksheet to a workbook
Add a style to a set of cells
Add conditional formatting to cells
Add conditional formatting to cells
Add data validation to cells
Convert from excel time number to R POSIXct type.
Return excel cell coordinates from (x,y) coordinates
Add another author to the meta data of the file.
Copy a Workbook object.
Merge cells within a worksheet
create Excel hyperlink string
create a Comment object
Create a named region.
Get named regions
Get the date origin an xlsx file is using
Delete cell data
Convert integer to Excel column
xlsx reading, writing and editing.
Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook
Convert excel column name to integer index
Convert from excel date number to R Date type
Set page margins, orientation and print scaling
Rename a worksheet
add a page break to a worksheet
Remove a worksheet from a workbook
Create a new Workbook object
Returns a list of all styles in the workbook
Create a cell style
Insert an image into a worksheet
Get names of worksheets
Load an existing .xlsx file
Freeze a worksheet pane
Return the workbook default font
get or set worksheet names
Modify the default font
Set header for all worksheets
Read from an Excel file or Workbook object
Replace an existing cell style
Insert the current plot into a worksheet
Read from an Excel file or Workbook object
Set worksheet column widths
Order of worksheets in xlsx file
Set footer for all worksheets
Create a new Workbook object
save Workbook to file
write data to an xlsx file
Write an object to a worksheet
write a cell comment
List Excel tables in a workbook
Group Rows
Group columns
If NULL then ...
Add another author to the meta data of the file.
Set worksheet row heights
Remove column widths from a worksheet
Remove a worksheet filter
Get worksheet visible state.
openxlsx Options
Get/set worksheet visible state
Remove a comment from a cell
Set document headers and footers
openxlsxFontSizeLookupTable
Font Size Lookup tables
Write a character vector as an Excel Formula
Write to a worksheet as an Excel table
Protect a workbook from modifications
Remove custom row heights from a worksheet
Ungroup Columns
Returns names of worksheets.
Set worksheet gridlines to show or hide.
Protect a worksheet from modifications
Remove an Excel table in a workbook
Ungroup Rows