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