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