Coerce coerce column to Excel Formula

as_excel_formula_column coerce a specified column into an Excel formula to be used in openxlsx::writeFormula() or openxlsx::writeData(). This transformation allows to avoid issue of Excel formula being interpreted as normal text by Excel.

Usage

as_excel_formula(col, array = FALSE)

Arguments

col

integer or character vector identifying the column to be coerced

array

A bool if the function written is of type array