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