Learn R Programming

openxlsx2 (version 0.6.1)

cleanup: clean sheet (remove all values)

Description

clean sheet (remove all values)

Usage

wb_clean_sheet(
  wb,
  sheet = current_sheet(),
  dims = NULL,
  numbers = TRUE,
  characters = TRUE,
  styles = TRUE,
  merged_cells = TRUE
)

delete_data(wb, sheet, cols, rows)

Arguments

wb

workbook

sheet

sheet to clean

dims

spreadsheet dimensions (optional)

numbers

remove all numbers

characters

remove all characters

styles

remove all styles

merged_cells

remove all merged_cells

cols

numeric column vector

rows

numeric row vector