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

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

mamo
Posts: 189
Joined: Wed Nov 07, 2012 9:11 am

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

Postby mamo » Tue Oct 31, 2023 3:32 am

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."

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13284
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Tue Oct 31, 2023 9:25 am

When you say 13 Okt 2022, do you mean 2023?
Follow us on Twitter @IHSEViews

mamo
Posts: 189
Joined: Wed Nov 07, 2012 9:11 am

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

Postby mamo » Thu Nov 02, 2023 8:17 am

Sorry, my error, it is Eviews 13, build 17 October 2022.
Best, mamo

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13284
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Thu Nov 02, 2023 8:28 am

Could you update to the latest version?
Follow us on Twitter @IHSEViews

zezza
Posts: 23
Joined: Fri May 28, 2010 5:27 am

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

Postby zezza » Fri Dec 08, 2023 8:38 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13284
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Fri Dec 08, 2023 1:19 pm

Will fix next patch.
Follow us on Twitter @IHSEViews


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 6 guests