Package: openxlsx 4.2.7
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:
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
# Install 'openxlsx' in R: |
install.packages('openxlsx', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/ycphs/openxlsx/issues
- openxlsxFontSizeLookupTable - Font Size Lookup tables
- openxlsxFontSizeLookupTableBold - Font Size Lookup tables
Last updated 8 days agofrom:b2500cfcf1. Checks:OK: 1 ERROR: 1. Indexed: no.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Aug 31 2024 |
R-4.5-linux-x86_64 | ERROR | Aug 31 2024 |
Exports:activeSheetactiveSheet<-addCreatoraddFilteraddStyleaddWorksheetauto_heightsbuildWorkbookcloneWorksheetcol2intconditionalFormatconditionalFormattingconvertFromExcelRefconvertToDateconvertToDateTimecopyWorkbookcreateCommentcreateNamedRegioncreateStylecreateWorkbookdataValidationdeleteDatadeleteDataColumndeleteNamedRegionfreezePaneget_worksheet_entriesgetBaseFontgetCellRefsgetCreatorsgetDateOrigingetNamedRegionsgetSheetNamesgetStylesgetTablesgetWindowSizegroupColumnsgroupRowsinsertImageinsertPlotint2colloadWorkbookmakeHyperlinkStringmergeCellsmodifyBaseFontop.openxlsxopenXLopenxlsx_getOpopenxlsx_setOppageBreakpageSetupprotectWorkbookprotectWorksheetread.xlsxreadWorkbookremoveCellMergeremoveColWidthsremoveCommentremoveFilterremoveRowHeightsremoveTableremoveWorksheetrenameWorksheetreplaceStylesaveWorkbooksetColWidthssetFootersetHeadersetHeaderFootersetLastModifiedBysetRowHeightssetWindowSizesheetssheetVisibilitysheetVisibility<-sheetVisiblesheetVisible<-showGridLinestemp_xlsxungroupColumnsungroupRowsworksheetOrderworksheetOrder<-write.xlsxwriteCommentwriteDatawriteDataTablewriteFormula