LVG77

# remove sheet protection in Excel
# Sample file: https://www.dropbox.com/s/4ul0kowrscyr8cz/excel_protected.xlsx?dl=0
 
library(stringr)
library(zip)

# file with protected sheets
file <- "data/excel_protected.xlsx"

# file name and path after removing protection

LVG77

let 
    List.RandomSelection = (sourceList as list) as text =>
        let
            Selection = sourceList{Number.RoundDown(Number.RandomBetween(0, List.Count(sourceList)))}
        in
            Selection,

    DefineDocs = [
        Documentation.Name =  " List.RandomSelection",
        Documentation.Description = " Randomly select a value from a list.",