Rdocumentation
powered by
Learn R Programming
⚠️
There's a newer version (1.2.0) of this package.
Take me there.
XLConnect (version 0.1-3)
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
4,955
Version
0.1-3
License
GPL-3
Maintainer
Mirai GmbH
Last Published
February 27th, 2011
Functions in XLConnect (0.1-3)
Search all functions
getCellStyle-methods
Creating custom named and anonymous cell styles
createName-methods
Creating names in a workbook
existsName-methods
Checking existence of names in a workbook
isSheetVeryHidden-methods
Checking if worksheets are very hidden in a workbook
xlcFreeMemory
Freeing Java Virtual Machine memory
getActiveSheetIndex-methods
Querying the active worksheet index
XLConnectSettings
Performing general settings for XLConnect
createCellStyle-methods
Creating custom named and anonymous cell styles
unhideSheet-methods
Unhiding worksheets in a workbook
existsSheet-methods
Checking for existence of worksheets in a workbook
setCellStyle-methods
Setting cell styles
XLC
XLConnect Constants
getActiveSheetName-methods
Querying the active worksheet name
writeWorksheet-methods
Writing data to worksheets
jTryCatch
Standard Java exception handling for XLConnect
setFillBackgroundColor-methods
Specifying the fill background color for cell styles
xlcCall
Automatic argument vectorization & default Java exception handling for XLConnect
addImage-methods
Adding images to a worksheet
removeName-methods
Removing names from workbooks
isSheetVisible-methods
Checking if worksheets are visible in a workbook
removeSheet-methods
Removing worksheets from workbooks
getDefinedNames-methods
Retrieving defined names in a workbook
setFillForegroundColor-methods
Specifying the fill foreground color for cell styles
XLConnect-package
Excel Connector for R
readWorksheetFromFile
Reading data from worksheets in an Excel file (wrapper function)
summary-methods
Summarizing workbook objects
readWorksheet-methods
Reading data from worksheets
getReferenceFormula-methods
Querying reference formulas of Excel names
mirai
Mirai Solutions GmbH
isSheetHidden-methods
Checking if worksheets are hidden in a workbook
readNamedRegionFromFile
Reading named regions from an Excel file (wrapper function)
writeWorksheetToFile
Writing data to worksheets in an Excel file (wrapper function)
xlcMemoryReport
Reporting free Java Virtual Machine memory
setStyleAction-methods
Controlling application of cell styles when writing data to Excel
runUnitTests
XLConnect Unit Testing Framework
setActiveSheet-methods
Setting the active worksheet in a workbook
setBorder-methods
Specifying borders for cell styles
setWrapText-methods
Specifying text wrapping behaviour
setFillPattern-methods
Specifying the fill pattern for cell styles
loadWorkbook
Loading Microsoft Excel workbooks
show-methods
Display a workbook object
writeNamedRegion-methods
Writing named regions to a workbook
setRowHeight-methods
Setting the height of a row in a worksheet
saveWorkbook-methods
Saving Microsoft Excel workbooks
getSheets-methods
Querying available worksheets in a workbook
workbook-class
Class "workbook"
setStyleNamePrefix-methods
Setting the style name prefix for the "name prefix" style action
wrapList
Wrapping of arguments in a list
print-methods
Print a workbook's filename
setColumnWidth-methods
Setting the width of a column in a worksheet
createSheet-methods
Creating worksheets in a workbook
cellstyle-class
Class "cellstyle"
hideSheet-methods
Hiding worksheets in a workbook
readNamedRegion
Reading named regions from a workbook
setDataFormat-methods
Specifying custom data formats for cell styles
writeNamedRegionToFile
Writing named regions to an Excel file (wrapper function)