formatXL_head: Save an Excel file with standard formatting for the header...

In shirewoman2/LaurasHelpers: Miscellaneous Helper Functions for Common PK or Analytical Chemistry Tasks

Save an Excel file with standard formatting for the header row

Description

This function saves a data.frame to an Excel file with the header row in bold face, centered both horizontally and vertically, and with wrapped text. It also sets the column widths to a reasonable guess based on the data you're writing. For more details, please see formatXL.

Usage

formatXL_head(DF, file, sheet = NA)

Arguments

DF	input data.frame
file	file name (character)
sheet	sheet name (character). Defaults to the name of the supplied data.frame if no other name is supplied.

Value

This does not return any R objects; instead, it saves an Excel file.

This does not return any R objects; it saves an Excel file.

Examples

data(iris)

formatXL_head(DF = iris, file = "test.xlsx", sheet = "iris1")

shirewoman2/LaurasHelpers documentation built on Oct. 22, 2023, 2:07 p.m.