Create list from tabs of spreadsheet (*xlsx) — xlsx2list • sdtmchecks

This creates a list based on the sdtmchecks_yyyy-mm-dd.xlsx file, such as report created via report_to_xlsx()

xlsx2list(rptwb, firstrow = 1)

Arguments

rptwb: List of check results in newer report read in via openxlsx::loadWorkbook
firstrow: Row input for startRow parameter of openxlsx::read.xlsx, default is 1

Value

list named xlsxfile

See also

Reporting-related utility functions convert_var_to_ascii(), create_R_script(), truncate_var_strings()

Examples


if (FALSE) {

library(openxlsx)

rptfile <- "Downloads/sdtmchecks_GO12345_2021-03-12.xlsx"
rptwb <- openxlsx::loadWorkbook(rptfile)
names(rptwb)
rptwb

xlsx2list(rptwb=rptwb, firstrow=1)

}