Package: openxlsx 4.2.7.9000

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.9000.tar.gz
openxlsx_4.2.7.9000.zip(r-4.5)openxlsx_4.2.7.9000.zip(r-4.4)openxlsx_4.2.7.9000.zip(r-4.3)
openxlsx_4.2.7.9000.tgz(r-4.4-x86_64)openxlsx_4.2.7.9000.tgz(r-4.4-arm64)openxlsx_4.2.7.9000.tgz(r-4.3-x86_64)openxlsx_4.2.7.9000.tgz(r-4.3-arm64)
openxlsx_4.2.7.9000.tar.gz(r-4.5-noble)openxlsx_4.2.7.9000.tar.gz(r-4.4-noble)
openxlsx_4.2.7.9000.tgz(r-4.4-emscripten)openxlsx_4.2.7.9000.tgz(r-4.3-emscripten)
openxlsx.pdf |openxlsx.html
openxlsx/json (API)
NEWS

# Install 'openxlsx' in R:
install.packages('openxlsx', repos = c('https://ycphs.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

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

Uses libs:
  • c++– GNU Standard C++ Library v3
Datasets:

On CRAN:

xlsx

87 exports 225 stars 18.71 score 3 dependencies 258 dependents 35 mentions 16.9k scripts 301.6k downloads

Last updated 5 days agofrom:cb3c123714. Checks:OK: 9. Indexed: yes.

TargetResultDate
Doc / VignettesOKOct 09 2024
R-4.5-win-x86_64OKOct 09 2024
R-4.5-linux-x86_64OKOct 09 2024
R-4.4-win-x86_64OKOct 09 2024
R-4.4-mac-x86_64OKOct 09 2024
R-4.4-mac-aarch64OKOct 09 2024
R-4.3-win-x86_64OKOct 09 2024
R-4.3-mac-x86_64OKOct 09 2024
R-4.3-mac-aarch64OKOct 09 2024

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

Dependencies:Rcppstringizip

Formating with xlsx

Rendered fromFormatting.Rmdusingknitr::rmarkdownon Oct 09 2024.

Last update: 2024-08-30
Started: 2020-08-11

Introduction

Rendered fromIntroduction.Rmdusingknitr::rmarkdownon Oct 09 2024.

Last update: 2024-08-11
Started: 2020-08-11

Readme and manuals

Help Manual

Help pageTopics
Get/set active sheet of the workbookactiveSheet activeSheet<-
Add another author to the meta data of the file.addCreator
Add column filtersaddFilter
Add a style to a set of cellsaddStyle
Add a worksheet to a workbookaddWorksheet
Check equality of workbooksall.equal all.equal.Workbook
'as.character.formula()'as.character.formula
Compute optimal row heightsauto_heights
Build WorkbookbuildWorkbook
Clone a worksheet to a workbookcloneWorksheet
Convert Excel column to integercol2int
Add conditional formatting to cellsconditionalFormat
Add conditional formatting to cellsconditionalFormatting databar
Convert excel column name to integer indexconvertFromExcelRef
Convert from excel date number to R Date typeconvertToDate
Convert from excel time number to R POSIXct type.convertToDateTime
Copy a Workbook object.copyWorkbook
create a Comment objectcreateComment
Create / delete a named region.createNamedRegion deleteNamedRegion
Create a cell stylecreateStyle
Create a new Workbook objectcreateWorkbook
Add data validation to cellsdataValidation
Delete cell datadeleteData
Deletes a whole column from a workbookdeleteDataColumn
Freeze a worksheet panefreezePane
Get entries from workbook worksheetget_worksheet_entries
Return the workbook default fontgetBaseFont
Return excel cell coordinates from (x,y) coordinatesgetCellRefs
Get the names of the authors from the meta data of the file.getCreators
Get the date origin an xlsx file is usinggetDateOrigin
Get named regionsgetNamedRegions
Get names of worksheetsgetSheetNames
Returns a list of all styles in the workbookgetStyles
List Excel tables in a workbookgetTables
Group columnsgroupColumns
Group RowsgroupRows
If NULL then ...%||% if_null_then
Insert an image into a worksheetinsertImage
Insert the current plot into a worksheetinsertPlot
Convert integer to Excel columnint2col
Load an existing .xlsx fileloadWorkbook
create Excel hyperlink stringmakeHyperlinkString
Merge cells within a worksheetmergeCells
Modify the default fontmodifyBaseFont
get or set worksheet namesnames names.Workbook names<-.Workbook
Open a Microsoft Excel file (xls/xlsx) or an openxlsx WorkbookopenXL
xlsx reading, writing and editing.openxlsx-package openxlsx
openxlsx Optionsop.openxlsx openxlsx_getOp openxlsx_options openxlsx_setOp
Font Size Lookup tablesopenxlsxFontSizeLookupTable openxlsxFontSizeLookupTableBold
add a page break to a worksheetpageBreak
Set page margins, orientation and print scalingpageSetup
Protect a workbook from modificationsprotectWorkbook
Protect a worksheet from modificationsprotectWorksheet
Read from an Excel file or Workbook objectread.xlsx
Read from an Excel file or Workbook objectreadWorkbook
Create a new Workbook objectremoveCellMerge
Remove column widths from a worksheetremoveColWidths
Remove a comment from a cellremoveComment
Remove a worksheet filterremoveFilter
Remove custom row heights from a worksheetremoveRowHeights
Remove an Excel table in a workbookremoveTable
Remove a worksheet from a workbookremoveWorksheet
Rename a worksheetrenameWorksheet
Replace an existing cell stylereplaceStyle
save Workbook to filesaveWorkbook
Set worksheet column widthssetColWidths
Set footer for all worksheetssetFooter
Set header for all worksheetssetHeader
Set document headers and footerssetHeaderFooter
Set the author who modified the file last.setLastModifiedBy
Set worksheet row heightssetRowHeights
Set and Get Window Size for xlsx filegetWindowSize setWindowSize
Returns names of worksheets.sheets
Get/set worksheet visible statesheetVisibility sheetVisibility<-
Get worksheet visible state.sheetVisible sheetVisible<-
Set worksheet gridlines to show or hide.showGridLines
helper function to create tempory directory for testing purposetemp_xlsx
Ungroup ColumnsungroupColumns
Ungroup RowsungroupRows
Order of worksheets in xlsx fileworksheetOrder worksheetOrder<-
write data to an xlsx filewrite.xlsx
write a cell commentwriteComment
Write an object to a worksheetwriteData
Write to a worksheet as an Excel tablewriteDataTable
Write a character vector as an Excel FormulawriteFormula