More than 256 columns

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

PacNW
Posts: 21
Joined: Fri Apr 01, 2011 4:31 pm

More than 256 columns

Postby PacNW » Thu Apr 07, 2011 9:10 am

I am working with about 300 series. The input files are xlsx files (with 300 columns) and are being read in correctly using wfcreate.

After the EViews program ends, I would like to export the adjusted series to a similar format, i.e. 300 columns,

Using the write command with excel, the program runs into an error of too many columns (Excel 2003-2007 constraint). When I try to export using an xlsx file, the file is unopenable. I am guessing because EViews does not support writing Excel 2010 files.

Is there an efficient way around this issue? I can simply export to two files and join them in excel, but I thought I would see if there is any other way to deal with this.

Thanks

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

Re: More than 256 columns

Postby EViews Gareth » Thu Apr 07, 2011 9:12 am

Save it as a csv file.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 1 guest