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



Attach the package and use:
library("XLConnect")
Maintained by
Martin Studer
[Scholar Profile | Author Map]
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.2.0, https://cran.r-project.org/web/packages/XLConnect. Accessed 10 Apr. 2025.
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)
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
03/1103/1203/1303/1403/1503/1603/1703/1803/1903/2003/2103/2203/2303/2403/2503/2603/2703/2803/2903/3003/3104/0104/0204/0304/0404/0504/0604/0704/08Downloads for XLConnect50100150200250300350400TrendBars

Today's Hot Picks in Authors and Packages

ecochange  
Integrating Ecosystem Remote Sensing Products to Derive EBV Indicators
Essential Biodiversity Variables (EBV) are state variables with dimensions on time, space, and biolo ...
Download / Learn more Package Citations See dependency  
txtq  
A Small Message Queue for Parallel Processes
This queue is a data structure that lets parallel processes send and receive messages, and it can he ...
Download / Learn more Package Citations See dependency  
xtermStyle  
Terminal Text Formatting Using Escape Sequences
Can be used for coloring output in terminals. It was developed for the standard Ubuntu terminal but ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
RODBC  
ODBC Database Access
webglobe  
3D Interactive Globes
Displays geospatial data on an interactive 3D globe in the web browser. ...
Download / Learn more Package Citations See dependency  

24,012

R Packages

207,311

Dependencies

64,867

Author Associations

24,013

Publication Badges

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