API for openxlsx
Read, Write and Edit xlsx Files
| Global functions | |
|---|---|
| %||% | Man page |
| .onAttach | Source code |
| .onUnload | Source code |
| `%||%` | Source code |
| `activeSheet<-` | Source code |
| `names<-.Workbook` | Source code |
| `sheetVisibility<-` | Source code |
| `sheetVisible<-` | Source code |
| `worksheetOrder<-` | Source code |
| activeSheet | Man page Source code |
| activeSheet<- | Man page |
| addCreator | Man page Source code |
| addFilter | Man page Source code |
| addStyle | Man page Source code |
| addWorksheet | Man page Source code |
| all.equal | Man page |
| all.equal.Workbook | Man page Source code |
| assert_character1 | Source code |
| assert_class | Source code |
| assert_length | Source code |
| assert_numeric1 | Source code |
| assert_true_false | Source code |
| assert_true_false1 | Source code |
| assert_unique | Source code |
| buildBorder | Source code |
| buildCellList | Source code |
| buildCellTypes | Source code |
| buildFillList | Source code |
| buildFontList | Source code |
| buildMatrixMixed | Source code |
| buildMatrixNumeric | Source code |
| buildWorkbook | Man page Source code |
| build_cell_merges | Source code |
| build_cell_types_integer | Source code |
| build_table_xml | Source code |
| calc_column_widths | Source code |
| calc_number_rows | Source code |
| cell_ref_to_col | Source code |
| check_openxlsx_op | Source code |
| chooseExcelApp | Source code |
| classStyles | Source code |
| clean_names | Source code |
| cloneWorksheet | Man page Source code |
| col2hex | Source code |
| col2int | Man page Source code |
| conditionalFormat | Man page Source code |
| conditionalFormatting | Man page Source code |
| contentTypePivotXML | Source code |
| contentTypeSlicerCacheXML | Source code |
| convert2EMU | Source code |
| convertFromExcelRef | Man page Source code |
| convertToDate | Man page Source code |
| convertToDateTime | Man page Source code |
| convert_from_excel_ref | Source code |
| convert_to_excel_ref | Source code |
| convert_to_excel_ref_expand | Source code |
| copyWorkbook | Man page Source code |
| cppReadFile | Source code |
| createComment | Man page Source code |
| createNamedRegion | Man page Source code |
| createStyle | Man page Source code |
| createWorkbook | Man page Source code |
| dataValidation | Man page Source code |
| databar | Man page |
| deleteData | Man page Source code |
| deleteNamedRegion | Man page Source code |
| do_call_params | Source code |
| do_setColWidths | Source code |
| freezePane | Man page Source code |
| genBaseColStyle | Source code |
| genBaseContent_Type | Source code |
| genBaseCore | Source code |
| genBasePic | Source code |
| genBaseShapeVML | Source code |
| genBaseSheetRels | Source code |
| genBaseSlicerXML | Source code |
| genBaseStyleSheet | Source code |
| genBaseTheme | Source code |
| genBaseWorkbook | Source code |
| genBaseWorkbook.xml.rels | Source code |
| genClientData | Source code |
| genHeaderFooterNode | Source code |
| genPrinterSettings | Source code |
| genSlicerCachesExtLst | Source code |
| gen_databar_extlst | Source code |
| getAttr | Source code |
| getAttrs | Source code |
| getAttrsFont | Source code |
| getBaseFont | Man page Source code |
| getCellInfo | Source code |
| getCellRefs | Man page Source code |
| getChildlessNode | Source code |
| getChildlessNode_ss | Source code |
| getCreators | Man page Source code |
| getDateOrigin | Man page Source code |
| getDefinedNamedSheet_ | Source code |
| getDefinedNamesSheet | Source code |
| getFile | Source code |
| getId | Source code |
| getNamedRegions | Man page Source code |
| getNamedRegions.Workbook | Source code |
| getNamedRegions.default | Source code |
| getNodes | Source code |
| getOpenClosedNode | Source code |
| getRId | Source code |
| getSharedStringsFromFile | Source code |
| getSheetNames | Man page Source code |
| getStyles | Man page Source code |
| getTables | Man page Source code |
| get_extLst_Major | Source code |
| get_letters | Source code |
| get_named_regions_from_string | Source code |
| get_set_options | Source code |
| get_shared_strings | Source code |
| get_style_max_char_width | Source code |
| groupColumns | Man page Source code |
| groupRows | Man page Source code |
| hashPassword | Source code |
| headerFooterSub | Source code |
| if_null_then | Man page |
| insertImage | Man page Source code |
| insertPlot | Man page Source code |
| int2col | Man page Source code |
| int_2_cell_ref | Source code |
| isInternalHyperlink | Source code |
| is_not_class | Source code |
| is_true_false | Source code |
| loadWorkbook | Man page Source code |
| loadworksheets | Source code |
| makeHyperlinkString | Man page Source code |
| map_cell_types_to_char | Source code |
| map_cell_types_to_integer | Source code |
| markUTF8 | Source code |
| matrixRowInds | Source code |
| mergeCell2mapping | Source code |
| mergeCells | Man page Source code |
| mergeStyle | Source code |
| modifyBaseFont | Man page Source code |
| names | Man page |
| names.Workbook | Man page Source code |
| names<-.Workbook | Man page |
| nodeAttributes | Source code |
| op.openxlsx | Man page |
| openXL | Man page Source code |
| openxlsx | Man page |
| openxlsxCoerce | Source code |
| openxlsxCoerce.anova | Source code |
| openxlsxCoerce.aov | Source code |
| openxlsxCoerce.array | Source code |
| openxlsxCoerce.cox.zph | Source code |
| openxlsxCoerce.coxph | Source code |
| openxlsxCoerce.data.frame | Source code |
| openxlsxCoerce.data.table | Source code |
| openxlsxCoerce.default | Source code |
| openxlsxCoerce.glm | Source code |
| openxlsxCoerce.hyperlink | Source code |
| openxlsxCoerce.lm | Source code |
| openxlsxCoerce.matrix | Source code |
| openxlsxCoerce.prcomp | Source code |
| openxlsxCoerce.summary.coxph | Source code |
| openxlsxCoerce.summary.prcomp | Source code |
| openxlsxCoerce.survdiff | Source code |
| openxlsxCoerce.table | Source code |
| openxlsxFontSizeLookupTable | Man page |
| openxlsxFontSizeLookupTableBold | Man page |
| openxlsx_getOp | Man page Source code |
| openxlsx_options | Man page |
| openxlsx_resetOp | Source code |
| openxlsx_setOp | Man page Source code |
| pageBreak | Man page Source code |
| pageSetup | Man page Source code |
| pixels2ExcelColWidth | Source code |
| protectWorkbook | Man page Source code |
| protectWorksheet | Man page Source code |
| pxml | Source code |
| read.xlsx | Man page Source code |
| read.xlsx.Workbook | Source code |
| read.xlsx.default | Source code |
| readUTF8 | Source code |
| readWorkbook | Man page Source code |
| read_file_newline | Source code |
| read_workbook | Source code |
| removeCellMerge | Man page Source code |
| removeColWidths | Man page Source code |
| removeComment | Man page Source code |
| removeFilter | Man page Source code |
| removeHeadTag | Source code |
| removeRowHeights | Man page Source code |
| removeTable | Man page Source code |
| removeWorksheet | Man page Source code |
| renameWorksheet | Man page Source code |
| replaceIllegalCharacters | Source code |
| replaceStyle | Man page Source code |
| replaceXMLEntities | Source code |
| saveWorkbook | Man page Source code |
| setColWidths | Man page Source code |
| setFooter | Man page Source code |
| setHeader | Man page Source code |
| setHeaderFooter | Man page Source code |
| setLastModifiedBy | Man page Source code |
| setRowHeights | Man page Source code |
| sheetVisibility | Man page Source code |
| sheetVisibility<- | Man page |
| sheetVisible | Man page Source code |
| sheetVisible<- | Man page |
| sheets | Man page Source code |
| showGridLines | Man page Source code |
| splitHeaderFooter | Source code |
| temp_xlsx | Man page Source code |
| ungroupColumns | Man page Source code |
| ungroupRows | Man page Source code |
| validateBorderStyle | Source code |
| validateColour | Source code |
| validate_StyleName | Source code |
| worksheetOrder | Man page Source code |
| worksheetOrder<- | Man page |
| write.xlsx | Man page Source code |
| writeComment | Man page Source code |
| writeCommentXML | Source code |
| writeData | Man page Source code |
| writeDataTable | Man page Source code |
| writeFormula | Man page Source code |
| write_file | Source code |
| write_worksheet_xml | Source code |
| write_worksheet_xml_2 | Source code |
| xml_to_hyperlink | Source code |
