XLConnect: Excel Connector for R

Provides comprehensive functionality to read, write and format Excel data.

AuthorMirai Solutions GmbH [aut], Martin Studer [cre], The Apache Software Foundation [ctb, cph] (Apache POI, Apache Commons Codec), Stephen Colebourne [ctb, cph] (Joda-Time Java library), Graph Builder [ctb, cph] (Curvesapi Java library)
Date of publication2016-06-24 09:53:27
MaintainerMartin Studer <martin.studer@mirai-solutions.com>
LicenseGPL-3
Version0.2-12
http://www.mirai-solutions.com , http://miraisolutions.wordpress.com

View on CRAN

Man pages

addImage-methods: Adding images to a worksheet

appendNamedRegion-methods: Appending data to a named region

appendWorksheet-methods: Appending data to worksheets

aref: Constructing Excel area references

aref2idx: Converting Excel cell references to row and column based cell...

cellstyle-class: Class "cellstyle"

clearNamedRegion-methods: Clearing named regions in a workbook

clearRangeFromReference-methods: Clearing cell ranges in a workbook

clearRange-methods: Clearing cell ranges in a workbook

clearSheet-methods: Clearing worksheets in a workbook

cloneSheet-methods: Cloning/copying worksheets

col2idx: Converting Excel column names to indices

createCellStyle-methods: Creating custom named and anonymous cell styles

createFreezePane-methods: Creating a freeze pane on a worksheet

createName-methods: Creating names in a workbook

createSheet-methods: Creating worksheets in a workbook

createSplitPane-methods: Creating a split pane on a worksheet

cref2idx: Converting Excel cell references to indices

dollar-methods: Executing workbook methods in object$method(...) form

existsName-methods: Checking existence of names in a workbook

existsSheet-methods: Checking for existence of worksheets in a workbook

extraction-methods: Workbook data extraction & replacement operators

extractSheetName: Extracting the sheet name from a formula

getActiveSheetIndex-methods: Querying the active worksheet index

getActiveSheetName-methods: Querying the active worksheet name

getBoundingBox-methods: Querying the coordinates of a worksheet bounding box

getCellFormula-methods: Retrieving formula definitions from cells

getCellStyleForType-methods: Querying the cell style per data type for the DATATYPE style...

getCellStyle-methods: Retrieving named cell styles

getDefinedNames-methods: Retrieving defined names in a workbook

getForceFormulaRecalculation-methods: Querying the coordinates of the range reference by an Excel...

getLastColumn-methods: Querying the last (non-empty) column on a worksheet

getLastRow-methods: Querying the last (non-empty) row on a worksheet

getReferenceCoordinatesForName-methods: Querying the coordinates of the range reference by an Excel...

getReferenceCoordinatesForTable-methods: Querying the coordinates of the range of an Excel table

getReferenceCoordinates-methods: Querying the coordinates of the range reference by an Excel...

getReferenceFormula-methods: Querying reference formulas of Excel names

getSheetPos-methods: Querying worksheet position

getSheets-methods: Querying available worksheets in a workbook

getTables-methods: Querying available Excel tables in a workbook

hideSheet-methods: Hiding worksheets in a workbook

idx2aref: Converting row and column based area references to Excel area...

idx2col: Converting column indices to Excel column names

idx2cref: Converting indices to Excel cell references

isSheetHidden-methods: Checking if worksheets are hidden in a workbook

isSheetVeryHidden-methods: Checking if worksheets are very hidden in a workbook

isSheetVisible-methods: Checking if worksheets are visible in a workbook

jTryCatch: Standard Java exception handling for XLConnect

loadWorkbook: Loading Microsoft Excel workbooks

mergeCells-methods: Merging cells

mirai: Mirai Solutions GmbH

normalizeDataframe: Data frame Normalization for Unit Tests

onErrorCell-methods: Behavior when error cells are detected

print-methods: Print a workbook's filename

readNamedRegionFromFile: Reading named regions from an Excel file (wrapper function)

readNamedRegion-methods: Reading named regions from a workbook

readTable-methods: Reading Excel tables from a workbook

