XLConnect v0.2-14


Monthly downloads



Excel Connector for R

Provides comprehensive functionality to read, write and format Excel data.


XLConnect: Excel Connector for R

CRAN\_Status\_Badge Rdoc Research software impact Build Status codecov

XLConnect is a comprehensive and cross-platform R package for manipulating Microsoft Excel files from within R. XLConnect differs from other related R packages in that it is completely cross-platform and as such runs under Windows, Unix/Linux and Mac (32- and 64-bit). Moreover, it does not require any installation of Microsoft Excel or any other special drivers to be able to read & write Excel files. The only requirement is a recent version of a Java Runtime Environment (JRE).

The package can easily be installed from CRAN via install.packages("XLConnect"). In order to get started have a look at the XLConnect and XLConnect for the Impatient package vignettes, the numerous demos available via demo(package = "XLConnect") or browse through the comprehensive reference manual.

Alternatively, you may install XLConnect directly from our github repository using the excellent devtools package:


# Installs the master branch of XLConnect (= current development version)
install_github("xlconnect", username = "miraisolutions", ref = "master")

# Installs XLConnect 0.2-14
install_github("xlconnect", username = "miraisolutions", ref = "0.2-14")

For more examples and news see also our wordpress site.

Please send any enhancement requests or bug reports with a simple and self-contained reproducible example to xlconnect@mirai-solutions.com or log a corresponding issue on our github repository. For other questions you may also use Stackoverflow.

Functions in XLConnect

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

Vignettes of XLConnect

No Results!

Last month downloads


Type Package
Date 2018-01-23
URL http://www.mirai-solutions.com https://github.com/miraisolutions/xlconnect
BugReports https://github.com/miraisolutions/xlconnect/issues
SystemRequirements Java (>= 6)
License GPL-3
Copyright See file COPYRIGHTS
LazyData yes
NeedsCompilation no
Packaged 2018-01-23 09:14:48 UTC; mstuder
Repository CRAN
Date/Publication 2018-01-23 16:51:45 UTC

Include our badge in your README