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

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

Li1 — Tue, 01 Mar 2022 18:37:18 GMT

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

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

tarheel13 — Tue, 01 Mar 2022 18:41:19 GMT

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

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

Tom — Tue, 01 Mar 2022 18:41:39 GMT

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.

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

Li1 — Tue, 01 Mar 2022 19:09:42 GMT

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.