Other packages > Find by keyword >

XLConnect  

Excel Connector for R
View on CRAN: Click here


Download and install XLConnect package within the R console
Install from CRAN:
install.packages("XLConnect")

Install from Github:
library("remotes")
install_github("cran/XLConnect")

Install by package version:
library("remotes")
install_version("XLConnect", "1.0.9")



Attach the package and use:
library("XLConnect")
Maintained by
Martin Studer
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2011-02-27
Latest Update: 2023-01-24
Description:
Provides comprehensive functionality to read, write and format Excel data.
How to cite:
Martin Studer (2011). XLConnect: Excel Connector for R. R package version 1.0.9, https://cran.r-project.org/web/packages/XLConnect
Previous versions and publish date:
0.1-3 (2011-02-27 17:28), 0.1-4 (2011-05-26 22:48), 0.1-5 (2011-07-07 10:24), 0.1-7 (2011-10-20 17:18), 0.1-8 (2012-02-11 07:38), 0.1-9 (2012-03-09 11:12), 0.2-0 (2012-07-20 07:47), 0.2-1 (2012-08-17 14:21), 0.2-2 (2012-10-15 22:09), 0.2-3 (2012-11-05 18:27), 0.2-4 (2013-02-02 18:30), 0.2-5 (2013-03-18 21:35), 0.2-6 (2013-12-31 18:24), 0.2-7 (2014-01-03 21:45), 0.2-8 (2014-08-06 07:21), 0.2-9 (2014-08-14 06:52), 0.2-10 (2015-01-25 15:06), 0.2-11 (2015-03-01 17:58), 0.2-12 (2016-06-24 09:53), 0.2-13 (2017-05-14 19:52), 0.2-14 (2018-01-23 17:51), 0.2-15 (2018-04-05 19:20), 1.0.0 (2020-03-20 10:50), 1.0.1 (2020-03-23 12:10), 1.0.2 (2021-02-15 07:10), 1.0.3 (2021-04-11 06:30), 1.0.4 (2021-07-29 15:50), 1.0.5 (2021-10-01 12:30), 1.0.6 (2022-10-21 10:35), 1.0.7 (2023-01-24 14:40), 1.0.8 (2024-01-30 16:30), 1.0.9 (2024-04-17 16:30)
Other packages that cited XLConnect R package
View XLConnect citation profile
Other R packages that XLConnect depends, imports, suggests or enhances
Functions, R codes and Examples using the XLConnect R package
Some associated functions: XLC . XLConnect-deprecated . XLConnect-package . XLConnectSettings . addImage-methods . appendNamedRegion-methods . appendWorksheet-methods . aref . aref2idx . cellstyle-class . clearNamedRegion-methods . clearRange-methods . clearRangeFromReference-methods . clearSheet-methods . cloneSheet-methods . col2idx . createCellStyle-methods . createFreezePane-methods . createName-methods . createSheet-methods . createSplitPane-methods . cref2idx . dollar-methods . existsCellStyle-methods . existsName-methods . existsSheet-methods . extractSheetName . extraction-methods . getActiveSheetIndex-methods . getActiveSheetName-methods . getBoundingBox-methods . getCellFormula-methods . getCellStyle-methods . getCellStyleForType-methods . getDefinedNames-methods . getForceFormulaRecalculation-methods . getLastColumn-methods . getLastRow-methods . getOrCreateCellStyle-methods . getReferenceCoordinates-methods . getReferenceCoordinatesForName-methods . getReferenceCoordinatesForTable-methods . getReferenceFormula-methods . getSheetPos-methods . getSheets-methods . getTables-methods . hideSheet-methods . idx2aref . idx2col . idx2cref . isSheetHidden-methods . isSheetVeryHidden-methods . isSheetVisible-methods . jTryCatch . loadWorkbook . mergeCells-methods . mirai . normalizeDataframe . onErrorCell-methods . print-methods . readNamedRegion-methods . readNamedRegionFromFile . readTable-methods . readWorksheet-methods . readWorksheetFromFile . removeName-methods . removePane-methods . removeSheet-methods . renameSheet-methods . saveWorkbook-methods . setActiveSheet-methods . setAutoFilter-methods . setBorder-methods . setCellFormula-methods . setCellStyle-methods . setCellStyleForType-methods . setColumnWidth-methods . setDataFormat-methods . setDataFormatForType-methods . setFillBackgroundColor-methods . setFillForegroundColor-methods . setFillPattern-methods . setForceFormulaRecalculation-methods . setHyperlink-methods . setMissingValue-methods . setRowHeight-methods . setSheetColor-methods . setSheetPos-methods . setStyleAction-methods . setStyleNamePrefix-methods . setWrapText-methods . show-methods . summary-methods . swissfranc . unhideSheet-methods . unmergeCells-methods . with.workbook . workbook-class . wrapList . writeNamedRegion-methods . writeNamedRegionToFile . writeWorksheet-methods . writeWorksheetToFile . xlcCall . xlcDump . xlcEdit . xlcFreeMemory . xlcMemoryReport . xlcRestore . 
Some associated R codes: J.R . XLConnectSettings.R . aref.R . aref2idx.R . cellstyle.R . cellstyle.operators.R . cellstyle.setBorder.R . cellstyle.setDataFormat.R . cellstyle.setFillBackgroundColor.R . cellstyle.setFillForegroundColor.R . cellstyle.setFillPattern.R . cellstyle.setWrapText.R . checkSystemPackage.R . classToXlcType.R . col2idx.R . constants.R . cref2idx.R . dataframeFromJava.R . dataframeToJava.R . extractRownames.R . extractSheetName.R . getColSubset.R . idx2aref.R . idx2col.R . idx2cref.R . includeRownames.R . jTryCatch.R . jseq.R . jsle.R . loadWorkbook.R . mirai.R . normalizeDataframe.R . onAttach.R . onLoad.R . readNamedRegionFromFile.R . readWorksheetFromFile.R . rg2idx.R . seqle.R . with.workbook.R . workbook.R . workbook.addImage.R . workbook.appendNamedRegion.R . workbook.appendWorksheet.R . workbook.clearNamedRegion.R . workbook.clearRange.R . workbook.clearRangeFromReference.R . workbook.clearSheet.R . workbook.cloneSheet.R . workbook.createCellStyle.R . workbook.createFreezePane.R . workbook.createName.R . workbook.createSheet.R . workbook.createSplitPane.R . workbook.existsCellStyle.R . workbook.existsName.R . workbook.existsSheet.R . workbook.getActiveSheetIndex.R . workbook.getActiveSheetName.R . workbook.getBoundingBox.R . workbook.getCellFormula.R . workbook.getCellStyle.R . workbook.getCellStyleForType.R . workbook.getDefinedNames.R . workbook.getForceFormulaRecalculation.R . workbook.getLastColumn.R . workbook.getLastRow.R . workbook.getOrCreateCellStyle.R . workbook.getReferenceCoordinates.R . workbook.getReferenceCoordinatesForName.R . workbook.getReferenceCoordinatesForTable.R . workbook.getReferenceFormula.R . workbook.getSheetPos.R . workbook.getSheets.R . workbook.getTables.R . workbook.hideSheet.R . workbook.isSheetHidden.R . workbook.isSheetVeryHidden.R . workbook.isSheetVisible.R . workbook.mergeCells.R . workbook.onErrorCell.R . workbook.operators.R . workbook.print.R . workbook.readNamedRegion.R . workbook.readTable.R . workbook.readWorksheet.R . workbook.removeName.R . workbook.removePane.R . workbook.removeSheet.R . workbook.renameSheet.R . workbook.saveWorkbook.R . workbook.setActiveSheet.R . workbook.setAutoFilter.R . workbook.setCellFormula.R . workbook.setCellStyle.R . workbook.setCellStyleForType.R . workbook.setColumnWidth.R . workbook.setDataFormatForType.R . workbook.setForceFormulaRecalculation.R . workbook.setHyperlink.R . workbook.setMissingValue.R . workbook.setRowHeight.R . workbook.setSheetColor.R . workbook.setSheetPos.R . workbook.setStyleAction.R . workbook.setStyleNamePrefix.R . workbook.show.R . workbook.summary.R . workbook.unhideSheet.R . workbook.unmergeCells.R . workbook.writeNamedRegion.R . workbook.writeWorksheet.R . wrapList.R . writeNamedRegionToFile.R . writeWorksheetToFile.R . xlcCall.R . xlcDump.R . xlcEdit.R . xlcEnsureDependenciesFor.R . xlcFreeMemory.R . xlcMemoryReport.R . xlcRestore.R .  Full XLConnect package functions and examples
Downloads during the last 30 days
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

