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



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.1.0, https://cran.r-project.org/web/packages/XLConnect. Accessed 07 Nov. 2024.
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)
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
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

robregcc  
Robust Regression with Compositional Covariates
We implement the algorithm estimating the parameters of the robust regression model with composition ...
Download / Learn more Package Citations See dependency  
nextGenShinyApps  
Craft Exceptional 'R Shiny' Applications and Dashboards with Novel Responsive Tools
Nove responsive tools for designing and developing 'Shiny' dashboards and applications. The scripts ...
Download / Learn more Package Citations See dependency  
bacondecomp  
Goodman-Bacon Decomposition
Decomposition for differences-in-differences with variation in treatment timing from Goodman-Bacon ...
Download / Learn more Package Citations See dependency  
con2aqi  
Calculate the AQI from Pollutant Concentration
To calculate the AQI (Air Quality Index) from pollutant concentration data. O3, PM2.5, PM10, CO, SO ...
Download / Learn more Package Citations See dependency  

23,092

R Packages

198,677

Dependencies

62,675

Author Associations

23,089

Publication Badges

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