XLConnect1.2.2 package

Adding images to a worksheet

Appending data to a named region

Appending data to worksheets

Constructing Excel area references

Converting Excel cell references to row and column based cell referenc...

Class "cellstyle"

Clearing named regions in a workbook

Clearing cell ranges in a workbook

Clearing cell ranges in a workbook

Clearing worksheets in a workbook

Cloning/copying worksheets

Converting Excel column names to indices

Configuring Apache POI

Creating custom named and anonymous cell styles

Creating a freeze pane on a worksheet

Creating names in a workbook

Creating worksheets in a workbook

Creating a split pane on a worksheet

Converting Excel cell references to indices

Executing workbook methods in object$method(...) form

Retrieving named cell styles

Checking existence of named ranges in a workbook

Checking for existence of worksheets in a workbook

Workbook data extraction & replacement operators

Extracting the sheet name from a formula

Querying the active worksheet index

Querying the active worksheet name

Querying the coordinates of a worksheet bounding box

Retrieving formula definitions from cells

Retrieving named cell styles

Querying the cell style per data type for the DATATYPE style action

Retrieving defined names in a workbook

Querying the coordinates of the range reference by an Excel name

Querying the last (non-empty) column on a worksheet

Querying the last (non-empty) row on a worksheet

Retrieving or creating named cell styles

Querying the coordinates of the range reference by an Excel name

Querying the coordinates of the range reference by an Excel name

Querying the coordinates of the range of an Excel table

Querying reference formulas of Excel names

Querying worksheet position

Querying available worksheets in a workbook

Querying available Excel tables in a workbook

Hiding worksheets in a workbook

Converting row and column based area references to Excel area referenc...

Converting column indices to Excel column names

Converting indices to Excel cell references

Checking if worksheets are hidden in a workbook

Checking if worksheets are very hidden in a workbook

Checking if worksheets are visible in a workbook

Standard Java exception handling for XLConnect

Loading Microsoft Excel workbooks

Merging cells

Mirai Solutions GmbH

Data frame Normalization for Unit Tests

Behavior when error cells are detected

Print a workbook's filename

Reading named regions from a workbook

Reading named regions from an Excel file (wrapper function)

Reading Excel tables from a workbook

Reading data from worksheets

Reading data from worksheets in an Excel file (wrapper function)

Removing names from workbooks

Removing panes from worksheet

Removing worksheets from workbooks

Renaming worksheets from workbooks

Saving Microsoft Excel workbooks

Setting the active worksheet in a workbook

Setting auto-filters on worksheets

Specifying borders for cell styles

Setting cell formulas

Setting cell styles

Setting the cell style per data type for the DATATYPE style action

Setting the width of a column in a worksheet

Specifying custom data formats for cell styles

Setting the data format for the DATA_FORMAT_ONLY style action

Specifying the fill background color for cell styles

Specifying the fill foreground color for cell styles

Specifying the fill pattern for cell styles

Forcing Excel to recalculate formula values when opening a workbook

Setting hyperlinks

Setting missing value identifiers

Setting the height of a row in a worksheet

Setting colors on worksheet tabs

Setting worksheet position

Controlling application of cell styles when writing data to Excel

Setting the style name prefix for the "name prefix" style action

Specifying text wrapping behaviour

Display a workbook object

Summarizing workbook objects

Unhiding worksheets in a workbook

Unmerging cells

Evaluate an R expression in a workbook environment

Class "workbook"

Wrapping of arguments in a list

Writing named regions to a workbook

Writing named regions to an Excel file (wrapper function)

Writing data to worksheets

Writing data to worksheets in an Excel file (wrapper function)

XLConnect Constants

Automatic argument vectorization, default Java exception and warnings ...

Dumping data sets to Excel files

Editing data sets in an Excel file editor

Freeing Java Virtual Machine memory

Reporting free Java Virtual Machine memory

Deprecated functions in package XLConnect

Excel Connector for R

Performing general settings for XLConnect

Restoring objects from Excel files