topic Re: Error while importing excel file containing Japanese characters in the file name itself in SAS Programming

Error while importing excel file containing Japanese characters in the file name itself

sandeeppajni2 — Thu, 06 May 2021 11:27:03 GMT

Hi Folks,

I am currently investigating an issue that is happening for users when they are trying to do the PROC import with datafile parameter containing an excel file which has Japanese characters in its name.

We are using SAS 9.4M6 and have UTF8 as the SASApp workspace server.

ERROR: Error opening XLSX file -> /sas/....//<Japanese characters>.xlsx . It
is either not an Excel spreadsheet or it is damaged. Error code=8000100F
Requested Input File Is Invalid

Can someone please explain and suggest how to get rid of this?

Re: Error while importing excel file containing Japanese characters in the file name itself

AMSAS — Thu, 06 May 2021 13:52:30 GMT

Hi @sandeeppajni2

A couple of questions:

Does the Excel file open in Excel?
Does the Excel file import if you change the name of the file and remove the Japanese characters?

I want to know if it is the filename that is the issue, or the file itself.

If it is the filename that's the issue, I suggest opening a track with SAS Technical Support

Re: Error while importing excel file containing Japanese characters in the file name itself

sandeeppajni2 — Fri, 07 May 2021 17:14:08 GMT

Hi @AMSAS,

Yes, the file opens fine within Excel. It imports fine when we change the name to non-Japanese keywords. So, issue seems to be happening when we try to import the excel file with Japanese keywords in its name. We also tried to use fewer or other Japanese characters in the name, but it did not help.

I will raise a case with SAS Technical Support now.

Thanks!

Re: Error while importing excel file containing Japanese characters in the file name itself

Tom — Fri, 07 May 2021 18:42:55 GMT

Please let us know the answer. This question of utf-8 characters in filenames on Unix not working has come up before, but I could not generate a search term that would find the previous discussion to see if there was a recommended resolution.