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.2.2")



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: 2025-05-26
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.2.2, https://cran.r-project.org/web/packages/XLConnect. Accessed 05 Jun. 2026.
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), 1.0.10 (2024-04-30 22:40), 1.1.0 (2024-08-22 16:00), 1.2.0 (2025-02-18 10:10), 1.2.1 (2025-04-29 16:50), 1.2.2 (2025-05-26 20:50)
Other packages that cited XLConnect R package
View XLConnect citation profile
Other R packages that XLConnect depends, imports, suggests or enhances
Complete documentation for XLConnect
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

Today's Hot Picks in Authors and Packages

envirem  
Generation of ENVIREM Variables
Generation of bioclimatic rasters that are complementary to the typical 19 bioclim variables. ...
Download / Learn more Package Citations See dependency  
msm  
Multi-State Markov and Hidden Markov Models in Continuous Time
Functions for fitting continuous-time Markov and hidden Markov multi-state models to longitudinal d ...
Download / Learn more Package Citations See dependency  
crossurr  
Cross-Fitting for Doubly Robust Evaluation of High-Dimensional Surrogate Markers
Doubly robust methods for evaluating surrogate markers as outlined in: Agniel D, Hejblum BP, Thiebau ...
Download / Learn more Package Citations See dependency  
ibb  
R Wrapper for Istanbul Municipality Open Data Portal
Call wrappers for Istanbul Metropolitan Municipality's Open Data Portal (Turkish: Istanbul B ...
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  

27,268

R Packages

233,548

Dependencies

72,590

Author Associations

27,205

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA