Package: openxlsx 4.2.7

Jan Marvin Garbuszus

openxlsx: Read, Write and Edit xlsx Files

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.

Authors:Philipp Schauberger [aut], Alexander Walker [aut], Luca Braglia [ctb], Joshua Sturm [ctb], Jan Marvin Garbuszus [ctb, cre], Jordan Mark Barbone [ctb], David Zimmermann [ctb], Reinhold Kainhofer [ctb]

openxlsx_4.2.7.tar.gz
openxlsx_4.2.7.tar.gz(r-4.5-noble)openxlsx_4.2.7.tar.gz(r-4.4-noble)
openxlsx_4.2.7.tgz(r-4.4-emscripten)openxlsx_4.2.7.tgz(r-4.3-emscripten)
openxlsx.pdf |openxlsx.html✨
openxlsx/json (API)
NEWS

Peer review:

Bug tracker:https://github.com/ycphs/openxlsx/issues

87 exports 8.66 score 3 dependencies 255 dependents 35 mentions 16.2k scripts 337.0k downloads

Last updated 8 days agofrom:b2500cfcf1. Checks:OK: 1 ERROR: 1. Indexed: no.

Exports:activeSheetactiveSheet<-addCreatoraddFilteraddStyleaddWorksheetauto_heightsbuildWorkbookcloneWorksheetcol2intconditionalFormatconditionalFormattingconvertFromExcelRefconvertToDateconvertToDateTimecopyWorkbookcreateCommentcreateNamedRegioncreateStylecreateWorkbookdataValidationdeleteDatadeleteDataColumndeleteNamedRegionfreezePaneget_worksheet_entriesgetBaseFontgetCellRefsgetCreatorsgetDateOrigingetNamedRegionsgetSheetNamesgetStylesgetTablesgetWindowSizegroupColumnsgroupRowsinsertImageinsertPlotint2colloadWorkbookmakeHyperlinkStringmergeCellsmodifyBaseFontop.openxlsxopenXLopenxlsx_getOpopenxlsx_setOppageBreakpageSetupprotectWorkbookprotectWorksheetread.xlsxreadWorkbookremoveCellMergeremoveColWidthsremoveCommentremoveFilterremoveRowHeightsremoveTableremoveWorksheetrenameWorksheetreplaceStylesaveWorkbooksetColWidthssetFootersetHeadersetHeaderFootersetLastModifiedBysetRowHeightssetWindowSizesheetssheetVisibilitysheetVisibility<-sheetVisiblesheetVisible<-showGridLinestemp_xlsxungroupColumnsungroupRowsworksheetOrderworksheetOrder<-write.xlsxwriteCommentwriteDatawriteDataTablewriteFormula

Dependencies:Rcppstringizip