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` `[` `[[` `[,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

Reference

All functions