Skip to contents

Set openxlsx style for comparisons and ANOVA table

Usage

printxlsxDataSheet(
  wb,
  data,
  FCcol,
  pvalcol,
  tabName = "results",
  hicutoff = 1.5,
  lowcutoff = 0.67,
  pvalcutoff = 0.05,
  protect = FALSE,
  pokemonGO = FALSE
)

Arguments

wb

Keep the same workbook to maintain the styles

data

If more than sheet to be added, needs to be in for loop

FCcol

Column index for Fold Change values

pvalcol

Column index for pvalues

tabName

Tab name, specify each time to avoid overwriting previous tabs

hicutoff

Default 1.5

lowcutoff

Default 0.67

pvalcutoff

Default 0.05

protect

Should this sheet be protected from editing by the user?

pokemonGO

to colour the GO terms based on a random Pokemon. Like we're back in the craze of 2016.