RDocumentation
Moon
Learn R
Search all packages and functions
⚠️
There's a newer version (1.0.8) of this package.
Take me there.
XLConnect (version 0.1-4)
Excel Connector for R
Description
Manipulate Excel files from R
Copy Link
Copy
Link to current version
Version
Version
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
9,645
Version
0.1-4
License
GPL-3
Maintainer
Mirai GmbH
Last Published
May 26th, 2011
Functions in XLConnect (0.1-4)
Search functions
addImage-methods
Adding images to a worksheet
existsSheet-methods
Checking for existence of worksheets in a workbook
setColumnWidth-methods
Setting the width of a column in a worksheet
idx2cref
Converting indices to Excel cell references
readNamedRegionFromFile
Reading named regions from an Excel file (wrapper function)
XLC
XLConnect Constants
cref2idx
Converting Excel cell references to indices
col2idx
Converting Excel column names to indices
removeSheet-methods
Removing worksheets from workbooks
isSheetVeryHidden-methods
Checking if worksheets are very hidden in a workbook
cellstyle-class
Class "cellstyle"
existsName-methods
Checking existence of names in a workbook
xlcFreeMemory
Freeing Java Virtual Machine memory
unmergeCells-methods
Unmerging cells
runUnitTests
XLConnect Unit Testing Framework
summary-methods
Summarizing workbook objects
writeNamedRegion-methods
Writing named regions to a workbook
onErrorCell-methods
Behavior when error cells are detected
getActiveSheetIndex-methods
Querying the active worksheet index
isSheetVisible-methods
Checking if worksheets are visible in a workbook
unhideSheet-methods
Unhiding worksheets in a workbook
wrapList
Wrapping of arguments in a list
readWorksheet-methods
Reading data from worksheets
getSheets-methods
Querying available worksheets in a workbook
writeWorksheet-methods
Writing data to worksheets
saveWorkbook-methods
Saving Microsoft Excel workbooks
createCellStyle-methods
Creating custom named and anonymous cell styles
setSheetPos-methods
Setting worksheet position
show-methods
Display a workbook object
getCellStyle-methods
Creating custom named and anonymous cell styles
readNamedRegion
Reading named regions from a workbook
setDataFormatForType-methods
Setting the data format for the DATA_FORMAT_ONLY style action
jTryCatch
Standard Java exception handling for XLConnect
getActiveSheetName-methods
Querying the active worksheet name
setWrapText-methods
Specifying text wrapping behaviour
setBorder-methods
Specifying borders for cell styles
print-methods
Print a workbook's filename
setMissingValue-methods
Setting a missing value string
setFillForegroundColor-methods
Specifying the fill foreground color for cell styles
isSheetHidden-methods
Checking if worksheets are hidden in a workbook
removeName-methods
Removing names from workbooks
XLConnect-package
Excel Connector for R
getSheetPos-methods
Querying worksheet position
readWorksheetFromFile
Reading data from worksheets in an Excel file (wrapper function)
setCellStyle-methods
Setting cell styles
setStyleAction-methods
Controlling application of cell styles when writing data to Excel
cloneSheet-methods
Cloning/copying worksheets
createName-methods
Creating names in a workbook
idx2col
Converting column indices to Excel column names
renameSheet-methods
Renaming worksheets from workbooks
xlcMemoryReport
Reporting free Java Virtual Machine memory
hideSheet-methods
Hiding worksheets in a workbook
setFillPattern-methods
Specifying the fill pattern for cell styles
getDefinedNames-methods
Retrieving defined names in a workbook
setStyleNamePrefix-methods
Setting the style name prefix for the "name prefix" style action
setFillBackgroundColor-methods
Specifying the fill background color for cell styles
setDataFormat-methods
Specifying custom data formats for cell styles
loadWorkbook
Loading Microsoft Excel workbooks
createSheet-methods
Creating worksheets in a workbook
getReferenceFormula-methods
Querying reference formulas of Excel names
mergeCells-methods
Merging cells
xlcCall
Automatic argument vectorization, default Java exception and warnings handling for XLConnect
writeWorksheetToFile
Writing data to worksheets in an Excel file (wrapper function)
setActiveSheet-methods
Setting the active worksheet in a workbook
XLConnectSettings
Performing general settings for XLConnect
setRowHeight-methods
Setting the height of a row in a worksheet
writeNamedRegionToFile
Writing named regions to an Excel file (wrapper function)
workbook-class
Class "workbook"
mirai
Mirai Solutions GmbH