steepness  
Testing Steepness of Dominance Hierarchies
The steepness package computes steepness as a property of dominance hierarchies. Steepness is define ...
Download / Learn more Package Citations See dependency  
critpath  
Setting the Critical Path in Project Management
Solving the problem of project management using CPM (Critical Path Method), PERT (Program Evaluation ...
Download / Learn more Package Citations See dependency  
ftaproxim  
Fault Tree Analysis Based on Proxel Simulation
Calculation and plotting of instantaneous unavailabilities of basic events along with the top event ...
Download / Learn more Package Citations See dependency  
rdbnomics  
Download DBnomics Data
R access to hundreds of millions data series from DBnomics API (). ...
Download / Learn more Package Citations See dependency  
mistral  
Methods in Structural Reliability
Various reliability analysis methods for rare event inference (computing failure probability and qua ...
Download / Learn more Package Citations See dependency  
quickcode  
Quick and Essential 'R' Tricks for Better Scripts
The NOT functions, 'R' tricks and a compilation of some simple quick plus often used 'R' codes to im ...
Download / Learn more Package Citations See dependency  

22,114

R Packages

188,080

Dependencies

55,244

Author Associations

22,115

Publication Badges

© Copyright 2022 - present. All right reserved, rpkg.net. Contact Us / Suggestions / Concerns