Files in XLConnect

Excel Connector for R

README.md R/workbook.setStyleAction.R R/workbook.clearSheet.R R/workbook.setDataFormatForType.R R/workbook.getReferenceCoordinatesForTable.R R/workbook.setCellStyleForType.R R/classToXlcType.R R/workbook.clearRange.R R/rg2idx.R R/workbook.getBoundingBox.R R/workbook.setHyperlink.R R/aref.R R/xlcEdit.R R/workbook.unmergeCells.R R/workbook.getCellStyle.R R/cref2idx.R R/seqle.R R/workbook.writeWorksheet.R R/configurePOI.R R/workbook.saveWorkbook.R R/writeWorksheetToFile.R R/workbook.getActiveSheetName.R R/jseq.R R/dataframeFromJava.R R/idx2col.R R/workbook.existsSheet.R R/workbook.getSheets.R R/workbook.hideSheet.R R/readWorksheetFromFile.R R/workbook.getReferenceFormula.R R/workbook.getOrCreateCellStyle.R R/workbook.getLastRow.R R/workbook.clearNamedRegion.R R/workbook.setForceFormulaRecalculation.R R/workbook.writeNamedRegion.R R/workbook.R R/with.workbook.R R/jTryCatch.R R/workbook.onErrorCell.R R/workbook.createCellStyle.R R/workbook.removeSheet.R R/workbook.removePane.R R/cellstyle.setDataFormat.R R/workbook.getReferenceCoordinates.R R/cellstyle.operators.R R/workbook.removeName.R R/wrapList.R R/xlcMemoryReport.R R/workbook.createSplitPane.R R/onAttach.R R/workbook.appendWorksheet.R R/XLConnectSettings.R R/workbook.renameSheet.R R/workbook.setCellFormula.R R/idx2cref.R R/workbook.getLastColumn.R R/jsle.R R/xlcRestore.R R/workbook.readNamedRegion.R R/idx2aref.R R/workbook.addImage.R R/col2idx.R R/readNamedRegionFromFile.R R/workbook.readTable.R R/extractRownames.R R/workbook.isSheetHidden.R R/workbook.clearRangeFromReference.R R/workbook.cloneSheet.R R/workbook.setAutoFilter.R R/workbook.unhideSheet.R R/normalizeDataframe.R R/workbook.setActiveSheet.R R/workbook.readWorksheet.R R/aref2idx.R R/cellstyle.R R/dataframeToJava.R R/workbook.print.R R/xlcEnsureDependenciesFor.R R/workbook.setMissingValue.R R/workbook.getTables.R R/workbook.getDefinedNames.R R/workbook.show.R R/workbook.getCellStyleForType.R R/workbook.createName.R R/workbook.existsName.R R/onLoad.R R/workbook.existsCellStyle.R R/workbook.setCellStyle.R R/workbook.isSheetVeryHidden.R R/workbook.setRowHeight.R R/getColSubset.R R/workbook.setSheetColor.R R/workbook.getSheetPos.R R/loadWorkbook.R R/cellstyle.setWrapText.R R/workbook.appendNamedRegion.R R/writeNamedRegionToFile.R R/includeRownames.R R/constants.R R/cellstyle.setFillBackgroundColor.R R/workbook.isSheetVisible.R R/xlcFreeMemory.R R/mirai.R R/extractSheetName.R R/checkSystemPackage.R R/workbook.getReferenceCoordinatesForName.R R/workbook.createFreezePane.R R/cellstyle.setFillPattern.R R/J.R R/xlcCall.R R/workbook.mergeCells.R R/workbook.getCellFormula.R R/workbook.operators.R R/xlcDump.R R/withAttributesFromJava.R R/workbook.createSheet.R R/workbook.getForceFormulaRecalculation.R R/xlcOperators.R R/cellstyle.setBorder.R R/workbook.summary.R R/workbook.setColumnWidth.R R/workbook.setStyleNamePrefix.R R/cellstyle.setFillForegroundColor.R R/workbook.getActiveSheetIndex.R R/workbook.setSheetPos.R inst/XLConnect.R inst/doc/XLConnect.pdf inst/doc/XLConnect.R inst/doc/XLConnectImpatient.pdf demo/dataformat.R demo/readWorksheet.R demo/summary.R demo/cellstyles2.R demo/writeLargeData.R demo/writeWorksheet.R demo/readNamedRegion.R demo/withWorkbook.R demo/hideSheets.R demo/writeNamedRegion.R demo/cellsize.R demo/addImage.R demo/cellstyles1.R demo/cellstyles3.R tests/test-all.R tests/testthat/test.workbook.setMissingValue.R tests/testthat/test.arefidx.R tests/testthat/test.workbook.getReferenceCoordinatesForTable.R tests/testthat/test.workbook.hideSheet.R tests/testthat/test.workbook.removeSheet.R tests/testthat/test.workbook.isSheetVeryHidden.R tests/testthat/test.workbook.extraction.R tests/testthat/test.workbook.isSheetVisible.R tests/testthat/test.workbook.getSheetPos.R tests/testthat/test.workbook.getTables.R tests/testthat/test.workbook.setActiveSheet.R tests/testthat/test.with.workbook.R tests/testthat/test.workbook.createName.R tests/testthat/test.workbook.getReferenceFormula.R tests/testthat/test.colidx.R tests/testthat/test.workbook.setForceFormulaRecalculation.R tests/testthat/test.workbook.unhideSheet.R tests/testthat/test.crefidx.R tests/testthat/test.workbook.testBug181.R tests/testthat/test.workbook.existsSheet.R tests/testthat/test.writeAndReadWorksheet.R tests/testthat/test.workbook.getDefinedNames.R tests/testthat/test.dumpAndRestore.R tests/testthat/test.workbook.cloneSheet.R tests/testthat/helper-rsrc.R tests/testthat/test.workbook.saveWorkbook.R tests/testthat/test.extractSheetName.R tests/testthat/test.writeNamedRegionToFile.R tests/testthat/test.configurePOI.R tests/testthat/test.workbook.onErrorCell.R tests/testthat/test.workbook.getLastRow.R tests/testthat/test.workbook.renameSheet.R tests/testthat/test.workbook.isSheetHidden.R tests/testthat/test.workbook.clearNamedRegion.R tests/testthat/test.workbook.clearRange.R tests/testthat/test.workbook.readTable.R tests/testthat/test.workbook.setSheetPos.R tests/testthat/test.workbook.clearSheet.R tests/testthat/test.workbook.getReferenceCoordinates.R tests/testthat/test.workbook.clearRangeFromReference.R tests/testthat/test.workbook.readWorksheet.R tests/testthat/test.workbook.writeNamedRegion.R tests/testthat/test.dataframeConversion.R tests/testthat/test.workbook.existsName.R tests/testthat/test.workbook.getLastColumn.R tests/testthat/test.workbook.getBoundingBox.R tests/testthat/test.workbook.writeWorksheet.R tests/testthat/test.workbook.getActiveSheetIndex.R tests/testthat/test.workbook.getActiveSheetName.R tests/testthat/test.workbook.createSheet.R tests/testthat/setup.R tests/testthat/test.writeWorksheetToFile.R tests/testthat/test.loadWorkbook.R tests/testthat/test.workbook.cellstyles.R tests/testthat/test.workbook.getSheets.R tests/testthat/test.workbook.appendWorksheet.R tests/testthat/test.workbook.removeName.R tests/testthat/test.workbook.appendNamedRegion.R tests/testthat/test.writeAndReadNamedRegion.R tests/testthat/test.workbook.readNamedRegion.R man/unhideSheet-methods.Rd man/extraction-methods.Rd man/hideSheet-methods.Rd man/readNamedRegionFromFile.Rd man/getReferenceCoordinatesForName-methods.Rd man/setDataFormat-methods.Rd man/setSheetColor-methods.Rd man/saveWorkbook-methods.Rd man/getReferenceFormula-methods.Rd man/mergeCells-methods.Rd man/setFillBackgroundColor-methods.Rd man/setRowHeight-methods.Rd man/summary-methods.Rd man/createSplitPane-methods.Rd man/clearSheet-methods.Rd man/cellstyle-class.Rd man/cref2idx.Rd man/getCellFormula-methods.Rd man/getSheetPos-methods.Rd man/setActiveSheet-methods.Rd man/getOrCreateCellStyle-methods.Rd man/setBorder-methods.Rd man/createCellStyle-methods.Rd man/setForceFormulaRecalculation-methods.Rd man/clearRangeFromReference-methods.Rd man/isSheetHidden-methods.Rd man/readTable-methods.Rd man/existsName-methods.Rd man/setFillForegroundColor-methods.Rd man/XLConnect-deprecated.Rd man/xlcEdit.Rd man/removePane-methods.Rd man/setDataFormatForType-methods.Rd man/wrapList.Rd man/readWorksheetFromFile.Rd man/xlcFreeMemory.Rd man/getReferenceCoordinatesForTable-methods.Rd man/setStyleAction-methods.Rd man/addImage-methods.Rd man/unmergeCells-methods.Rd man/writeWorksheet-methods.Rd man/clearNamedRegion-methods.Rd man/aref2idx.Rd man/setCellStyleForType-methods.Rd man/clearRange-methods.Rd man/XLConnect-package.Rd man/readWorksheet-methods.Rd man/createName-methods.Rd man/loadWorkbook.Rd man/setAutoFilter-methods.Rd man/XLC.Rd man/setFillPattern-methods.Rd man/getDefinedNames-methods.Rd man/xlcCall.Rd man/appendNamedRegion-methods.Rd man/setCellStyle-methods.Rd man/setColumnWidth-methods.Rd man/readNamedRegion-methods.Rd man/normalizeDataframe.Rd man/removeName-methods.Rd man/aref.Rd man/writeNamedRegionToFile.Rd man/with.workbook.Rd man/extractSheetName.Rd man/workbook-class.Rd man/getLastRow-methods.Rd man/createSheet-methods.Rd man/getActiveSheetIndex-methods.Rd man/existsSheet-methods.Rd man/setHyperlink-methods.Rd man/idx2col.Rd man/getCellStyleForType-methods.Rd man/appendWorksheet-methods.Rd man/isSheetVisible-methods.Rd man/createFreezePane-methods.Rd man/setStyleNamePrefix-methods.Rd man/writeWorksheetToFile.Rd man/renameSheet-methods.Rd man/xlcRestore.Rd man/getForceFormulaRecalculation-methods.Rd man/writeNamedRegion-methods.Rd man/configurePOI.Rd man/mirai.Rd man/dollar-methods.Rd man/setCellFormula-methods.Rd man/XLConnectSettings.Rd man/setSheetPos-methods.Rd man/onErrorCell-methods.Rd man/xlcDump.Rd man/getCellStyle-methods.Rd man/idx2cref.Rd man/getTables-methods.Rd man/isSheetVeryHidden-methods.Rd man/jTryCatch.Rd man/getBoundingBox-methods.Rd man/cloneSheet-methods.Rd man/xlcMemoryReport.Rd man/col2idx.Rd man/getSheets-methods.Rd man/show-methods.Rd man/print-methods.Rd man/getReferenceCoordinates-methods.Rd man/getLastColumn-methods.Rd man/setWrapText-methods.Rd man/idx2aref.Rd man/setMissingValue-methods.Rd man/getActiveSheetName-methods.Rd man/removeSheet-methods.Rd man/existsCellStyle-methods.Rd man/swissfranc.Rd