openxlsx

Add another author to the meta data of the file.

Add column filters

Add a style to a set of cells

Add a worksheet to a workbook

Check equality of workbooks

Clone a worksheet to a workbook

Add conditional formatting to cells

Add conditional formatting to cells

Convert excel column name to integer index

Convert from excel date number to R Date type

Convert from excel time number to R POSIXct type.

Copy a Workbook object.

create a Comment object

Create a named region.

Create a cell style

Create a new Workbook object

Add data validation to cells

Delete cell data

Freeze a worksheet pane

Return the workbook default font

Return excel cell coordinates from (x,y) coordinates

Add another author to the meta data of the file.

Get the date origin an xlsx file is using

Get named regions

Get names of worksheets

Returns a list of all styles in the workbook

List Excel tables in a workbook

Group columns

Group Rows

Insert an image into a worksheet

Insert the current plot into a worksheet

Convert integer to Excel column

Load an existing .xlsx file

create Excel hyperlink string

Merge cells within a worksheet

Modify the default font

get or set worksheet names

Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook

xlsx reading, writing and editing.

add a page break to a worksheet

Set page margins, orientation and print scaling

Protect a workbook from modifications

Protect a worksheet from modifications

Read from an Excel file or Workbook object

Read from an Excel file or Workbook object

Create a new Workbook object

Remove column widths from a worksheet

Remove a comment from a cell

Remove a worksheet filter

Remove custom row heights from a worksheet

Remove an Excel table in a workbook

Remove a worksheet from a workbook

Rename a worksheet

Replace an existing cell style

save Workbook to file

Set worksheet column widths

Set footer for all worksheets

Set header for all worksheets

Set document headers and footers

Add another author to the meta data of the file.

Set worksheet row heights

Get/set worksheet visible state

Get worksheet visible state.

Returns names of worksheets.

Set worksheet gridlines to show or hide.

Ungroup Columns

Ungroup Rows

Order of worksheets in xlsx file

write data to an xlsx file

write a cell comment

Write an object to a worksheet

Write to a worksheet as an Excel table

Write a character vector as an Excel Formula