search

ycphs / openxlsx

openxlsx - a fast way to read and write complex xslx files
https://ycphs.github.io/openxlsx/
Other
220 stars 73 forks source link

Ampersand in sheet name causes corruption #452

Open cetp opened 9 months ago

cetp commented 9 months ago

Thanks for your great work on this package. I've found it incredibly useful. best wishes, --tim

Issue A worksheet read into R using loadWorkbook() will be corrupt if the sheet name contains an ampersand (&)

To Reproduce library(openxlsx) template_files <- "Corruption test.xlsx" dest.r <- loadWorkbook(template_files) openXL(dest.r)

Example files See attached Corruption test.xlsx Corruption test.xlsx