Excel Connector for R

Documentation for package ‘XLConnect’ version 0.1-3

DESCRIPTION file.
Code demos. Use demo() to run them.

Help Pages

A C E G H I L M P R S U W X

-- --

XLConnect-package

Excel Connector for R

-- --

$-method	Class "cellstyle"
$-method	Class "workbook"

-- A --

addImage	Adding images to a worksheet
addImage-method	Adding images to a worksheet
addImage-methods	Adding images to a worksheet

-- C --

cellstyle-class	Class "cellstyle"
createCellStyle	Creating custom named and anonymous cell styles
createCellStyle-method	Creating custom named and anonymous cell styles
createCellStyle-methods	Creating custom named and anonymous cell styles
createName	Creating names in a workbook
createName-method	Creating names in a workbook
createName-methods	Creating names in a workbook
createSheet	Creating worksheets in a workbook
createSheet-method	Creating worksheets in a workbook
createSheet-methods	Creating worksheets in a workbook

-- E --

existsName	Checking existence of names in a workbook
existsName-method	Checking existence of names in a workbook
existsName-methods	Checking existence of names in a workbook
existsSheet	Checking for existence of worksheets in a workbook
existsSheet-method	Checking for existence of worksheets in a workbook
existsSheet-methods	Checking for existence of worksheets in a workbook

-- G --

getActiveSheetIndex	Querying the active worksheet index
getActiveSheetIndex-method	Querying the active worksheet index
getActiveSheetIndex-methods	Querying the active worksheet index
getActiveSheetName	Querying the active worksheet name
getActiveSheetName-method	Querying the active worksheet name
getActiveSheetName-methods	Querying the active worksheet name
getCellStyle	Creating custom named and anonymous cell styles
getCellStyle-method	Creating custom named and anonymous cell styles
getCellStyle-methods	Creating custom named and anonymous cell styles
getDefinedNames	Retrieving defined names in a workbook
getDefinedNames-method	Retrieving defined names in a workbook
getDefinedNames-methods	Retrieving defined names in a workbook
getReferenceFormula	Querying reference formulas of Excel names
getReferenceFormula-method	Querying reference formulas of Excel names
getReferenceFormula-methods	Querying reference formulas of Excel names
getSheets	Querying available worksheets in a workbook
getSheets-method	Querying available worksheets in a workbook
getSheets-methods	Querying available worksheets in a workbook

-- H --

hideSheet	Hiding worksheets in a workbook
hideSheet-method	Hiding worksheets in a workbook
hideSheet-methods	Hiding worksheets in a workbook

-- I --

isSheetHidden	Checking if worksheets are hidden in a workbook
isSheetHidden-method	Checking if worksheets are hidden in a workbook
isSheetHidden-methods	Checking if worksheets are hidden in a workbook
isSheetVeryHidden	Checking if worksheets are very hidden in a workbook
isSheetVeryHidden-method	Checking if worksheets are very hidden in a workbook
isSheetVeryHidden-methods	Checking if worksheets are very hidden in a workbook
isSheetVisible	Checking if worksheets are visible in a workbook
isSheetVisible-method	Checking if worksheets are visible in a workbook
isSheetVisible-methods	Checking if worksheets are visible in a workbook

-- L --

loadWorkbook

Loading Microsoft Excel workbooks

-- M --

mirai

Mirai Solutions GmbH

-- P --

print	Print a workbook's filename
print-method	Print a workbook's filename
print-methods	Print a workbook's filename

-- R --

readNamedRegion	Reading named regions from a workbook
readNamedRegion-method	Reading named regions from a workbook
readNamedRegion-methods	Reading named regions from a workbook
readNamedRegionFromFile	Reading named regions from an Excel file (wrapper function)
readWorksheet	Reading data from worksheets
readWorksheet-method	Reading data from worksheets
readWorksheet-methods	Reading data from worksheets
readWorksheetFromFile	Reading data from worksheets in an Excel file (wrapper function)
removeName	Removing names from workbooks
removeName-method	Removing names from workbooks
removeName-methods	Removing names from workbooks
removeSheet	Removing worksheets from workbooks
removeSheet-method	Removing worksheets from workbooks
removeSheet-methods	Removing worksheets from workbooks
runUnitTests	XLConnect Unit Testing Framework

