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