wb_clean_sheet

Remove content of a worksheet completely, or a region if specifying <code>dims</code>.

Simplifies the creation of 'xlsx' files by
providing a high level interface to writing, styling and editing
worksheets.

Jan Marvin Garbuszus

openxlsx2

Read, Write and Edit 'xlsx' Files

Jordan Mark Barbone

Oliver Roy

 openxlsx authors

Arseny Kapoulkine

wb_clean_sheet function

<dl><dt>wb</dt>
<dd>A Workbook object</dd>
<dt>sheet</dt>
<dd>sheet to clean</dd>
<dt>dims</dt>
<dd>spreadsheet dimensions (optional)</dd>
<dt>numbers</dt>
<dd>remove all numbers</dd>
<dt>characters</dt>
<dd>remove all characters</dd>
<dt>styles</dt>
<dd>remove all styles</dd>
<dt>merged_cells</dt>
<dd>remove all merged_cells</dd></dl>

Arguments

Remove all values in a worksheet — wb_clean_sheet

<dl>

<dt>wb</dt>
<dd>A Workbook object</dd>


<dt>sheet</dt>
<dd>sheet to clean</dd>


<dt>dims</dt>
<dd>spreadsheet dimensions (optional)</dd>


<dt>numbers</dt>
<dd>remove all numbers</dd>


<dt>characters</dt>
<dd>remove all characters</dd>


<dt>styles</dt>
<dd>remove all styles</dd>


<dt>merged_cells</dt>
<dd>remove all merged_cells</dd>

</dl>

wb_clean_sheet: Remove all values in a worksheet

Description

Usage

Value

Arguments