XLConnect: Excel Connector for R
Version 0.2-13

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), Graph Builder [ctb, cph] (Curvesapi Java library)
Date of publication2017-05-14 17:52:04 UTC
MaintainerMartin Studer <martin.studer@mirai-solutions.com>
LicenseGPL-3
Version0.2-13
URL http://www.mirai-solutions.com http://miraisolutions.wordpress.com
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("XLConnect")

Getting started

Package overview
README.md

Popular man pages

clearSheet-methods: Clearing worksheets in a workbook
setCellStyle-methods: Setting cell styles
setColumnWidth-methods: Setting the width of a column in a worksheet
setDataFormat-methods: Specifying custom data formats for cell styles
setFillBackgroundColor-methods: Specifying the fill background color for cell styles
setForceFormulaRecalculation-methods: Forcing Excel to recalculate formula values when opening a...
writeWorksheet-methods: Writing data to worksheets
See all...

All man pages Function index File listing

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

Files

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

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

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

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