Read, Write and Edit xlsx Files
Get/set active sheet of the workbook
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
Convert to POSIXct with timezone UTC
as.character.formula()
Compute optimal row heights
Build Workbook
Clone a worksheet to a workbook
Convert Excel column to integer
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 cell style
Create a new Workbook object
Add data validation to cells
Delete cell data
Deletes a whole column from a workbook
Freeze a worksheet pane
Get entries from workbook worksheet
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
If NULL then ...
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
Create / delete a named region.
get or set worksheet names
Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook
openxlsx Options
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
Set and Get Window Size for xlsx file
Returns names of worksheets.
Get/set worksheet visible state
Get worksheet visible state.
Set worksheet gridlines to show or hide.
helper function to create tempory directory for testing purpose
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
Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of 'Rcpp', read/write times are comparable to the 'xlsx' and 'XLConnect' packages with the added benefit of removing the dependency on Java.
Useful links