XLConnect v0.2-14

0

Monthly downloads

0th

Percentile

Excel Connector for R

Provides comprehensive functionality to read, write and format Excel data.

Readme

XLConnect: Excel Connector for R

CRAN\_Status\_Badge Rdoc Research software impact Build Status codecov

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("xlconnect", username = "miraisolutions", ref = "master")

# Installs XLConnect 0.2-14
install_github("xlconnect", username = "miraisolutions", ref = "0.2-14")

For more examples and news see also our wordpress site.

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.

Functions in XLConnect

Name Description
appendWorksheet-methods Appending data to worksheets
aref Constructing Excel area references
XLConnect-package Excel Connector for R
XLConnectSettings Performing general settings for XLConnect
XLC XLConnect Constants
XLConnect-deprecated Deprecated functions in package XLConnect
addImage-methods Adding images to a worksheet
appendNamedRegion-methods Appending data to a named region
aref2idx Converting Excel cell references to row and column based cell references
cellstyle-class Class "cellstyle"
existsName-methods Checking existence of names in a workbook
existsSheet-methods Checking for existence of worksheets in a workbook
cloneSheet-methods Cloning/copying worksheets
col2idx Converting Excel column names to indices
extractSheetName Extracting the sheet name from a formula
clearNamedRegion-methods Clearing named regions in a workbook
clearRange-methods Clearing cell ranges in a workbook
createSplitPane-methods Creating a split pane on a worksheet
cref2idx Converting Excel cell references to indices
createCellStyle-methods Creating custom named and anonymous cell styles
getBoundingBox-methods Querying the coordinates of a worksheet bounding box
getCellFormula-methods Retrieving formula definitions from cells
hideSheet-methods Hiding worksheets in a workbook
idx2aref Converting row and column based area references to Excel area references
onErrorCell-methods Behavior when error cells are detected
extraction-methods Workbook data extraction & replacement operators
getSheets-methods Querying available worksheets in a workbook
getTables-methods Querying available Excel tables in a workbook
createFreezePane-methods Creating a freeze pane on a worksheet
createName-methods Creating names in a workbook
createSheet-methods Creating worksheets in a workbook
$-methods Executing workbook methods in object$method(...) form
mirai Mirai Solutions GmbH
normalizeDataframe Data frame Normalization for Unit Tests
readNamedRegion Reading named regions from a workbook
getOrCreateCellStyle-methods Retrieving or creating named cell styles
getReferenceCoordinates-methods Querying the coordinates of the range reference by an Excel name
isSheetVisible-methods Checking if worksheets are visible in a workbook
jTryCatch Standard Java exception handling for XLConnect
readNamedRegionFromFile Reading named regions from an Excel file (wrapper function)
setCellStyle-methods Setting cell styles
setCellStyleForType-methods Setting the cell style per data type for the DATATYPE style action
readTable Reading Excel tables from a workbook
readWorksheet-methods Reading data from worksheets
setDataFormatForType-methods Setting the data format for the DATA_FORMAT_ONLY style action
print-methods Print a workbook's filename
readWorksheetFromFile Reading data from worksheets in an Excel file (wrapper function)
removeName-methods Removing names from workbooks
setActiveSheet-methods Setting the active worksheet in a workbook
setAutoFilter-methods Setting auto-filters on worksheets
xlcFreeMemory Freeing Java Virtual Machine memory
xlcMemoryReport Reporting free Java Virtual Machine memory
setStyleAction-methods Controlling application of cell styles when writing data to Excel
setStyleNamePrefix-methods Setting the style name prefix for the "name prefix" style action
summary-methods Summarizing workbook objects
swissfranc Historical Exchange Rates: CHF vs EUR, USD and GBP
xlcDump Dumping data sets to Excel files
xlcEdit Editing data sets in an Excel file editor
existsCellStyle-methods Retrieving named cell styles
getDefinedNames-methods Retrieving defined names in a workbook
getForceFormulaRecalculation-methods Querying the coordinates of the range reference by an Excel name
getReferenceFormula-methods Querying reference formulas of Excel names
clearRangeFromReference-methods Clearing cell ranges in a workbook
clearSheet-methods Clearing worksheets in a workbook
getActiveSheetIndex-methods Querying the active worksheet index
getActiveSheetName-methods Querying the active worksheet name
getLastColumn-methods Querying the last (non-empty) column on a worksheet
getLastRow-methods Querying the last (non-empty) row on a worksheet
getReferenceCoordinatesForName-methods Querying the coordinates of the range reference by an Excel name
getReferenceCoordinatesForTable-methods Querying the coordinates of the range of an Excel table
isSheetHidden-methods Checking if worksheets are hidden in a workbook
setFillBackgroundColor-methods Specifying the fill background color for cell styles
setMissingValue-methods Setting missing value identifiers
setRowHeight-methods Setting the height of a row in a worksheet
isSheetVeryHidden-methods Checking if worksheets are very hidden in a workbook
removePane-methods Removing panes from worksheet
removeSheet-methods Removing worksheets from workbooks
setForceFormulaRecalculation-methods Forcing Excel to recalculate formula values when opening a workbook
setHyperlink-methods Setting hyperlinks
with.workbook Evaluate an R expression in a workbook environment
workbook-class Class "workbook"
getCellStyle-methods Retrieving named cell styles
getCellStyleForType-methods Querying the cell style per data type for the DATATYPE style action
idx2col Converting column indices to Excel column names
idx2cref Converting indices to Excel cell references
renameSheet-methods Renaming worksheets from workbooks
saveWorkbook-methods Saving Microsoft Excel workbooks
getSheetPos-methods Querying worksheet position
loadWorkbook Loading Microsoft Excel workbooks
mergeCells-methods Merging cells
setColumnWidth-methods Setting the width of a column in a worksheet
setDataFormat-methods Specifying custom data formats for cell styles
setSheetColor-methods Setting colors on worksheet tabs
setSheetPos-methods Setting worksheet position
xlcRestore Restoring objects from Excel files
setBorder-methods Specifying borders for cell styles
setCellFormula-methods Setting cell formulas
setFillForegroundColor-methods Specifying the fill foreground color for cell styles
setFillPattern-methods Specifying the fill pattern for cell styles
unhideSheet-methods Unhiding worksheets in a workbook
unmergeCells-methods Unmerging cells
writeWorksheetToFile Writing data to worksheets in an Excel file (wrapper function)
wrapList Wrapping of arguments in a list
writeNamedRegion-methods Writing named regions to a workbook
setWrapText-methods Specifying text wrapping behaviour
show-methods Display a workbook object
writeNamedRegionToFile Writing named regions to an Excel file (wrapper function)
writeWorksheet-methods Writing data to worksheets
xlcCall Automatic argument vectorization, default Java exception and warnings handling for XLConnect
No Results!

Vignettes of XLConnect

Name
img/BrownBug.png
img/Excel.png
img/Feedback.png
img/LinkedIn-Icon.png
img/Rlogo.png
img/XLConnectExample1.png
img/XLConnectExample2.png
img/XLConnectExample3.png
img/mtcars.png
XLConnect.Rnw
XLConnectImpatient.Rnw
tikzCodeBlock.sty
tikzDeviceMacros.tex
No Results!

Last month downloads

Details

Type Package
Date 2018-01-23
URL http://www.mirai-solutions.com https://github.com/miraisolutions/xlconnect
BugReports https://github.com/miraisolutions/xlconnect/issues
SystemRequirements Java (>= 6)
License GPL-3
Copyright See file COPYRIGHTS
LazyData yes
NeedsCompilation no
Packaged 2018-01-23 09:14:48 UTC; mstuder
Repository CRAN
Date/Publication 2018-01-23 16:51:45 UTC

Include our badge in your README

[![Rdoc](http://www.rdocumentation.org/badges/version/XLConnect)](http://www.rdocumentation.org/packages/XLConnect)