Writing onto xlsx

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

osindi
Posts: 12
Joined: Thu Mar 05, 2015 4:44 am

Writing onto xlsx

Postby osindi » Fri Mar 06, 2015 8:05 am

Hi,

I'm sure this is a simple problem, but I can't find out why it's not working.
In Eviews 8, I'm trying to write to an xlsx file. I've tried various commands both using write and pagesave.
The code seems to workfine, but I can't then open the xlsx file.

I keep getting the following error:

Excel cannot open the file "Test.xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matched the format of the file.

I used the code:

Code: Select all

write(t=excelxml) Test.xlsx ser1
among various other variations.

Thanks

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

Re: Writing onto xlsx

Postby EViews Gareth » Fri Mar 06, 2015 8:52 am

The write command doesn't support xlsx. You'll have to use wfsave or pagesave instead.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests