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