More than 256 columns
Posted: 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
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