API for openxlsx
Read, Write and Edit XLSX Files

Global functions
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
buildBorder Source code
buildCellList Source code
buildCellTypes Source code
buildFillList Source code
buildFontList Source code
buildMatrixMixed Source code
buildMatrixNumeric 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
chooseExcelApp Source code
classStyles Source code
clean_names Source code
col2hex 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
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
genBaseTable 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
getDateOrigin Man page 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_shared_strings Source code
get_style_max_char_width Source code
headerFooterSub Source code
insertImage Man page Source code
insertPlot Man page Source code
int2col Man page Source code
int_2_cell_ref Source code
isInternalHyperlink 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
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
openXL Man page Source code
openxlsx Man page
openxlsx-package 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
pageBreak Man page Source code
pageSetup Man page Source code
pixels2ExcelColWidth Source code
pxml Source code
read.xlsx Man page Source code
read.xlsx.Workbook Source code
read.xlsx.default 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
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
validateBorderStyle Source code
validateColour 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
writeFile Source code
writeFormula Man page Source code
write_worksheet_xml Source code
write_worksheet_xml_2 Source code
xml_to_hyperlink Source code
openxlsx documentation built on May 30, 2017, 5:37 a.m.