XLConnect: Excel Connector for R

Share:

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

Author
Mirai 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 publication
2016-06-24 09:53:27
Maintainer
Martin Studer <martin.studer@mirai-solutions.com>
License
GPL-3
Version
0.2-12
URLs

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