Learn R Programming

vanddraabe (version 1.1.1)

oxPlainDataSheet: Plain Data Sheet

Description

Constructs a plain Excel worksheet via the openxlsx package.

Usage

oxPlainDataSheet(wb.name, sheet.name = "basic", df)

Arguments

wb.name

Name of the workbook for the results; e.g., results.wb

sheet.name

Name of the worksheet being formatted; default: "basic"

df

data.frame containing the data to be written; e.g., df.results

Value

The workbook containing the indicated and newly formatted worksheet.

Details

This function creates a basic Excel worksheet with minimal formatting.

Notable formatting:

  • Top row frozen

  • Column widths are set based on column content

This openxlsx function is NOT exported.

See Also

Other "openxlsx functions": openxlsxCellStyles, oxAlignOverlapSheet, oxClusterStatsSheet, oxClusterSummarySheet, oxInitWaterDataSheet, oxPDBcleanedSummarySheet, oxRCSBinfoSheet, oxWaterOccurrenceSheet