Skip to contents

MIGHT BE USED to format output of ejscreenapi module or server, preparing it for Excel

Usage

table_xls_format_api(
  df,
  hyperlink_cols = NULL,
  heatmap_colnames = NULL,
  heatmap_cuts = c(80, 90, 95),
  heatmap_colors = c("yellow", "orange", "red")
)

Arguments

df

data.frame, table of batch buffer results

vector of names of columns in df to get treated as hyperlinks in excel

heatmap_colnames

vector of names of columns in df to apply conditional formatting to, by coloring like a heatmap.

heatmap_cuts

vector of color names for heatmap bins, same length as heatmap_cuts, where first color is for those >= 1st cutpoint, but <2d, second color is for those >=2d cutpoint but <3d, etc.

heatmap_colors

vector of colors corresponding to cuts

Value

A workbook via openxlsx::writeData() ready to be saved via openxlsx::saveWorkbook()

Details

See newer EJAM code related to this – ejam2excel() and table_xls_format() etc.