Package: xlsx 0.6.5
Cole Arendt
xlsx: Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files
Provide R functions to read/write/format Excel 2007 and Excel 97/2000/XP/2003 file formats.
Authors:
xlsx_0.6.5.tar.gz
xlsx_0.6.5.tar.gz(r-4.5-noble)xlsx_0.6.5.tar.gz(r-4.4-noble)
xlsx_0.6.5.tgz(r-4.4-emscripten)xlsx_0.6.5.tgz(r-4.3-emscripten)
xlsx.pdf |xlsx.html✨
xlsx/json (API)
NEWS
| # Install 'xlsx' in R: |
| install.packages('xlsx', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/colearendt/xlsx/issues
Last updated 4 years agofrom:5a31898db0. Checks:OK: 2. Indexed: no.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Nov 23 2024 |
| R-4.5-linux | OK | Nov 23 2024 |
Exports:addAutoFilteraddDataFrameaddHyperlinkaddMergedRegionaddPictureAlignmentautoSizeColumnBorderBORDER_STYLES_CB.setBorderCB.setColDataCB.setFillCB.setFontCB.setMatrixDataCB.setRowDataCELL_STYLES_CellBlockCellProtectionCellStylecreateCellcreateCellCommentcreateFreezePanecreateRangecreateRowcreateSheetcreateSplitPanecreateWorkbookDataFormatFillFILL_STYLES_FontforceFormulaRefreshforcePivotTableRefreshget_java_tmp_dirgetCellCommentgetCellsgetCellStylegetCellValuegetRangesgetRowsgetSheetsHALIGN_STYLES_INDEXED_COLORS_is.Alignmentis.Borderis.CellBlockis.CellProtectionis.CellStyleis.DataFormatis.Fillis.FontloadWorkbookprintSetupread.xlsxread.xlsx2readColumnsreadRangereadRowsremoveCellCommentremoveMergedRegionremoveRowremoveSheetsaveWorkbookset_java_tmp_dirsetCellStylesetCellValuesetColumnWidthsetPrintAreasetRowHeightsetZoomVALIGN_STYLES_write.xlsxwrite.xlsx2
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files | xlsx-package xlsx |
| Add a 'data.frame' to a sheet. | addDataFrame |
| Add a hyperlink to a cell. | addHyperlink |
| Functions to manipulate cells. | Cell createCell getCells getCellValue setCellValue |
| Create and style a block of cells. | CB.setBorder CB.setColData CB.setFill CB.setFont CB.setMatrixData CB.setRowData CellBlock CellBlock.default is.CellBlock |
| Functions to manipulate cells. | CellStyle CellStyle.default getCellStyle is.CellStyle setCellStyle |
| CellStyle construction. | +.CellStyle CellStyle-plus |
| Functions to manipulate cell comments. | Comment createCellComment getCellComment removeCellComment |
| Force Refresh Pivot Tables and Formulae | forceFormulaRefresh forcePivotTableRefresh |
| Create an Alignment object. | Alignment is.Alignment |
| Create an Border object. | Border is.Border |
| Create a CellProtection object. | CellProtection is.CellProtection |
| Create an DataFormat object. | DataFormat is.DataFormat |
| Create an Fill object. | Fill is.Fill |
| Create a Font object. | Font is.Font |
| Functions to manipulate (contiguous) named ranges. | createRange getRanges NamedRanges readRange |
| Functions to do various spreadsheets effects. | addAutoFilter addMergedRegion autoSizeColumn createFreezePane createSplitPane OtherEffects removeMergedRegion setColumnWidth setPrintArea setZoom |
| Functions to manipulate images in a spreadsheet. | addPicture Picture |
| Constants used in the project. | BORDER_STYLES_ CELL_STYLES_ FILL_STYLES_ HALIGN_STYLES_ INDEXED_COLORS_ POI_constants VALIGN_STYLES_ |
| Function to manipulate print setup. | PrintSetup printSetup |
| Read the contents of a worksheet into an R 'data.frame'. | read.xlsx read.xlsx2 |
| Read a contiguous set of columns from sheet into an R data.frame | readColumns |
| Read a contiguous set of rows into an R matrix | readRows |
| Functions to manipulate rows of a worksheet. | createRow getRows removeRow Row setRowHeight |
| Set Java Temp Directory | get_java_tmp_dir set_java_tmp_dir |
| Functions to manipulate worksheets. | createSheet getSheets removeSheet Sheet Worksheet |
| Functions to manipulate Excel 2007 workbooks. | createWorkbook loadWorkbook saveWorkbook Workbook |
| Write a data.frame to an Excel workbook. | write.xlsx write.xlsx2 |
