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

Files in this package

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.

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