colNames=TRUE,detectDates=TRUE)
The code produced an error as below. Please advice. Version of openlsx is 4.1.4
Error in read.xlsx.default("//sngji-fs-02/Traders/DailyReport/20141017 Singapore Supply Database.xlsm", :
Length of worksheet is 0 - something has gone terribly wrong! Please report this bug on github (https://github.com/awalker89/openxlsx/issues) with an example xlsx file.
In addition: Warning message:
In unzip(xlsxFile, exdir = xmlDir) :
write error in extracting from zip file
Expected Behavior
Usually the code works perfectly with the data being read with the code below
Actual Behavior
A=read.xlsx("//sngji-fs-02/Traders/DailyReport/20141017 Singapore Supply Database.xlsm",sheet="2018",startRow=10,
Steps to Reproduce the Problem
(please attach an example xlsx file if possible)
1.
2.
3.
sessionInfo()