Man pages for openxlsx
Read, Write and Edit xlsx Files
| activeSheet | Get/set active sheet of the workbook |
| addCreator | Add another author to the meta data of the file. |
| addFilter | Add column filters |
| addStyle | Add a style to a set of cells |
| addWorksheet | Add a worksheet to a workbook |
| all.equal | Check equality of workbooks |
| as.character.formula | 'as.character.formula()' |
| as_POSIXct_utc | Convert to POSIXct with timezone UTC |
| auto_heights | Compute optimal row heights |
| buildWorkbook | Build Workbook |
| cloneWorksheet | Clone a worksheet to a workbook |
| col2int | Convert Excel column to integer |
| conditionalFormat | Add conditional formatting to cells |
| conditionalFormatting | Add conditional formatting to cells |
| convertFromExcelRef | Convert excel column name to integer index |
| convertToDate | Convert from excel date number to R Date type |
| convertToDateTime | Convert from excel time number to R POSIXct type. |
| copyWorkbook | Copy a Workbook object. |
| createComment | create a Comment object |
| createStyle | Create a cell style |
| createWorkbook | Create a new Workbook object |
| dataValidation | Add data validation to cells |
| deleteData | Delete cell data |
| deleteDataColumn | Deletes a whole column from a workbook |
| freezePane | Freeze a worksheet pane |
| getBaseFont | Return the workbook default font |
| getCellRefs | Return excel cell coordinates from (x,y) coordinates |
| getCreators | Add another author to the meta data of the file. |
| getDateOrigin | Get the date origin an xlsx file is using |
| getNamedRegions | Get named regions |
| getSheetNames | Get names of worksheets |
| getStyles | Returns a list of all styles in the workbook |
| getTables | List Excel tables in a workbook |
| get_worksheet_entries | Get entries from workbook worksheet |
| groupColumns | Group columns |
| groupRows | Group Rows |
| if_null_then | If NULL then ... |
| insertImage | Insert an image into a worksheet |
| insertPlot | Insert the current plot into a worksheet |
| int2col | Convert integer to Excel column |
| loadWorkbook | Load an existing .xlsx file |
| makeHyperlinkString | create Excel hyperlink string |
| mergeCells | Merge cells within a worksheet |
| modifyBaseFont | Modify the default font |
| NamedRegion | Create / delete a named region. |
| names | get or set worksheet names |
| openXL | Open a Microsoft Excel file (xls/xlsx) or an openxlsx... |
| openxlsx | xlsx reading, writing and editing. |
| openxlsxFontSizeLookupTable | Font Size Lookup tables |
| openxlsx_options | openxlsx Options |
| pageBreak | add a page break to a worksheet |
| pageSetup | Set page margins, orientation and print scaling |
| protectWorkbook | Protect a workbook from modifications |
| protectWorksheet | Protect a worksheet from modifications |
| readWorkbook | Read from an Excel file or Workbook object |
| read.xlsx | Read from an Excel file or Workbook object |
| removeCellMerge | Create a new Workbook object |
| removeColWidths | Remove column widths from a worksheet |
| removeComment | Remove a comment from a cell |
| removeFilter | Remove a worksheet filter |
| removeRowHeights | Remove custom row heights from a worksheet |
| removeTable | Remove an Excel table in a workbook |
| removeWorksheet | Remove a worksheet from a workbook |
| renameWorksheet | Rename a worksheet |
| replaceStyle | Replace an existing cell style |
| saveWorkbook | save Workbook to file |
| setColWidths | Set worksheet column widths |
| setFooter | Set footer for all worksheets |
| setHeader | Set header for all worksheets |
| setHeaderFooter | Set document headers and footers |
| setLastModifiedBy | Add another author to the meta data of the file. |
| setRowHeights | Set worksheet row heights |
| setWindowSize | Set and Get Window Size for xlsx file |
| sheets | Returns names of worksheets. |
| sheetVisibility | Get/set worksheet visible state |
| sheetVisible | Get worksheet visible state. |
| showGridLines | Set worksheet gridlines to show or hide. |
| temp_xlsx | helper function to create tempory directory for testing... |
| ungroupColumns | Ungroup Columns |
| ungroupRows | Ungroup Rows |
| worksheetOrder | Order of worksheets in xlsx file |
| writeComment | write a cell comment |
| writeData | Write an object to a worksheet |
| writeDataTable | Write to a worksheet as an Excel table |
| writeFormula | Write a character vector as an Excel Formula |
| write.xlsx | write data to an xlsx file |
