ERROR: Couldn't find range or sheet in spreadsheet when xlsx engine was successfully assigned

[Li1]

Hello,

Has anyone met with this problem?  Libref xxx was successfully assigned with Engine XLSX. From the  explore window I could see the library xxx and the sheet, but got an error message "ERROR: Couldn't find range or sheet in spreadsheet" when referring to the sheet with xxx.sheet. 

Thanks,

Scarlett

[tarheel13]

we would need more information to be able to help you. show the full log or the code you're using. 

[Tom]

Be careful that you have actually pointed to an existing XLSX file and are not making a new file.

The LIBNAME statement has no way of knowing which you intended to do.  So if the filename you provided does not exist it makes a new, empty, file.

[Li1 · Accepted solution]

Thank you guys! I have solved the problem. The sheet name in the XLSX file had a trailing blank. When the blank is removed, xxx.sheet works.