Package index • XLConnect

All functions

XLC: XLConnect Constants
XLConnect-deprecated: Deprecated functions in package XLConnect
XLConnect-package XLConnect: Excel Connector for R
addImage(<workbook>): Adding images to a worksheet
appendNamedRegion(<workbook>,<ANY>): Appending data to a named region
appendWorksheet(<workbook>,<ANY>,<character>) appendWorksheet(<workbook>,<ANY>,<numeric>): Appending data to worksheets
aref(): Constructing Excel area references
aref2idx(): Converting Excel cell references to row and column based cell references
cellstyle-class: Class "cellstyle"
clearNamedRegion(<workbook>,<character>): Clearing named regions in a workbook
clearRange(<workbook>,<numeric>) clearRange(<workbook>,<character>): Clearing cell ranges in a workbook
clearRangeFromReference(<workbook>,<character>): Clearing cell ranges in a workbook
clearSheet(<workbook>,<numeric>) clearSheet(<workbook>,<character>): Clearing worksheets in a workbook
cloneSheet(<workbook>,<numeric>) cloneSheet(<workbook>,<character>): Cloning/copying worksheets
col2idx(): Converting Excel column names to indices
configurePOI(): Configuring Apache POI
createCellStyle(<workbook>,<character>): Creating custom named and anonymous cell styles
createFreezePane(<workbook>,<character>) createFreezePane(<workbook>,<numeric>): Creating a freeze pane on a worksheet
createName(<workbook>): Creating names in a workbook
createSheet(<workbook>): Creating worksheets in a workbook
createSplitPane(<workbook>,<character>) createSplitPane(<workbook>,<numeric>): Creating a split pane on a worksheet
cref2idx(): Converting Excel cell references to indices
$ $-methods $,workbook-method $,cellstyle-method: Executing workbook methods in object$method(...) form
existsCellStyle(<workbook>): Retrieving named cell styles
existsName(<workbook>): Checking existence of named ranges in a workbook
existsSheet(<workbook>): Checking for existence of worksheets in a workbook
extractSheetName(): Extracting the sheet name from a formula
[ [[ [<- [[<- [-methods [[-methods [<--methods [[<--methods [,workbook-method [[,workbook-method [<-,workbook-method [[<-,workbook-method: Workbook data extraction & replacement operators
getActiveSheetIndex(<workbook>): Querying the active worksheet index
getActiveSheetName(<workbook>): Querying the active worksheet name
getBoundingBox(<workbook>,<character>) getBoundingBox(<workbook>,<numeric>): Querying the coordinates of a worksheet bounding box
getCellFormula(<workbook>,<character>) getCellFormula(<workbook>,<numeric>): Retrieving formula definitions from cells
getCellStyle(<workbook>): Retrieving named cell styles
getCellStyleForType(<workbook>): Querying the cell style per data type for the DATATYPE style action
getDefinedNames(<workbook>): Retrieving defined names in a workbook
getForceFormulaRecalculation(<workbook>,<character>) getForceFormulaRecalculation(<workbook>,<numeric>): Querying the coordinates of the range reference by an Excel name
getLastColumn(<workbook>,<character>) getLastColumn(<workbook>,<numeric>): Querying the last (non-empty) column on a worksheet
getLastRow(<workbook>,<character>) getLastRow(<workbook>,<numeric>): Querying the last (non-empty) row on a worksheet
getOrCreateCellStyle(<workbook>,<character>): Retrieving or creating named cell styles
getReferenceCoordinates(<workbook>): Querying the coordinates of the range reference by an Excel name
getReferenceCoordinatesForName(<workbook>): Querying the coordinates of the range reference by an Excel name
getReferenceCoordinatesForTable(<workbook>,<numeric>) getReferenceCoordinatesForTable(<workbook>,<character>): Querying the coordinates of the range of an Excel table
getReferenceFormula(<workbook>): Querying reference formulas of Excel names
getSheetPos(<workbook>,<character>): Querying worksheet position
getSheets(<workbook>): Querying available worksheets in a workbook
getTables(<workbook>,<numeric>) getTables(<workbook>,<character>): Querying available Excel tables in a workbook
hideSheet(<workbook>,<character>) hideSheet(<workbook>,<numeric>): Hiding worksheets in a workbook
idx2aref(): Converting row and column based area references to Excel area references
idx2col(): Converting column indices to Excel column names
idx2cref(): Converting indices to Excel cell references
isSheetHidden(<workbook>,<character>) isSheetHidden(<workbook>,<numeric>): Checking if worksheets are hidden in a workbook
isSheetVeryHidden(<workbook>,<character>) isSheetVeryHidden(<workbook>,<numeric>): Checking if worksheets are very hidden in a workbook
isSheetVisible(<workbook>,<character>) isSheetVisible(<workbook>,<numeric>): Checking if worksheets are visible in a workbook
loadWorkbook(): Loading Microsoft Excel workbooks
mergeCells(<workbook>,<character>) mergeCells(<workbook>,<numeric>): Merging cells
mirai: Mirai Solutions GmbH
onErrorCell(<workbook>): Behavior when error cells are detected
print(<workbook>): Print a workbook's filename
readNamedRegion(<workbook>): Reading named regions from a workbook
readNamedRegionFromFile(): Reading named regions from an Excel file (wrapper function)
readTable(<workbook>,<numeric>) readTable(<workbook>,<character>): Reading Excel tables from a workbook
readWorksheet(<workbook>,<numeric>) readWorksheet(<workbook>,<character>): Reading data from worksheets
readWorksheetFromFile(): Reading data from worksheets in an Excel file (wrapper function)
removeName(<workbook>): Removing names from workbooks
removePane(<workbook>,<character>) removePane(<workbook>,<numeric>): Removing panes from worksheet
removeSheet(<workbook>,<character>) removeSheet(<workbook>,<numeric>): Removing worksheets from workbooks
renameSheet(<workbook>,<character>) renameSheet(<workbook>,<numeric>): Renaming worksheets from workbooks
saveWorkbook(<workbook>,<missing>) saveWorkbook(<workbook>,<character>): Saving Microsoft Excel workbooks
setActiveSheet(<workbook>,<character>) setActiveSheet(<workbook>,<numeric>): Setting the active worksheet in a workbook
setAutoFilter(<workbook>,<character>) setAutoFilter(<workbook>,<numeric>): Setting auto-filters on worksheets
setBorder(<cellstyle>): Specifying borders for cell styles
setCellFormula(<workbook>,<character>) setCellFormula(<workbook>,<numeric>): Setting cell formulas
setCellStyle(<workbook>,<missing>,<character>) setCellStyle(<workbook>,<missing>,<numeric>) setCellStyle(<workbook>,<character>,<missing>): Setting cell styles
setCellStyleForType(<workbook>): Setting the cell style per data type for the DATATYPE style action
setColumnWidth(<workbook>,<character>) setColumnWidth(<workbook>,<numeric>): Setting the width of a column in a worksheet
setDataFormat(<cellstyle>): Specifying custom data formats for cell styles
setDataFormatForType(<workbook>): Setting the data format for the DATA_FORMAT_ONLY style action
setFillBackgroundColor(<cellstyle>,<numeric>): Specifying the fill background color for cell styles
setFillForegroundColor(<cellstyle>,<numeric>): Specifying the fill foreground color for cell styles
setFillPattern(<cellstyle>): Specifying the fill pattern for cell styles
setForceFormulaRecalculation(<workbook>,<character>) setForceFormulaRecalculation(<workbook>,<numeric>): Forcing Excel to recalculate formula values when opening a workbook
setHyperlink(<workbook>,<missing>,<character>) setHyperlink(<workbook>,<missing>,<numeric>) setHyperlink(<workbook>,<character>,<missing>): Setting hyperlinks
setMissingValue(<workbook>,<ANY>): Setting missing value identifiers
setRowHeight(<workbook>,<character>) setRowHeight(<workbook>,<numeric>): Setting the height of a row in a worksheet
setSheetColor(<workbook>,<character>) setSheetColor(<workbook>,<numeric>): Setting colors on worksheet tabs
setSheetPos(<workbook>,<character>,<numeric>): Setting worksheet position
setStyleAction(<workbook>): Controlling application of cell styles when writing data to Excel
setStyleNamePrefix(<workbook>): Setting the style name prefix for the "name prefix" style action
setWrapText(<cellstyle>): Specifying text wrapping behaviour
show(<workbook>): Display a workbook object
summary(<workbook>): Summarizing workbook objects
swissfranc: Historical Exchange Rates: CHF vs EUR, USD and GBP
unhideSheet(<workbook>,<character>) unhideSheet(<workbook>,<numeric>): Unhiding worksheets in a workbook
unmergeCells(<workbook>,<character>) unmergeCells(<workbook>,<numeric>): Unmerging cells
with(<workbook>): Evaluate an R expression in a workbook environment
workbook-class: Class "workbook"
writeNamedRegion(<workbook>,<ANY>): Writing named regions to a workbook
writeNamedRegionToFile(): Writing named regions to an Excel file (wrapper function)
writeWorksheet(<workbook>,<ANY>,<character>) writeWorksheet(<workbook>,<ANY>,<numeric>): Writing data to worksheets
writeWorksheetToFile(): Writing data to worksheets in an Excel file (wrapper function)
xlcDump(): Dumping data sets to Excel files
xlcEdit(): Editing data sets in an Excel file editor
xlcFreeMemory(): Freeing Java Virtual Machine memory
xlcMemoryReport(): Reporting free Java Virtual Machine memory
xlcRestore(): Restoring objects from Excel files