-- S --

saveWorkbook	Saving Microsoft Excel workbooks
saveWorkbook-method	Saving Microsoft Excel workbooks
saveWorkbook-methods	Saving Microsoft Excel workbooks
setActiveSheet	Setting the active worksheet in a workbook
setActiveSheet-method	Setting the active worksheet in a workbook
setActiveSheet-methods	Setting the active worksheet in a workbook
setBorder	Specifying borders for cell styles
setBorder-method	Specifying borders for cell styles
setBorder-methods	Specifying borders for cell styles
setCellStyle	Setting cell styles
setCellStyle-method	Setting cell styles
setCellStyle-methods	Setting cell styles
setColumnWidth	Setting the width of a column in a worksheet
setColumnWidth-method	Setting the width of a column in a worksheet
setColumnWidth-methods	Setting the width of a column in a worksheet
setDataFormat	Specifying custom data formats for cell styles
setDataFormat-method	Specifying custom data formats for cell styles
setDataFormat-methods	Specifying custom data formats for cell styles
setFillBackgroundColor	Specifying the fill background color for cell styles
setFillBackgroundColor-method	Specifying the fill background color for cell styles
setFillBackgroundColor-methods	Specifying the fill background color for cell styles
setFillForegroundColor	Specifying the fill foreground color for cell styles
setFillForegroundColor-method	Specifying the fill foreground color for cell styles
setFillForegroundColor-methods	Specifying the fill foreground color for cell styles
setFillPattern	Specifying the fill pattern for cell styles
setFillPattern-method	Specifying the fill pattern for cell styles
setFillPattern-methods	Specifying the fill pattern for cell styles
setRowHeight	Setting the height of a row in a worksheet
setRowHeight-method	Setting the height of a row in a worksheet
setRowHeight-methods	Setting the height of a row in a worksheet
setStyleAction	Controlling application of cell styles when writing data to Excel
setStyleAction-method	Controlling application of cell styles when writing data to Excel
setStyleAction-methods	Controlling application of cell styles when writing data to Excel
setStyleNamePrefix	Setting the style name prefix for the "name prefix" style action
setStyleNamePrefix-method	Setting the style name prefix for the "name prefix" style action
setStyleNamePrefix-methods	Setting the style name prefix for the "name prefix" style action
setWrapText	Specifying text wrapping behaviour
setWrapText-method	Specifying text wrapping behaviour
setWrapText-methods	Specifying text wrapping behaviour
show	Display a workbook object
show-method	Display a workbook object
show-methods	Display a workbook object
summary	Summarizing workbook objects
summary-method	Summarizing workbook objects
summary-methods	Summarizing workbook objects

-- U --

unhideSheet	Unhiding worksheets in a workbook
unhideSheet-method	Unhiding worksheets in a workbook
unhideSheet-methods	Unhiding worksheets in a workbook

-- W --

workbook-class	Class "workbook"
writeNamedRegion	Writing named regions to a workbook
writeNamedRegion-method	Writing named regions to a workbook
writeNamedRegion-methods	Writing named regions to a workbook
writeNamedRegionToFile	Writing named regions to an Excel file (wrapper function)
writeWorksheet	Writing data to worksheets
writeWorksheet-method	Writing data to worksheets
writeWorksheet-methods	Writing data to worksheets
writeWorksheetToFile	Writing data to worksheets in an Excel file (wrapper function)

-- X --

XLC	XLConnect Constants
xlcFreeMemory	Freeing Java Virtual Machine memory
xlcMemoryReport	Reporting free Java Virtual Machine memory
XLConnect	Excel Connector for R