Page 1 of 1

table.save as xlsx file not working in directories which names contain spaces

Posted: Tue Oct 31, 2023 3:32 am
by mamo
Dear Eviews team

I use Eviews 13 Okt 2022 build.

When trying to save a table object as an excel xlsx-file into a folder which name contains spaces, the following error message appears:
Syntax error: unexpected character '\' in file option settings.
(It is however possible to save a table as an csv file or as any other format to a folder which name contains spaces.)

See example code below.

Best, mamo

Code: Select all

%myfolder="c:\data\" 'Name of working directory, adjust as needed wfcreate u 1 1 table tab tab(1,1)="Hello" cd %myfolder cd A_new_folder ' A directory of this name should exist in the working directory tab.save tab.csv ' This works tab.save tab.xlsx ' This works cd %myfolder cd "A new folder" 'A directory of this name should exist in the working directory tab.save tab.csv ' This works tab.save tab.xlsx ' This does not work! Error message is "Syntax error: unexpected character '\' in file option settings."

Re: table.save as xlsx file not working in directories which names contain spaces

Posted: Tue Oct 31, 2023 9:25 am
by EViews Gareth
When you say 13 Okt 2022, do you mean 2023?

Re: table.save as xlsx file not working in directories which names contain spaces

Posted: Thu Nov 02, 2023 8:17 am
by mamo
Sorry, my error, it is Eviews 13, build 17 October 2022.
Best, mamo

Re: table.save as xlsx file not working in directories which names contain spaces

Posted: Thu Nov 02, 2023 8:28 am
by EViews Gareth
Could you update to the latest version?

Re: table.save as xlsx file not working in directories which names contain spaces

Posted: Fri Dec 08, 2023 8:38 am
by zezza
I have the same problem with Eviews 13 build Nov 28 2003.
When trying to save a table as an xlsx file in a folder which has spaces in the name, I get the error "File IO failed for file..."
If I save it as a CSV file I have no problems

Re: table.save as xlsx file not working in directories which names contain spaces

Posted: Fri Dec 08, 2023 1:19 pm
by EViews Gareth
Will fix next patch.