Package: XLConnect 1.1.0
XLConnect: Excel Connector for R
Provides comprehensive functionality to read, write and format Excel data.
Authors:
XLConnect_1.1.0.tar.gz
XLConnect_1.1.0.tar.gz(r-4.5-noble)XLConnect_1.1.0.tar.gz(r-4.4-noble)
XLConnect_1.1.0.tgz(r-4.4-emscripten)XLConnect_1.1.0.tgz(r-4.3-emscripten)
XLConnect.pdf |XLConnect.html✨
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
- swissfranc - Historical Exchange Rates: CHF vs EUR, USD and GBP
Last updated 4 months agofrom:07ee8eed0a. Checks:OK: 2. Indexed: no.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Nov 21 2024 |
R-4.5-linux | OK | Nov 21 2024 |
Exports:addImageappendNamedRegionappendWorksheetarefaref2idxclearNamedRegionclearRangeclearRangeFromReferenceclearSheetcloneSheetcol2idxcreateCellStylecreateFreezePanecreateNamecreateSheetcreateSplitPanecref2idxexistsCellStyleexistsNameexistsSheetextractSheetNamegetActiveSheetIndexgetActiveSheetNamegetBoundingBoxgetCellFormulagetCellStylegetCellStyleForTypegetDefinedNamesgetForceFormulaRecalculationgetLastColumngetLastRowgetOrCreateCellStylegetReferenceCoordinatesgetReferenceCoordinatesForNamegetReferenceCoordinatesForTablegetReferenceFormulagetSheetPosgetSheetsgetTableshideSheetidx2arefidx2colidx2crefisSheetHiddenisSheetVeryHiddenisSheetVisibleloadWorkbookmergeCellsmirainormalizeDataframeonErrorCellprintreadNamedRegionreadNamedRegionFromFilereadTablereadWorksheetreadWorksheetFromFileremoveNameremovePaneremoveSheetrenameSheetsaveWorkbooksetActiveSheetsetAutoFiltersetBordersetCellFormulasetCellStylesetCellStyleForTypesetColumnWidthsetDataFormatsetDataFormatForTypesetFillBackgroundColorsetFillForegroundColorsetFillPatternsetForceFormulaRecalculationsetHyperlinksetMissingValuesetRowHeightsetSheetColorsetSheetPossetStyleActionsetStyleNamePrefixsetWrapTextshowsummaryunhideSheetunmergeCellswriteNamedRegionwriteNamedRegionToFilewriteWorksheetwriteWorksheetToFileXLCxlcDumpxlcEditxlcFreeMemoryxlcMemoryReportxlcRestore
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 |
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 |