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.