RDocumentation
Moon
Learn R
Search all packages and functions
⚠️
There's a newer version (1.0.9) of this package.
Take me there.
XLConnect (version 0.2-11)
Excel Connector for R
Description
Provides comprehensive functionality to read, write and format Excel data.
Copy Link
Copy
Link to current version
Version
Version
1.0.9
1.0.8
1.0.7
1.0.6
1.0.5
1.0.4
1.0.3
1.0.2
1.0.1
1.0.0
0.2-15
0.2-14
0.2-13
0.2-12
0.2-11
0.2-10
0.2-9
0.2-8
0.2-7
0.2-6
0.2-5
0.2-4
0.2-3
0.2-2
0.2-1
0.2-0
0.1-9
0.1-8
0.1-7
0.1-5
0.1-4
0.1-3
Down Chevron
Install
install.packages('XLConnect')
Monthly Downloads
8,281
Version
0.2-11
License
GPL-3
Homepage
http://www.mirai-solutions.com
Maintainer
Martin Studer
Last Published
March 1st, 2015
Functions in XLConnect (0.2-11)
Search functions
createSplitPane-methods
Creating a split pane on a worksheet
getForceFormulaRecalculation-methods
Querying the coordinates of the range reference by an Excel name
isSheetHidden-methods
Checking if worksheets are hidden in a workbook
setDataFormatForType-methods
Setting the data format for the DATA_FORMAT_ONLY style action
XLConnectSettings
Performing general settings for XLConnect
appendWorksheet-methods
Appending data to worksheets
existsName-methods
Checking existence of names in a workbook
idx2cref
Converting indices to Excel cell references
getReferenceCoordinatesForName-methods
Querying the coordinates of the range reference by an Excel name
$-methods
Executing workbook methods in object$method(...) form
getActiveSheetName-methods
Querying the active worksheet name
normalizeDataframe
Data frame Normalization for Unit Tests
aref
Constructing Excel area references
loadWorkbook
Loading Microsoft Excel workbooks
setSheetColor-methods
Setting colors on worksheet tabs
setCellStyle-methods
Setting cell styles
onErrorCell-methods
Behavior when error cells are detected
readNamedRegionFromFile
Reading named regions from an Excel file (wrapper function)
isSheetVeryHidden-methods
Checking if worksheets are very hidden in a workbook
removePane-methods
Removing panes from worksheet
getSheets-methods
Querying available worksheets in a workbook
setWrapText-methods
Specifying text wrapping behaviour
writeWorksheetToFile
Writing data to worksheets in an Excel file (wrapper function)
xlcDump
Dumping data sets to Excel files
renameSheet-methods
Renaming worksheets from workbooks
xlcMemoryReport
Reporting free Java Virtual Machine memory
XLC
XLConnect Constants
addImage-methods
Adding images to a worksheet
appendNamedRegion-methods
Appending data to a named region
xlcEdit
Editing data sets in an Excel file editor
swissfranc
Historical Exchange Rates: CHF vs EUR, USD and GBP
writeWorksheet-methods
Writing data to worksheets
getDefinedNames-methods
Retrieving defined names in a workbook
setActiveSheet-methods
Setting the active worksheet in a workbook
getCellStyleForType-methods
Querying the cell style per data type for the DATATYPE style action
clearNamedRegion-methods
Clearing named regions in a workbook
setAutoFilter-methods
Setting auto-filters on worksheets
xlcCall
Automatic argument vectorization, default Java exception and warnings handling for XLConnect
wrapList
Wrapping of arguments in a list
clearRange-methods
Clearing cell ranges in a workbook
XLConnect-package
Excel Connector for R
getBoundingBox-methods
Querying the coordinates of a worksheet bounding box
readNamedRegion
Reading named regions from a workbook
removeName-methods
Removing names from workbooks
extraction-methods
Workbook data extraction & replacement operators
setCellStyleForType-methods
Setting the cell style per data type for the DATATYPE style action
clearRangeFromReference-methods
Clearing cell ranges in a workbook
hideSheet-methods
Hiding worksheets in a workbook
cref2idx
Converting Excel cell references to indices
writeNamedRegion-methods
Writing named regions to a workbook
getSheetPos-methods
Querying worksheet position
getCellFormula-methods
Retrieving formula definitions from cells
setFillForegroundColor-methods
Specifying the fill foreground color for cell styles
mirai
Mirai Solutions GmbH
createCellStyle-methods
Creating custom named and anonymous cell styles
getLastRow-methods
Querying the last (non-empty) row on a worksheet
setForceFormulaRecalculation-methods
Forcing Excel to recalculate formula values when opening a workbook
xlcRestore
Restoring objects from Excel files
clearSheet-methods
Clearing worksheets in a workbook
cloneSheet-methods
Cloning/copying worksheets
createName-methods
Creating names in a workbook
print-methods
Print a workbook's filename
readTable
Reading Excel tables from a workbook
getActiveSheetIndex-methods
Querying the active worksheet index
setBorder-methods
Specifying borders for cell styles
with.workbook
Evaluate an R expression in a workbook environment
workbook-class
Class "workbook"
show-methods
Display a workbook object
setColumnWidth-methods
Setting the width of a column in a worksheet
getTables-methods
Querying available Excel tables in a workbook
setCellFormula-methods
Setting cell formulas
setFillBackgroundColor-methods
Specifying the fill background color for cell styles
getReferenceFormula-methods
Querying reference formulas of Excel names
createSheet-methods
Creating worksheets in a workbook
saveWorkbook-methods
Saving Microsoft Excel workbooks
idx2col
Converting column indices to Excel column names
mergeCells-methods
Merging cells
idx2aref
Converting row and column based area references to Excel area references
setRowHeight-methods
Setting the height of a row in a worksheet
setSheetPos-methods
Setting worksheet position
summary-methods
Summarizing workbook objects
existsSheet-methods
Checking for existence of worksheets in a workbook
setMissingValue-methods
Setting missing value identifiers
xlcFreeMemory
Freeing Java Virtual Machine memory
setStyleAction-methods
Controlling application of cell styles when writing data to Excel
isSheetVisible-methods
Checking if worksheets are visible in a workbook
readWorksheetFromFile
Reading data from worksheets in an Excel file (wrapper function)
setStyleNamePrefix-methods
Setting the style name prefix for the "name prefix" style action
createFreezePane-methods
Creating a freeze pane on a worksheet
col2idx
Converting Excel column names to indices
getReferenceCoordinates-methods
Querying the coordinates of the range reference by an Excel name
setDataFormat-methods
Specifying custom data formats for cell styles
writeNamedRegionToFile
Writing named regions to an Excel file (wrapper function)
XLConnect-deprecated
Deprecated functions in package
XLConnect
cellstyle-class
Class "cellstyle"
unhideSheet-methods
Unhiding worksheets in a workbook
getLastColumn-methods
Querying the last (non-empty) column on a worksheet
extractSheetName
Extracting the sheet name from a formula
getCellStyle-methods
Retrieving named cell styles
jTryCatch
Standard Java exception handling for XLConnect
readWorksheet-methods
Reading data from worksheets
setFillPattern-methods
Specifying the fill pattern for cell styles
unmergeCells-methods
Unmerging cells
getReferenceCoordinatesForTable-methods
Querying the coordinates of the range of an Excel table
aref2idx
Converting Excel cell references to row and column based cell references
removeSheet-methods
Removing worksheets from workbooks