This package is considered a duplicate. The official version of this package is found at:https://miraisolutions.r-universe.dev/XLConnect
Package: XLConnect 1.3.0
Martin Studer
XLConnect: Excel Connector for R
Provides comprehensive functionality to read, write and format Excel data.
Authors:
XLConnect_1.3.0.tar.gz
XLConnect_1.3.0.tar.gz(r-4.7-any)XLConnect_1.3.0.tar.gz(r-4.6-any)
XLConnect_1.3.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
XLConnect/json (API)
NEWS
| # Install 'XLConnect' in R: |
| install.packages('XLConnect', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/miraisolutions/xlconnect/issues
Datasets:
- swissfranc - Historical Exchange Rates: CHF vs EUR, USD and GBP
Last updated from:dc9b8e6601. Checks:4 OK. Indexed: no.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 142 | ||
| source / vignettes | OK | 215 | ||
| linux-release-x86_64 | OK | 165 | ||
| wasm-release | OK | 108 |
Exports:addImageappendNamedRegionappendWorksheetarefaref2idxclearNamedRegionclearRangeclearRangeFromReferenceclearSheetcloneSheetcol2idxconfigurePOIcreateCellStylecreateFreezePanecreateNamecreateSheetcreateSplitPanecref2idxexistsCellStyleexistsNameexistsSheetextractSheetNamegetActiveSheetIndexgetActiveSheetNamegetBoundingBoxgetCellFormulagetCellStylegetCellStyleForTypegetDefinedNamesgetForceFormulaRecalculationgetLastColumngetLastRowgetOrCreateCellStylegetReferenceCoordinatesgetReferenceCoordinatesForNamegetReferenceCoordinatesForTablegetReferenceFormulagetSheetPosgetSheetsgetTableshideSheetidx2arefidx2colidx2crefisSheetHiddenisSheetVeryHiddenisSheetVisibleloadWorkbookmergeCellsmirainormalizeDataframeonErrorCellprintreadNamedRegionreadNamedRegionFromFilereadTablereadWorksheetreadWorksheetFromFileremoveNameremovePaneremoveSheetrenameSheetsaveWorkbooksetActiveSheetsetAutoFiltersetBordersetCellFormulasetCellStylesetCellStyleForTypesetColumnWidthsetDataFormatsetDataFormatForTypesetFillBackgroundColorsetFillForegroundColorsetFillPatternsetForceFormulaRecalculationsetHyperlinksetMissingValuesetRowHeightsetSheetColorsetSheetPossetStyleActionsetStyleNamePrefixsetWrapTextshowsummaryunhideSheetunmergeCellswriteNamedRegionwriteNamedRegionToFilewriteWorksheetwriteWorksheetToFileXLCxlcDumpxlcEditxlcFreeMemoryxlcMemoryReportxlcRestore
Dependencies:rJava
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Excel Connector for R | XLConnect-package XLConnect |
| Executing workbook methods in object$method(...) form | $ $,cellstyle-method $,workbook-method $-methods |
| Adding images to a worksheet | addImage addImage,workbook-method addImage-methods |
| Appending data to a named region | appendNamedRegion appendNamedRegion,workbook,ANY-method appendNamedRegion,workbook-method appendNamedRegion-methods |
| Appending data to worksheets | appendWorksheet appendWorksheet,workbook,ANY,character-method appendWorksheet,workbook,ANY,numeric-method appendWorksheet-methods |
| Constructing Excel area references | aref |
| Converting Excel cell references to row and column based cell references | aref2idx |
| Class "cellstyle" | cellstyle-class |
| Clearing named regions in a workbook | clearNamedRegion clearNamedRegion,workbook,character-method clearNamedRegion-methods |
| Clearing cell ranges in a workbook | clearRange clearRange,workbook,character-method clearRange,workbook,numeric-method clearRange-methods |
| Clearing cell ranges in a workbook | clearRangeFromReference clearRangeFromReference,workbook,character-method clearRangeFromReference-methods |
| Clearing worksheets in a workbook | clearSheet clearSheet,workbook,character-method clearSheet,workbook,numeric-method clearSheet-methods |
| Cloning/copying worksheets | cloneSheet cloneSheet,workbook,character-method cloneSheet,workbook,numeric-method cloneSheet-methods |
| Converting Excel column names to indices | col2idx |
| Configuring Apache POI | configurePOI |
| Creating custom named and anonymous cell styles | createCellStyle createCellStyle,workbook,character-method createCellStyle,workbook,missing-method createCellStyle-methods |
| Creating a freeze pane on a worksheet | createFreezePane createFreezePane,workbook,character-method createFreezePane,workbook,numeric-method createFreezePane-methods |
| Creating names in a workbook | createName createName,workbook-method createName-methods |
| Creating worksheets in a workbook | createSheet createSheet,workbook-method createSheet-methods |
| Creating a split pane on a worksheet | createSplitPane createSplitPane,workbook,character-method createSplitPane,workbook,numeric-method createSplitPane-methods |
| Converting Excel cell references to indices | cref2idx |
| Retrieving named cell styles | existsCellStyle existsCellStyle,workbook-method existsCellStyle-methods |
| Checking existence of named ranges in a workbook | existsName existsName,workbook-method existsName-methods |
| Checking for existence of worksheets in a workbook | existsSheet existsSheet,workbook-method existsSheet-methods |
| Workbook data extraction & replacement operators | [ [,workbook-method [-methods [<- [<-,workbook-method [<--methods [[ [[,workbook-method [[-methods [[<- [[<-,workbook-method [[<--methods |
| Extracting the sheet name from a formula | extractSheetName |
| Querying the active worksheet index | getActiveSheetIndex getActiveSheetIndex,workbook-method getActiveSheetIndex-methods |
| Querying the active worksheet name | getActiveSheetName getActiveSheetName,workbook-method getActiveSheetName-methods |
| Querying the coordinates of a worksheet bounding box | getBoundingBox getBoundingBox,workbook,character-method getBoundingBox,workbook,numeric-method getBoundingBox-methods |
| Retrieving formula definitions from cells | getCellFormula getCellFormula,workbook,character-method getCellFormula,workbook,numeric-method getCellFormula-methods |
| Retrieving named cell styles | getCellStyle getCellStyle,workbook-method getCellStyle-methods |
| Querying the cell style per data type for the DATATYPE style action | getCellStyleForType getCellStyleForType,workbook-method getCellStyleForType-methods |
| Retrieving defined names in a workbook | getDefinedNames getDefinedNames,workbook-method getDefinedNames-methods |
| Querying the coordinates of the range reference by an Excel name | getForceFormulaRecalculation getForceFormulaRecalculation,workbook,character-method getForceFormulaRecalculation,workbook,numeric-method getForceFormulaRecalculation-methods |
| Querying the last (non-empty) column on a worksheet | getLastColumn getLastColumn,workbook,character-method getLastColumn,workbook,numeric-method getLastColumn-methods |
| Querying the last (non-empty) row on a worksheet | getLastRow getLastRow,workbook,character-method getLastRow,workbook,numeric-method getLastRow-methods |
| Retrieving or creating named cell styles | getOrCreateCellStyle getOrCreateCellStyle,workbook,character-method getOrCreateCellStyle-methods |
| Querying the coordinates of the range reference by an Excel name | getReferenceCoordinates getReferenceCoordinates,workbook-method getReferenceCoordinates-methods |
| Querying the coordinates of the range reference by an Excel name | getReferenceCoordinatesForName getReferenceCoordinatesForName,workbook-method getReferenceCoordinatesForName-methods |
| Querying the coordinates of the range of an Excel table | getReferenceCoordinatesForTable getReferenceCoordinatesForTable,workbook,character-method getReferenceCoordinatesForTable,workbook,numeric-method getReferenceCoordinatesForTable-methods |
| Querying reference formulas of Excel names | getReferenceFormula getReferenceFormula,workbook-method getReferenceFormula-methods |
| Querying worksheet position | getSheetPos getSheetPos,workbook,character-method getSheetPos-methods |
| Querying available worksheets in a workbook | getSheets getSheets,workbook-method getSheets-methods |
| Querying available Excel tables in a workbook | getTables getTables,workbook,character-method getTables,workbook,numeric-method getTables-methods |
| Hiding worksheets in a workbook | hideSheet hideSheet,workbook,character-method hideSheet,workbook,numeric-method hideSheet-methods |
| Converting row and column based area references to Excel area references | idx2aref |
| Converting column indices to Excel column names | idx2col |
| Converting indices to Excel cell references | idx2cref |
| Checking if worksheets are hidden in a workbook | isSheetHidden isSheetHidden,workbook,character-method isSheetHidden,workbook,numeric-method isSheetHidden-methods |
| Checking if worksheets are very hidden in a workbook | isSheetVeryHidden isSheetVeryHidden,workbook,character-method isSheetVeryHidden,workbook,numeric-method isSheetVeryHidden-methods |
| Checking if worksheets are visible in a workbook | isSheetVisible isSheetVisible,workbook,character-method isSheetVisible,workbook,numeric-method isSheetVisible-methods |
| Loading Microsoft Excel workbooks | loadWorkbook |
| Merging cells | mergeCells mergeCells,workbook,character-method mergeCells,workbook,numeric-method mergeCells-methods |
| Mirai Solutions GmbH | mirai |
| Behavior when error cells are detected | onErrorCell onErrorCell,workbook-method onErrorCell-methods |
| Print a workbook's filename | print print,workbook-method print-methods |
| Reading named regions from a workbook | readNamedRegion readNamedRegion,workbook-method readNamedRegion-methods |
| Reading named regions from an Excel file (wrapper function) | readNamedRegionFromFile |
| Reading Excel tables from a workbook | readTable readTable,workbook,character-method readTable,workbook,numeric-method readTable-methods |
| Reading data from worksheets | readWorksheet readWorksheet,workbook,character-method readWorksheet,workbook,numeric-method readWorksheet-methods |
| Reading data from worksheets in an Excel file (wrapper function) | readWorksheetFromFile |
| Removing names from workbooks | removeName removeName,workbook-method removeName-methods |
| Removing panes from worksheet | removePane removePane,workbook,character-method removePane,workbook,numeric-method removePane-methods |
| Removing worksheets from workbooks | removeSheet removeSheet,workbook,character-method removeSheet,workbook,numeric-method removeSheet-methods |
| Renaming worksheets from workbooks | renameSheet renameSheet,workbook,character-method renameSheet,workbook,numeric-method renameSheet-methods |
| Saving Microsoft Excel workbooks | saveWorkbook saveWorkbook,workbook,character-method saveWorkbook,workbook,missing-method saveWorkbook-methods |
| Setting the active worksheet in a workbook | setActiveSheet setActiveSheet,workbook,character-method setActiveSheet,workbook,numeric-method setActiveSheet-methods |
| Setting auto-filters on worksheets | setAutoFilter setAutoFilter,workbook,character-method setAutoFilter,workbook,numeric-method setAutoFilter-methods |
| Specifying borders for cell styles | setBorder setBorder,cellstyle-method setBorder-methods |
| Setting cell formulas | setCellFormula setCellFormula,workbook,character-method setCellFormula,workbook,numeric-method setCellFormula-methods |
| Setting cell styles | setCellStyle setCellStyle,workbook,character,missing-method setCellStyle,workbook,missing,character-method setCellStyle,workbook,missing,numeric-method setCellStyle-methods |
| Setting the cell style per data type for the DATATYPE style action | setCellStyleForType setCellStyleForType,workbook-method setCellStyleForType-methods |
| Setting the width of a column in a worksheet | setColumnWidth setColumnWidth,workbook,character-method setColumnWidth,workbook,numeric-method setColumnWidth-methods |
| Specifying custom data formats for cell styles | setDataFormat setDataFormat,cellstyle-method setDataFormat-methods |
| Setting the data format for the DATA_FORMAT_ONLY style action | setDataFormatForType setDataFormatForType,workbook-method setDataFormatForType-methods |
| Specifying the fill background color for cell styles | setFillBackgroundColor setFillBackgroundColor,cellstyle,numeric-method setFillBackgroundColor-methods |
| Specifying the fill foreground color for cell styles | setFillForegroundColor setFillForegroundColor,cellstyle,numeric-method setFillForegroundColor-methods |
| Specifying the fill pattern for cell styles | setFillPattern setFillPattern,cellstyle-method setFillPattern-methods |
| Forcing Excel to recalculate formula values when opening a workbook | setForceFormulaRecalculation setForceFormulaRecalculation,workbook,character-method setForceFormulaRecalculation,workbook,numeric-method setForceFormulaRecalculation-methods |
| Setting hyperlinks | setHyperlink setHyperlink,workbook,character,missing-method setHyperlink,workbook,missing,character-method setHyperlink,workbook,missing,numeric-method setHyperlink-methods |
| Setting missing value identifiers | setMissingValue setMissingValue,workbook,ANY-method setMissingValue,workbook-method setMissingValue-methods |
| Setting the height of a row in a worksheet | setRowHeight setRowHeight,workbook,character-method setRowHeight,workbook,numeric-method setRowHeight-methods |
| Setting colors on worksheet tabs | setSheetColor setSheetColor,workbook,character-method setSheetColor,workbook,numeric-method setSheetColor-methods |
| Setting worksheet position | setSheetPos setSheetPos,workbook,character,missing-method setSheetPos,workbook,character,numeric-method setSheetPos-methods |
| Controlling application of cell styles when writing data to Excel | setStyleAction setStyleAction,workbook-method setStyleAction-methods |
| Setting the style name prefix for the "name prefix" style action | setStyleNamePrefix setStyleNamePrefix,workbook-method setStyleNamePrefix-methods |
| Specifying text wrapping behaviour | setWrapText setWrapText,cellstyle-method setWrapText-methods |
| Display a workbook object | show show,workbook-method show-methods |
| Summarizing workbook objects | summary summary,workbook-method summary-methods |
| Historical Exchange Rates: CHF vs EUR, USD and GBP | swissfranc |
| Unhiding worksheets in a workbook | unhideSheet unhideSheet,workbook,character-method unhideSheet,workbook,numeric-method unhideSheet-methods |
| Unmerging cells | unmergeCells unmergeCells,workbook,character-method unmergeCells,workbook,numeric-method unmergeCells-methods |
| Evaluate an R expression in a workbook environment | with.workbook |
| Class "workbook" | workbook-class |
| Writing named regions to a workbook | writeNamedRegion writeNamedRegion,workbook,ANY-method writeNamedRegion,workbook-method writeNamedRegion-methods |
| Writing named regions to an Excel file (wrapper function) | writeNamedRegionToFile |
| Writing data to worksheets | writeWorksheet writeWorksheet,workbook,ANY,character-method writeWorksheet,workbook,ANY,numeric-method writeWorksheet-methods |
| Writing data to worksheets in an Excel file (wrapper function) | writeWorksheetToFile |
| XLConnect Constants | XLC |
| Dumping data sets to Excel files | xlcDump |
| Editing data sets in an Excel file editor | xlcEdit |
| Freeing Java Virtual Machine memory | xlcFreeMemory |
| Reporting free Java Virtual Machine memory | xlcMemoryReport |
| Deprecated functions in package 'XLConnect' | XLConnect-deprecated |
| Restoring objects from Excel files | xlcRestore |
