cleanup

wb_clean_sheet

delete_data

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

 openxlsx authors

Arseny Kapoulkine

cleanup function

<dl><dt>wb</dt>
<dd>workbook</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>
<dt>cols</dt>
<dd>numeric column vector</dd>
<dt>rows</dt>
<dd>numeric row vector</dd></dl>

Arguments

clean sheet (remove all values) — cleanup

<dl>

<dt>wb</dt>
<dd>workbook</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>


<dt>cols</dt>
<dd>numeric column vector</dd>


<dt>rows</dt>
<dd>numeric row vector</dd>

</dl>

clean sheet (remove all values)

cleanup: clean sheet (remove all values)

Description

Usage

Arguments