readWorksheetFromFile: Reading data from worksheets in an Excel file (wrapper...

readWorksheet-methods: Reading data from worksheets

removeName-methods: Removing names from workbooks

removePane-methods: Removing panes from worksheet

removeSheet-methods: Removing worksheets from workbooks

renameSheet-methods: Renaming worksheets from workbooks

saveWorkbook-methods: Saving Microsoft Excel workbooks

setActiveSheet-methods: Setting the active worksheet in a workbook

setAutoFilter-methods: Setting auto-filters on worksheets

setBorder-methods: Specifying borders for cell styles

setCellFormula-methods: Setting cell formulas

setCellStyleForType-methods: Setting the cell style per data type for the DATATYPE style...

setCellStyle-methods: Setting cell styles

setColumnWidth-methods: Setting the width of a column in a worksheet

setDataFormatForType-methods: Setting the data format for the DATA_FORMAT_ONLY style action

setDataFormat-methods: Specifying custom data formats for cell styles

setFillBackgroundColor-methods: Specifying the fill background color for cell styles

setFillForegroundColor-methods: Specifying the fill foreground color for cell styles

setFillPattern-methods: Specifying the fill pattern for cell styles

setForceFormulaRecalculation-methods: Forcing Excel to recalculate formula values when opening a...

setMissingValue-methods: Setting missing value identifiers

setRowHeight-methods: Setting the height of a row in a worksheet

setSheetColor-methods: Setting colors on worksheet tabs

setSheetPos-methods: Setting worksheet position

setStyleAction-methods: Controlling application of cell styles when writing data to...

setStyleNamePrefix-methods: Setting the style name prefix for the "name prefix" style...

setWrapText-methods: Specifying text wrapping behaviour

show-methods: Display a workbook object

summary-methods: Summarizing workbook objects

swissfranc: Historical Exchange Rates: CHF vs EUR, USD and GBP

unhideSheet-methods: Unhiding worksheets in a workbook

unmergeCells-methods: Unmerging cells

with.workbook: Evaluate an R expression in a workbook environment

workbook-class: Class "workbook"

wrapList: Wrapping of arguments in a list

writeNamedRegion-methods: Writing named regions to a workbook

writeNamedRegionToFile: Writing named regions to an Excel file (wrapper function)

writeWorksheet-methods: Writing data to worksheets

writeWorksheetToFile: Writing data to worksheets in an Excel file (wrapper...

XLC: XLConnect Constants

xlcCall: Automatic argument vectorization, default Java exception and...

xlcDump: Dumping data sets to Excel files

xlcEdit: Editing data sets in an Excel file editor

xlcFreeMemory: Freeing Java Virtual Machine memory

xlcMemoryReport: Reporting free Java Virtual Machine memory

XLConnect-deprecated: Deprecated functions in package 'XLConnect'

XLConnect-package: Excel Connector for R

XLConnectSettings: Performing general settings for XLConnect

xlcRestore: Restoring objects from Excel files

Functions

[ Man page
[<- Man page
[[ Man page
[[<- Man page
$ Man page
addImage Man page
addImage-methods Man page
addImage,workbook-method Man page
appendNamedRegion Man page
appendNamedRegion-methods Man page
appendNamedRegion,workbook,ANY-method Man page
appendNamedRegion,workbook-method Man page
appendWorksheet Man page
appendWorksheet-methods Man page
appendWorksheet,workbook,ANY,character-method Man page
appendWorksheet,workbook,ANY,numeric-method Man page
aref Man page
aref2idx Man page
cellstyle-class Man page
$,cellstyle-method Man page
clearNamedRegion Man page
clearNamedRegion-methods Man page
clearNamedRegion,workbook,character-method Man page
clearRange Man page
clearRangeFromReference Man page
clearRangeFromReference-methods Man page
clearRangeFromReference,workbook,character-method Man page
clearRange-methods Man page
clearRange,workbook,character-method Man page
clearRange,workbook,numeric-method Man page
clearSheet Man page
clearSheet-methods Man page
clearSheet,workbook,character-method Man page
clearSheet,workbook,numeric-method Man page
cloneSheet Man page
cloneSheet-methods Man page
cloneSheet,workbook,character-method Man page
cloneSheet,workbook,numeric-method Man page
col2idx Man page
createCellStyle Man page
createCellStyle-methods Man page
createCellStyle,workbook,character-method Man page
createCellStyle,workbook,missing-method Man page
createFreezePane Man page
createFreezePane-methods Man page
createFreezePane,workbook,character-method Man page
createFreezePane,workbook,numeric-method Man page
createName Man page
createName-methods Man page
createName,workbook-method Man page
createSheet Man page
createSheet-methods Man page
createSheet,workbook-method Man page
createSplitPane Man page
createSplitPane-methods Man page
createSplitPane,workbook,character-method Man page
createSplitPane,workbook,numeric-method Man page
cref2idx Man page
existsName Man page
existsName-methods Man page
existsName,workbook-method Man page
existsSheet Man page
existsSheet-methods Man page
existsSheet,workbook-method Man page
extractSheetName Man page
getActiveSheetIndex Man page
getActiveSheetIndex-methods Man page
getActiveSheetIndex,workbook-method Man page
getActiveSheetName Man page
getActiveSheetName-methods Man page
getActiveSheetName,workbook-method Man page
getBoundingBox Man page
getBoundingBox-methods Man page
getBoundingBox,workbook,character-method Man page
getBoundingBox,workbook,numeric-method Man page
getCellFormula Man page
getCellFormula-methods Man page
getCellFormula,workbook,character-method Man page
getCellFormula,workbook,numeric-method Man page
getCellStyle Man page
getCellStyleForType Man page
getCellStyleForType-methods Man page
getCellStyleForType,workbook-method Man page
getCellStyle-methods Man page
getCellStyle,workbook-method Man page
getDefinedNames Man page
getDefinedNames-methods Man page
getDefinedNames,workbook-method Man page
getForceFormulaRecalculation Man page
getForceFormulaRecalculation-methods Man page
getForceFormulaRecalculation,workbook,character-method Man page
getForceFormulaRecalculation,workbook,numeric-method Man page
getLastColumn Man page
getLastColumn-methods Man page
getLastColumn,workbook,character-method Man page
getLastColumn,workbook,numeric-method Man page
getLastRow Man page
getLastRow-methods Man page
getLastRow,workbook,character-method Man page
getLastRow,workbook,numeric-method Man page
getReferenceCoordinates Man page
getReferenceCoordinatesForName Man page
getReferenceCoordinatesForName-methods Man page
getReferenceCoordinatesForName,workbook-method Man page
getReferenceCoordinatesForTable Man page
getReferenceCoordinatesForTable-methods Man page
getReferenceCoordinatesForTable,workbook,character-method Man page
getReferenceCoordinatesForTable,workbook,numeric-method Man page
getReferenceCoordinates-methods Man page
getReferenceCoordinates,workbook-method Man page
getReferenceFormula Man page
getReferenceFormula-methods Man page
getReferenceFormula,workbook-method Man page
getSheetPos Man page
getSheetPos-methods Man page
getSheetPos,workbook,character-method Man page
getSheets Man page
getSheets-methods Man page
getSheets,workbook-method Man page
getTables Man page
getTables-methods Man page
getTables,workbook,character-method Man page
getTables,workbook,numeric-method Man page
hideSheet Man page
hideSheet-methods Man page
hideSheet,workbook,character-method Man page
hideSheet,workbook,numeric-method Man page
idx2aref Man page
idx2col Man page
idx2cref Man page
isSheetHidden Man page
isSheetHidden-methods Man page
isSheetHidden,workbook,character-method Man page
isSheetHidden,workbook,numeric-method Man page
isSheetVeryHidden Man page
isSheetVeryHidden-methods Man page
isSheetVeryHidden,workbook,character-method Man page
isSheetVeryHidden,workbook,numeric-method Man page
isSheetVisible Man page
isSheetVisible-methods Man page
isSheetVisible,workbook,character-method Man page
isSheetVisible,workbook,numeric-method Man page
jTryCatch Man page
loadWorkbook Man page
mergeCells Man page
mergeCells-methods Man page
mergeCells,workbook,character-method Man page
mergeCells,workbook,numeric-method Man page
[<--methods Man page
[-methods Man page
[[<--methods Man page
[[-methods Man page
$-methods Man page
mirai Man page
normalizeDataframe Man page
onErrorCell Man page
onErrorCell-methods Man page
onErrorCell,workbook-method Man page
print Man page
print-methods Man page
print,workbook-method Man page
readNamedRegion Man page
readNamedRegionFromFile Man page
readNamedRegion-methods Man page
readNamedRegion,workbook-method Man page
readTable Man page
readTable-methods Man page
readTable,workbook,character-method Man page
readTable,workbook,numeric-method Man page
readWorksheet Man page
readWorksheetFromFile Man page
readWorksheet-methods Man page
readWorksheet,workbook,character-method Man page
readWorksheet,workbook,numeric-method Man page
removeName Man page
removeName-methods Man page
removeName,workbook-method Man page
removePane Man page
removePane-methods Man page
removePane,workbook,character-method Man page
removePane,workbook,numeric-method Man page
removeSheet Man page
removeSheet-methods Man page
removeSheet,workbook,character-method Man page
removeSheet,workbook,numeric-method Man page
renameSheet Man page
renameSheet-methods Man page
renameSheet,workbook,character-method Man page
renameSheet,workbook,numeric-method Man page
saveWorkbook Man page
saveWorkbook-methods Man page
saveWorkbook,workbook,character-method Man page
saveWorkbook,workbook,missing-method Man page
setActiveSheet Man page
setActiveSheet-methods Man page
setActiveSheet,workbook,character-method Man page
setActiveSheet,workbook,numeric-method Man page
setAutoFilter Man page
setAutoFilter-methods Man page
setAutoFilter,workbook,character-method Man page
setAutoFilter,workbook,numeric-method Man page
setBorder Man page
setBorder,cellstyle-method Man page
setBorder-methods Man page
setCellFormula Man page
setCellFormula-methods Man page
setCellFormula,workbook,character-method Man page
setCellFormula,workbook,numeric-method Man page
setCellStyle Man page
setCellStyleForType Man page
setCellStyleForType-methods Man page
setCellStyleForType,workbook-method Man page
setCellStyle-methods Man page
setCellStyle,workbook,character,missing-method Man page
setCellStyle,workbook,missing,character-method Man page
setCellStyle,workbook,missing,numeric-method Man page
setColumnWidth Man page
setColumnWidth-methods Man page
setColumnWidth,workbook,character-method Man page
setColumnWidth,workbook,numeric-method Man page
setDataFormat Man page
setDataFormat,cellstyle-method Man page
setDataFormatForType Man page
setDataFormatForType-methods Man page
setDataFormatForType,workbook-method Man page
setDataFormat-methods Man page
setFillBackgroundColor Man page
setFillBackgroundColor,cellstyle,numeric-method Man page
setFillBackgroundColor-methods Man page
setFillForegroundColor Man page
setFillForegroundColor,cellstyle,numeric-method Man page
setFillForegroundColor-methods Man page
setFillPattern Man page
setFillPattern,cellstyle-method Man page
setFillPattern-methods Man page
setForceFormulaRecalculation Man page
setForceFormulaRecalculation-methods Man page
setForceFormulaRecalculation,workbook,character-method Man page
setForceFormulaRecalculation,workbook,numeric-method Man page
setMissingValue Man page
setMissingValue-methods Man page
setMissingValue,workbook,ANY-method Man page
setMissingValue,workbook-method Man page
setRowHeight Man page
setRowHeight-methods Man page
setRowHeight,workbook,character-method Man page
setRowHeight,workbook,numeric-method Man page
setSheetColor Man page
setSheetColor-methods Man page
setSheetColor,workbook,character-method Man page
setSheetColor,workbook,numeric-method Man page
setSheetPos Man page
setSheetPos-methods Man page
setSheetPos,workbook,character,missing-method Man page
setSheetPos,workbook,character,numeric-method Man page
setStyleAction Man page
setStyleAction-methods Man page
setStyleAction,workbook-method Man page
setStyleNamePrefix Man page
setStyleNamePrefix-methods Man page
setStyleNamePrefix,workbook-method Man page
setWrapText Man page
setWrapText,cellstyle-method Man page
setWrapText-methods Man page
show Man page
show-methods Man page
show,workbook-method Man page
summary Man page
summary-methods Man page
summary,workbook-method Man page
swissfranc Man page
unhideSheet Man page
unhideSheet-methods Man page
unhideSheet,workbook,character-method Man page
unhideSheet,workbook,numeric-method Man page
unmergeCells Man page
unmergeCells-methods Man page
unmergeCells,workbook,character-method Man page
unmergeCells,workbook,numeric-method Man page
with.workbook Man page
workbook-class Man page
[<-,workbook-method Man page
[,workbook-method Man page
[[<-,workbook-method Man page
[[,workbook-method Man page
$,workbook-method Man page
wrapList Man page
writeNamedRegion Man page
writeNamedRegion-methods Man page
writeNamedRegionToFile Man page
writeNamedRegion,workbook,ANY-method Man page
writeNamedRegion,workbook-method Man page
writeWorksheet Man page
writeWorksheet-methods Man page
writeWorksheetToFile Man page
writeWorksheet,workbook,ANY,character-method Man page
writeWorksheet,workbook,ANY,numeric-method Man page
XLC Man page
xlcCall Man page
xlcDump Man page
xlcEdit Man page
xlcFreeMemory Man page
xlcMemoryReport Man page
XLConnect Man page
XLConnect-deprecated Man page
XLConnect-package Man page
XLConnectSettings Man page
xlcRestore Man page

Files

XLConnect
XLConnect/inst
XLConnect/inst/XLConnect.R
XLConnect/inst/java
XLConnect/inst/java/poi-ooxml-3.15-beta1.jar
XLConnect/inst/java/commons-codec-1.10.jar
XLConnect/inst/java/XLConnect-0.2-12.jar
XLConnect/inst/java/curvesapi-1.03.jar
XLConnect/inst/java/joda-time-2.3.jar
XLConnect/inst/java/poi-3.15-beta1.jar
XLConnect/inst/COPYRIGHTS
XLConnect/inst/demoFiles
XLConnect/inst/demoFiles/template2.xlsx
XLConnect/inst/demoFiles/SwitzerlandFlag.jpg
XLConnect/inst/demoFiles/errorCell.xlsx
XLConnect/inst/demoFiles/mtcars.xlsx
XLConnect/inst/demoFiles/multiregion.xls
XLConnect/inst/demoFiles/conversion.xlsx
XLConnect/inst/demoFiles/template.xlsx
XLConnect/inst/demoFiles/multiregion.xlsx
XLConnect/inst/demoFiles/mydata.xlsx
XLConnect/inst/doc
XLConnect/inst/doc/XLConnect.R
XLConnect/inst/doc/XLConnect.pdf
XLConnect/inst/doc/XLConnectImpatient.R
XLConnect/inst/doc/XLConnectImpatient.pdf
XLConnect/inst/doc/XLConnect.Rnw
XLConnect/inst/doc/XLConnectImpatient.Rnw
XLConnect/inst/unitTests
XLConnect/inst/unitTests/runit.workbook.getReferenceCoordinatesForTable.R
XLConnect/inst/unitTests/runit.workbook.hideSheet.R
XLConnect/inst/unitTests/runit.workbook.existsName.R
XLConnect/inst/unitTests/runit.workbook.readWorksheet.R
XLConnect/inst/unitTests/runit.workbook.getSheetPos.R
XLConnect/inst/unitTests/runit.workbook.getTables.R
XLConnect/inst/unitTests/runit.workbook.clearNamedRegion.R
XLConnect/inst/unitTests/runit.writeWorksheetToFile.R
XLConnect/inst/unitTests/runit.workbook.appendWorksheet.R
XLConnect/inst/unitTests/runit.dataframeConversion.R
XLConnect/inst/unitTests/runit.loadWorkbook.R
XLConnect/inst/unitTests/runit.workbook.getDefinedNames.R
XLConnect/inst/unitTests/runit.workbook.clearSheet.R
XLConnect/inst/unitTests/runit.arefidx.R
XLConnect/inst/unitTests/runit.workbook.writeNamedRegion.R
XLConnect/inst/unitTests/runit.writeAndReadNamedRegion.R
XLConnect/inst/unitTests/runit.workbook.getActiveSheetName.R
XLConnect/inst/unitTests/runit.workbook.existsSheet.R
XLConnect/inst/unitTests/runit.workbook.isSheetVeryHidden.R
XLConnect/inst/unitTests/runit.colidx.R
XLConnect/inst/unitTests/runit.workbook.setSheetPos.R
XLConnect/inst/unitTests/runit.workbook.getReferenceCoordinates.R
XLConnect/inst/unitTests/runit.workbook.removeName.R
XLConnect/inst/unitTests/runit.workbook.setActiveSheet.R
XLConnect/inst/unitTests/runit.workbook.setMissingValue.R
XLConnect/inst/unitTests/runit.extractSheetName.R
XLConnect/inst/unitTests/runit.writeNamedRegionToFile.R
XLConnect/inst/unitTests/runit.workbook.readNamedRegion.R
XLConnect/inst/unitTests/runit.dumpAndRestore.R
XLConnect/inst/unitTests/runit.workbook.isSheetVisible.R
XLConnect/inst/unitTests/runit.workbook.cloneSheet.R
XLConnect/inst/unitTests/resources
XLConnect/inst/unitTests/resources/testWorkbookExistsNameAndSheet.xls
XLConnect/inst/unitTests/resources/testWorkbookCloneSheet.xlsx
XLConnect/inst/unitTests/resources/testWorkbookReadTable.xlsx
XLConnect/inst/unitTests/resources/testWorkbookRemoveName.xlsx
XLConnect/inst/unitTests/resources/testWorkbookCloneSheet.xls
XLConnect/inst/unitTests/resources/testWorkbookMissingValue.xlsx
XLConnect/inst/unitTests/resources/testWorkbookDefinedNames.xlsx
XLConnect/inst/unitTests/resources/testWithWorkbook.xls
XLConnect/inst/unitTests/resources/testWorkbookErrorCell.xlsx
XLConnect/inst/unitTests/resources/testWithWorkbook.xlsx
XLConnect/inst/unitTests/resources/testWorkbookRemoveSheet.xlsx
XLConnect/inst/unitTests/resources/testBug49.xlsx
XLConnect/inst/unitTests/resources/testWorkbookGetLastRow.xlsx
XLConnect/inst/unitTests/resources/testLoadWorkbook.xls
XLConnect/inst/unitTests/resources/testWorkbookActiveSheetIndexAndName.xlsx
XLConnect/inst/unitTests/resources/testWorkbookForceRecalc.xls
XLConnect/inst/unitTests/resources/testCachedValues.xls
XLConnect/inst/unitTests/resources/testWorkbookSheets.xls
XLConnect/inst/unitTests/resources/testWorkbookDefinedNames.xls
XLConnect/inst/unitTests/resources/testWorkbookAppend.xlsx
XLConnect/inst/unitTests/resources/testWorkbookHiddenSheets.xls
XLConnect/inst/unitTests/resources/testWorkbookRemoveName.xls
XLConnect/inst/unitTests/resources/testWorkbookReadNamedRegion.xls
XLConnect/inst/unitTests/resources/testWorkbookReferenceFormula.xlsx
XLConnect/inst/unitTests/resources/testWorkbookHiddenSheets.xlsx
XLConnect/inst/unitTests/resources/testWorkbookGetLastRow.xls
XLConnect/inst/unitTests/resources/testWorkbookSetActiveSheet.xlsx
XLConnect/inst/unitTests/resources/testWorkbookReadWorksheet.xls
XLConnect/inst/unitTests/resources/testWorkbookForceRecalc.xlsx
XLConnect/inst/unitTests/resources/testWorkbookClearCells.xls
XLConnect/inst/unitTests/resources/testWorkbookClearCells.xlsx
XLConnect/inst/unitTests/resources/testWorkbookReadNamedRegion.xlsx
XLConnect/inst/unitTests/resources/testWorkbookReferenceFormula.xls
XLConnect/inst/unitTests/resources/testWorkbookAppend.xls
XLConnect/inst/unitTests/resources/testWorkbookSetActiveSheet.xls
XLConnect/inst/unitTests/resources/testWorkbookExistsNameAndSheet.xlsx
XLConnect/inst/unitTests/resources/testWorkbookMissingValue.xls
XLConnect/inst/unitTests/resources/testLoadWorkbook.xlsx
XLConnect/inst/unitTests/resources/testWorkbookErrorCell.xls
XLConnect/inst/unitTests/resources/testCachedValues.xlsx
XLConnect/inst/unitTests/resources/testBug52.xlsx
XLConnect/inst/unitTests/resources/testWorkbookRemoveSheet.xls
XLConnect/inst/unitTests/resources/testWorkbookCellFormula.xlsx
XLConnect/inst/unitTests/resources/testWorkbookReadWorksheet.xlsx
XLConnect/inst/unitTests/resources/testWorkbookCellFormula.xls
XLConnect/inst/unitTests/resources/testWorkbookActiveSheetIndexAndName.xls
XLConnect/inst/unitTests/resources/testBug53.xlsx
XLConnect/inst/unitTests/resources/testWorkbookSheets.xlsx
XLConnect/inst/unitTests/runit.workbook.onErrorCell.R
XLConnect/inst/unitTests/runit.workbook.createName.R
XLConnect/inst/unitTests/runit.workbook.getLastRow.R
XLConnect/inst/unitTests/runit.workbook.readTable.R
XLConnect/inst/unitTests/runit.writeAndReadWorksheet.R
XLConnect/inst/unitTests/runit.workbook.renameSheet.R
XLConnect/inst/unitTests/runit.cellStyle.R
XLConnect/inst/unitTests/runit.workbook.createSheet.R
XLConnect/inst/unitTests/runit.workbook.writeWorksheet.R
XLConnect/inst/unitTests/runit.workbook.getSheets.R
XLConnect/inst/unitTests/runit.workbook.removeSheet.R
XLConnect/inst/unitTests/runit.crefidx.R
XLConnect/inst/unitTests/runit.workbook.isSheetHidden.R
XLConnect/inst/unitTests/runit.workbook.getLastColumn.R
XLConnect/inst/unitTests/runit.workbook.appendNamedRegion.R
XLConnect/inst/unitTests/runit.workbook.unhideSheet.R
XLConnect/inst/unitTests/runit.workbook.saveWorkbook.R
XLConnect/inst/unitTests/runit.workbook.extraction.R
XLConnect/inst/unitTests/runit.workbook.clearRange.R
XLConnect/inst/unitTests/runit.workbook.clearRangeFromReference.R
XLConnect/inst/unitTests/runit.workbook.getActiveSheetIndex.R
XLConnect/inst/unitTests/runit.workbook.getReferenceFormula.R
XLConnect/inst/unitTests/runit.workbook.getBoundingBox.R
XLConnect/inst/unitTests/runit.with.workbook.R
XLConnect/tests
XLConnect/tests/run_tests.R
XLConnect/NAMESPACE
XLConnect/demo
XLConnect/demo/hideSheets.R
XLConnect/demo/cellstyles2.R
XLConnect/demo/cellstyles3.R
XLConnect/demo/readWorksheet.R
XLConnect/demo/writeNamedRegion.R
XLConnect/demo/cellstyles1.R
XLConnect/demo/cellsize.R
XLConnect/demo/writeWorksheet.R
XLConnect/demo/withWorkbook.R
XLConnect/demo/00Index
XLConnect/demo/addImage.R
XLConnect/demo/readNamedRegion.R
XLConnect/demo/summary.R
XLConnect/demo/dataformat.R
XLConnect/demo/writeLargeData.R
XLConnect/NEWS
XLConnect/data
XLConnect/data/swissfranc.rda
XLConnect/R
XLConnect/R/workbook.getCellStyle.R XLConnect/R/workbook.readNamedRegion.R XLConnect/R/classToXlcType.R XLConnect/R/workbook.getReferenceCoordinatesForTable.R XLConnect/R/mirai.R XLConnect/R/jTryCatch.R XLConnect/R/workbook.getTables.R XLConnect/R/workbook.operators.R XLConnect/R/idx2cref.R XLConnect/R/workbook.setCellStyle.R XLConnect/R/workbook.getActiveSheetIndex.R XLConnect/R/normalizeDataframe.R XLConnect/R/workbook.clearRange.R XLConnect/R/workbook.hideSheet.R XLConnect/R/workbook.isSheetVeryHidden.R XLConnect/R/workbook.writeWorksheet.R XLConnect/R/workbook.createName.R XLConnect/R/writeNamedRegionToFile.R XLConnect/R/workbook.writeNamedRegion.R XLConnect/R/wrapList.R XLConnect/R/xlcEdit.R XLConnect/R/onLoad.R XLConnect/R/onAttach.R XLConnect/R/workbook.getSheets.R XLConnect/R/aref.R XLConnect/R/workbook.show.R XLConnect/R/workbook.setCellFormula.R XLConnect/R/aref2idx.R XLConnect/R/cellstyle.R XLConnect/R/workbook.setStyleNamePrefix.R XLConnect/R/includeRownames.R XLConnect/R/cellstyle.setDataFormat.R XLConnect/R/workbook.appendWorksheet.R XLConnect/R/workbook.getReferenceCoordinates.R XLConnect/R/XLConnectSettings.R XLConnect/R/workbook.setSheetPos.R XLConnect/R/workbook.saveWorkbook.R XLConnect/R/workbook.createFreezePane.R XLConnect/R/workbook.unmergeCells.R XLConnect/R/xlcCall.R XLConnect/R/workbook.appendNamedRegion.R XLConnect/R/workbook.existsName.R XLConnect/R/xlcDump.R XLConnect/R/idx2col.R XLConnect/R/workbook.setActiveSheet.R XLConnect/R/workbook.getSheetPos.R XLConnect/R/workbook.isSheetVisible.R XLConnect/R/workbook.createSplitPane.R XLConnect/R/workbook.getReferenceCoordinatesForName.R XLConnect/R/cellstyle.setFillPattern.R XLConnect/R/workbook.setRowHeight.R XLConnect/R/workbook.setStyleAction.R XLConnect/R/workbook.removeSheet.R XLConnect/R/workbook.setCellStyleForType.R XLConnect/R/workbook.setSheetColor.R XLConnect/R/loadWorkbook.R XLConnect/R/cref2idx.R XLConnect/R/extractSheetName.R XLConnect/R/readNamedRegionFromFile.R XLConnect/R/extractRownames.R XLConnect/R/workbook.getForceFormulaRecalculation.R XLConnect/R/cellstyle.setWrapText.R XLConnect/R/workbook.print.R XLConnect/R/workbook.getReferenceFormula.R XLConnect/R/workbook.removeName.R XLConnect/R/workbook.createCellStyle.R XLConnect/R/writeWorksheetToFile.R XLConnect/R/workbook.getActiveSheetName.R XLConnect/R/col2idx.R XLConnect/R/cellstyle.operators.R XLConnect/R/workbook.readTable.R XLConnect/R/workbook.getBoundingBox.R XLConnect/R/cellstyle.setFillForegroundColor.R XLConnect/R/workbook.getDefinedNames.R XLConnect/R/workbook.clearSheet.R XLConnect/R/xlcFreeMemory.R XLConnect/R/readWorksheetFromFile.R XLConnect/R/workbook.summary.R XLConnect/R/workbook.isSheetHidden.R XLConnect/R/workbook.setMissingValue.R XLConnect/R/workbook.getLastRow.R XLConnect/R/workbook.unhideSheet.R XLConnect/R/dataframeFromJava.R XLConnect/R/getColSubset.R XLConnect/R/workbook.existsSheet.R XLConnect/R/workbook.setDataFormatForType.R XLConnect/R/workbook.getLastColumn.R XLConnect/R/workbook.clearRangeFromReference.R XLConnect/R/workbook.setAutoFilter.R XLConnect/R/constants.R XLConnect/R/workbook.getCellFormula.R XLConnect/R/cellstyle.setFillBackgroundColor.R XLConnect/R/cellstyle.setBorder.R XLConnect/R/workbook.mergeCells.R XLConnect/R/workbook.readWorksheet.R XLConnect/R/with.workbook.R XLConnect/R/workbook.createSheet.R XLConnect/R/workbook.onErrorCell.R XLConnect/R/workbook.renameSheet.R XLConnect/R/xlcMemoryReport.R XLConnect/R/workbook.setForceFormulaRecalculation.R XLConnect/R/workbook.cloneSheet.R XLConnect/R/workbook.R XLConnect/R/rg2idx.R XLConnect/R/idx2aref.R XLConnect/R/workbook.getCellStyleForType.R XLConnect/R/workbook.addImage.R XLConnect/R/xlcRestore.R XLConnect/R/dataframeToJava.R XLConnect/R/workbook.removePane.R XLConnect/R/workbook.setColumnWidth.R XLConnect/R/workbook.clearNamedRegion.R
XLConnect/vignettes
XLConnect/vignettes/tikzCodeBlock.sty
XLConnect/vignettes/img
XLConnect/vignettes/img/XLConnectExample1.png
XLConnect/vignettes/img/TwitterLogo.png
XLConnect/vignettes/img/LinkedIn-Icon.png
XLConnect/vignettes/img/Excel.png
XLConnect/vignettes/img/BrownBug.png
XLConnect/vignettes/img/XLConnectExample2.png
XLConnect/vignettes/img/XLConnectExample3.png
XLConnect/vignettes/img/RunConfigurations.png
XLConnect/vignettes/img/Feedback.png
XLConnect/vignettes/img/Rlogo.png
XLConnect/vignettes/img/mtcars.png
XLConnect/vignettes/tikzDeviceMacros.tex
XLConnect/vignettes/XLConnect.Rnw
XLConnect/vignettes/XLConnectImpatient.Rnw
XLConnect/README.md
XLConnect/MD5
XLConnect/java
XLConnect/java/README
XLConnect/build
XLConnect/build/vignette.rds
XLConnect/DESCRIPTION
XLConnect/man
XLConnect/man/mergeCells-methods.Rd XLConnect/man/summary-methods.Rd XLConnect/man/clearNamedRegion-methods.Rd XLConnect/man/XLC.Rd XLConnect/man/getSheets-methods.Rd XLConnect/man/extractSheetName.Rd XLConnect/man/getLastRow-methods.Rd XLConnect/man/xlcCall.Rd XLConnect/man/setStyleNamePrefix-methods.Rd XLConnect/man/getReferenceCoordinatesForTable-methods.Rd XLConnect/man/appendWorksheet-methods.Rd XLConnect/man/clearRange-methods.Rd XLConnect/man/setCellStyleForType-methods.Rd XLConnect/man/aref.Rd XLConnect/man/getReferenceFormula-methods.Rd XLConnect/man/createSheet-methods.Rd XLConnect/man/writeNamedRegionToFile.Rd XLConnect/man/getCellStyleForType-methods.Rd XLConnect/man/XLConnectSettings.Rd XLConnect/man/isSheetHidden-methods.Rd XLConnect/man/createName-methods.Rd XLConnect/man/createFreezePane-methods.Rd XLConnect/man/setRowHeight-methods.Rd XLConnect/man/existsSheet-methods.Rd XLConnect/man/clearSheet-methods.Rd XLConnect/man/readWorksheetFromFile.Rd XLConnect/man/unmergeCells-methods.Rd XLConnect/man/getCellStyle-methods.Rd XLConnect/man/setMissingValue-methods.Rd XLConnect/man/removeName-methods.Rd XLConnect/man/setActiveSheet-methods.Rd XLConnect/man/cellstyle-class.Rd XLConnect/man/setFillBackgroundColor-methods.Rd XLConnect/man/wrapList.Rd XLConnect/man/setStyleAction-methods.Rd XLConnect/man/writeWorksheet-methods.Rd XLConnect/man/setCellStyle-methods.Rd XLConnect/man/isSheetVisible-methods.Rd XLConnect/man/getLastColumn-methods.Rd XLConnect/man/addImage-methods.Rd XLConnect/man/setColumnWidth-methods.Rd XLConnect/man/readTable-methods.Rd XLConnect/man/setSheetColor-methods.Rd XLConnect/man/setCellFormula-methods.Rd XLConnect/man/getReferenceCoordinatesForName-methods.Rd XLConnect/man/setAutoFilter-methods.Rd XLConnect/man/xlcFreeMemory.Rd XLConnect/man/getActiveSheetIndex-methods.Rd XLConnect/man/workbook-class.Rd XLConnect/man/idx2cref.Rd XLConnect/man/appendNamedRegion-methods.Rd XLConnect/man/unhideSheet-methods.Rd XLConnect/man/getSheetPos-methods.Rd XLConnect/man/xlcMemoryReport.Rd XLConnect/man/createSplitPane-methods.Rd XLConnect/man/renameSheet-methods.Rd XLConnect/man/hideSheet-methods.Rd XLConnect/man/jTryCatch.Rd XLConnect/man/getForceFormulaRecalculation-methods.Rd XLConnect/man/getReferenceCoordinates-methods.Rd XLConnect/man/setSheetPos-methods.Rd XLConnect/man/extraction-methods.Rd XLConnect/man/setBorder-methods.Rd XLConnect/man/saveWorkbook-methods.Rd XLConnect/man/print-methods.Rd XLConnect/man/clearRangeFromReference-methods.Rd XLConnect/man/setForceFormulaRecalculation-methods.Rd XLConnect/man/getTables-methods.Rd XLConnect/man/createCellStyle-methods.Rd XLConnect/man/cref2idx.Rd XLConnect/man/dollar-methods.Rd XLConnect/man/loadWorkbook.Rd XLConnect/man/getCellFormula-methods.Rd XLConnect/man/XLConnect-package.Rd XLConnect/man/removePane-methods.Rd XLConnect/man/readNamedRegionFromFile.Rd XLConnect/man/onErrorCell-methods.Rd XLConnect/man/existsName-methods.Rd XLConnect/man/removeSheet-methods.Rd XLConnect/man/writeNamedRegion-methods.Rd XLConnect/man/normalizeDataframe.Rd XLConnect/man/xlcEdit.Rd XLConnect/man/cloneSheet-methods.Rd XLConnect/man/setDataFormatForType-methods.Rd XLConnect/man/xlcDump.Rd XLConnect/man/isSheetVeryHidden-methods.Rd XLConnect/man/setFillForegroundColor-methods.Rd XLConnect/man/xlcRestore.Rd XLConnect/man/col2idx.Rd XLConnect/man/setDataFormat-methods.Rd XLConnect/man/aref2idx.Rd XLConnect/man/XLConnect-deprecated.Rd XLConnect/man/with.workbook.Rd XLConnect/man/setFillPattern-methods.Rd XLConnect/man/readWorksheet-methods.Rd XLConnect/man/getBoundingBox-methods.Rd XLConnect/man/swissfranc.Rd XLConnect/man/writeWorksheetToFile.Rd XLConnect/man/getDefinedNames-methods.Rd XLConnect/man/readNamedRegion-methods.Rd XLConnect/man/idx2aref.Rd XLConnect/man/setWrapText-methods.Rd XLConnect/man/idx2col.Rd XLConnect/man/getActiveSheetName-methods.Rd XLConnect/man/show-methods.Rd XLConnect/man/mirai.Rd
XLConnect/.Rinstignore

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.