XLConnect v1.0.2
0
Monthly downloads
Excel Connector for R
Provides comprehensive functionality to read, write and format Excel data.
Readme
XLConnect: Excel Connector for R
XLConnect is a comprehensive and cross-platform R package for manipulating Microsoft Excel files from within R. XLConnect differs from other related R packages in that it is completely cross-platform and as such runs under Windows, Unix/Linux and Mac (32- and 64-bit). Moreover, it does not require any installation of Microsoft Excel or any other special drivers to be able to read & write Excel files. The only requirement is a recent version of a Java Runtime Environment (JRE).
The package can easily be installed from CRAN via install.packages("XLConnect"). In order to get started have a look at the XLConnect and XLConnect for the Impatient package vignettes, the numerous demos available via demo(package = "XLConnect") or browse through the comprehensive reference manual.
Alternatively, you may install XLConnect directly from our github repository using the excellent devtools package:
require(devtools)
# Installs the master branch of XLConnect (= current development version)
install_github("miraisolutions/xlconnect")
# Installs XLConnect with the given version, e.g. 1.0.2
install_github("miraisolutions/xlconnect", ref = "<version>")
Please send any enhancement requests or bug reports with a simple and self-contained reproducible example to xlconnect@mirai-solutions.com or log a corresponding issue on our github repository. For other questions you may also use Stackoverflow.
Build for release on CRAN
devtools::build(args=c("--compact-vignettes=gs+qpdf"))
Functions in XLConnect
| Name | Description | |
| addImage-methods | Adding images to a worksheet | |
| createCellStyle-methods | Creating custom named and anonymous cell styles | |
| aref | Constructing Excel area references | |
| extractSheetName | Extracting the sheet name from a formula | |
| createFreezePane-methods | Creating a freeze pane on a worksheet | |
| appendWorksheet-methods | Appending data to worksheets | |
| extraction-methods | Workbook data extraction & replacement operators | |
| XLConnect-deprecated | Deprecated functions in package XLConnect | |
| clearNamedRegion-methods | Clearing named regions in a workbook | |
| idx2col | Converting column indices to Excel column names | |
| getActiveSheetIndex-methods | Querying the active worksheet index | |
| XLC | XLConnect Constants | |
| idx2cref | Converting indices to Excel cell references | |
| isSheetHidden-methods | Checking if worksheets are hidden in a workbook | |
| readWorksheetFromFile | Reading data from worksheets in an Excel file (wrapper function) | |
| isSheetVeryHidden-methods | Checking if worksheets are very hidden in a workbook | |
| removeName-methods | Removing names from workbooks | |
| getActiveSheetName-methods | Querying the active worksheet name | |
| getOrCreateCellStyle-methods | Retrieving or creating named cell styles | |
| setForceFormulaRecalculation-methods | Forcing Excel to recalculate formula values when opening a workbook | |
| clearRange-methods | Clearing cell ranges in a workbook | |
| clearRangeFromReference-methods | Clearing cell ranges in a workbook | |
| clearSheet-methods | Clearing worksheets in a workbook | |
| hideSheet-methods | Hiding worksheets in a workbook | |
| getReferenceCoordinates-methods | Querying the coordinates of the range reference by an Excel name | |
| getForceFormulaRecalculation-methods | Querying the coordinates of the range reference by an Excel name | |
| idx2aref | Converting row and column based area references to Excel area references | |
| existsName-methods | Checking existence of names in a workbook | |
| existsSheet-methods | Checking for existence of worksheets in a workbook | |
| getDefinedNames-methods | Retrieving defined names in a workbook | |
| loadWorkbook | Loading Microsoft Excel workbooks | |
| createSplitPane-methods | Creating a split pane on a worksheet | |
| cref2idx | Converting Excel cell references to indices | |
| mirai | Mirai Solutions GmbH | |
| getBoundingBox-methods | Querying the coordinates of a worksheet bounding box | |
| mergeCells-methods | Merging cells | |
| XLConnectSettings | Performing general settings for XLConnect | |
| normalizeDataframe | Data frame Normalization for Unit Tests | |
| getCellStyle-methods | Retrieving named cell styles | |
| XLConnect-package | Excel Connector for R | |
| col2idx | Converting Excel column names to indices | |
| cloneSheet-methods | Cloning/copying worksheets | |
| getCellFormula-methods | Retrieving formula definitions from cells | |
| getTables-methods | Querying available Excel tables in a workbook | |
| readWorksheet-methods | Reading data from worksheets | |
| getCellStyleForType-methods | Querying the cell style per data type for the DATATYPE style action | |
| getSheets-methods | Querying available worksheets in a workbook | |
| readTable | Reading Excel tables from a workbook | |
| setHyperlink-methods | Setting hyperlinks | |
| getReferenceCoordinatesForTable-methods | Querying the coordinates of the range of an Excel table | |
| getReferenceCoordinatesForName-methods | Querying the coordinates of the range reference by an Excel name | |
| readNamedRegionFromFile | Reading named regions from an Excel file (wrapper function) | |
| jTryCatch | Standard Java exception handling for XLConnect | |
| readNamedRegion | Reading named regions from a workbook | |
| isSheetVisible-methods | Checking if worksheets are visible in a workbook | |
| aref2idx | Converting Excel cell references to row and column based cell references | |
| createSheet-methods | Creating worksheets in a workbook | |
| renameSheet-methods | Renaming worksheets from workbooks | |
| $-methods | Executing workbook methods in object$method(...) form | |
| createName-methods | Creating names in a workbook | |
| cellstyle-class | Class "cellstyle" | |
| setColumnWidth-methods | Setting the width of a column in a worksheet | |
| existsCellStyle-methods | Retrieving named cell styles | |
| setBorder-methods | Specifying borders for cell styles | |
| getLastColumn-methods | Querying the last (non-empty) column on a worksheet | |
| setActiveSheet-methods | Setting the active worksheet in a workbook | |
| setCellFormula-methods | Setting cell formulas | |
| saveWorkbook-methods | Saving Microsoft Excel workbooks | |
| setDataFormat-methods | Specifying custom data formats for cell styles | |
| setStyleAction-methods | Controlling application of cell styles when writing data to Excel | |
| writeNamedRegionToFile | Writing named regions to an Excel file (wrapper function) | |
| getLastRow-methods | Querying the last (non-empty) row on a worksheet | |
| getReferenceFormula-methods | Querying reference formulas of Excel names | |
| show-methods | Display a workbook object | |
| setWrapText-methods | Specifying text wrapping behaviour | |
| getSheetPos-methods | Querying worksheet position | |
| setAutoFilter-methods | Setting auto-filters on worksheets | |
| setDataFormatForType-methods | Setting the data format for the DATA_FORMAT_ONLY style action | |
| onErrorCell-methods | Behavior when error cells are detected | |
| writeWorksheet-methods | Writing data to worksheets | |
| with.workbook | Evaluate an R expression in a workbook environment | |
| setStyleNamePrefix-methods | Setting the style name prefix for the "name prefix" style action | |
| setSheetPos-methods | Setting worksheet position | |
| setSheetColor-methods | Setting colors on worksheet tabs | |
| setFillBackgroundColor-methods | Specifying the fill background color for cell styles | |
| workbook-class | Class "workbook" | |
| unhideSheet-methods | Unhiding worksheets in a workbook | |
| print-methods | Print a workbook's filename | |
| setMissingValue-methods | Setting missing value identifiers | |
| xlcMemoryReport | Reporting free Java Virtual Machine memory | |
| xlcFreeMemory | Freeing Java Virtual Machine memory | |
| xlcDump | Dumping data sets to Excel files | |
| xlcEdit | Editing data sets in an Excel file editor | |
| unmergeCells-methods | Unmerging cells | |
| removePane-methods | Removing panes from worksheet | |
| setRowHeight-methods | Setting the height of a row in a worksheet | |
| setCellStyle-methods | Setting cell styles | |
| removeSheet-methods | Removing worksheets from workbooks | |
| setCellStyleForType-methods | Setting the cell style per data type for the DATATYPE style action | |
| setFillForegroundColor-methods | Specifying the fill foreground color for cell styles | |
| wrapList | Wrapping of arguments in a list | |
| setFillPattern-methods | Specifying the fill pattern for cell styles | |
| xlcCall | Automatic argument vectorization, default Java exception and warnings handling for XLConnect | |
| swissfranc | Historical Exchange Rates: CHF vs EUR, USD and GBP | |
| writeWorksheetToFile | Writing data to worksheets in an Excel file (wrapper function) | |
| summary-methods | Summarizing workbook objects | |
| xlcRestore | Restoring objects from Excel files | |
| writeNamedRegion-methods | Writing named regions to a workbook | |
| appendNamedRegion-methods | Appending data to a named region | |
| No Results! | ||
Vignettes of XLConnect
Last month downloads
Details
| Type | Package |
| URL | https://mirai-solutions.ch https://github.com/miraisolutions/xlconnect |
| BugReports | https://github.com/miraisolutions/xlconnect/issues |
| SystemRequirements | Java (>= 8, <= 15) |
| License | GPL-3 |
| Copyright | See file COPYRIGHTS |
| LazyData | yes |
| NeedsCompilation | no |
| Packaged | 2021-02-12 14:33:36 UTC; simon |
| Repository | CRAN |
| Date/Publication | 2021-02-15 06:10:07 UTC |
| suggests | ggplot2 (>= 0.9.3) , lattice , RUnit , zoo |
| imports | methods , rJava |
| depends | R (>= 2.10.0) |
| Contributors | The Apache Software Foundation, Mirai GmbH, Graph Builder |
Include our badge in your README
[](http://www.rdocumentation.org/packages/XLConnect)