condformat2excel

Writes the table to an Excel workbook

Apply and visualize conditional formatting to data frames in R.
It renders a data frame with cells formatted according to
criteria defined by rules, using a tidy evaluation syntax. The table is
printed either opening a web browser or within the 'RStudio' viewer if
available. The conditional formatting rules allow to highlight cells
matching a condition or add a gradient background to a given column. This
package supports both 'HTML' and 'LaTeX' outputs in 'knitr' reports, and
exporting to an 'xlsx' file.

Sergio Oller Moreno

condformat

Conditional Formatting in Data Frames

condformat2excel function

<dl><dt>x</dt>
<dd>A condformat_tbl object</dd>
<dt>filename</dt>
<dd>The xlsx file name.</dd>
<dt>sheet_name</dt>
<dd>The name of the sheet where the table will be written</dd>
<dt>overwrite_wb</dt>
<dd>logical to overwrite the whole workbook file</dd>
<dt>overwrite_sheet</dt>
<dd>logical to overwrite the sheet</dd></dl>

Arguments

Writes the table to an Excel workbook — condformat2excel

<dl>

<dt>x</dt>
<dd>A condformat_tbl object</dd>


<dt>filename</dt>
<dd>The xlsx file name.</dd>


<dt>sheet_name</dt>
<dd>The name of the sheet where the table will be written</dd>


<dt>overwrite_wb</dt>
<dd>logical to overwrite the whole workbook file</dd>


<dt>overwrite_sheet</dt>
<dd>logical to overwrite the sheet</dd>

</dl>

condformat2excel: Writes the table to an Excel workbook

Description

Usage

Arguments