R Under development (unstable) (2024-05-29 r86642 ucrt) -- "Unsuffered Consequences"
Copyright (C) 2024 The R Foundation for Statistical Computing
Platform: x86_64-w64-mingw32/x64

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

> library(SheetReader)
> options(stringsAsFactors = FALSE)
> data <- read_xlsx(system.file("extdata", "multi-test.xlsx", package = "SheetReader"), sheet="escape")
> stopifnot(colnames(data) == c("Escape", "This"))
> stopifnot(data[1, "This"] == "&")
> stopifnot(data[2, "This"] == "") # single apostrophe gets interpreted as empty by excel for some reason
> stopifnot(data[3, "This"] == "\"")
> stopifnot(data[4, "This"] == ">")
> stopifnot(data[5, "This"] == "<")
> stopifnot(data[6, "This"] == "What is < than \"\" & '>'")
> 
> proc.time()
   user  system elapsed 
   0.21    0.01    0.25