wfsave does not correctly update .xlsx files

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

kuku
Posts: 4
Joined: Thu Nov 30, 2017 5:18 am

wfsave does not correctly update .xlsx files

Postby kuku » Fri Dec 01, 2017 12:03 am

Hello!
I have Eviews 9.5 May 1 2017 build, Excel 2010. I want to export a number of series to Excel file (.xlsx). I usually arrange my series by rows - each series has a different row. But for some reason wfsave can't correctly update my Excel file if the series length is bigger that 256 (with series name). If I create a new Excel file with wfsave everything works fine.

wfsave(type=excelxml,noid) "export.xlsx" range=data!a1 byrow
Creates new Excel file, works fine.

wfsave(type=excelxml,noid,mode=update) "export.xlsx" range=data!a1 byrow
Updates existing file, but populates columns only from A to IV even if my series is longer.

I attached the dataset, the program and Excel file.
Attachments
export.xlsx
(14.56 KiB) Downloaded 268 times
data.wf1
(32.03 KiB) Downloaded 300 times
data.prg
(138 Bytes) Downloaded 287 times

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

Re: wfsave does not correctly update .xlsx files

Postby EViews Gareth » Fri Dec 01, 2017 8:52 am

Works for me on 9.5 and 10. You might want to update your 9.5 to the latest version.
Follow us on Twitter @IHSEViews

kuku
Posts: 4
Joined: Thu Nov 30, 2017 5:18 am

Re: wfsave does not correctly update .xlsx files

Postby kuku » Mon Dec 04, 2017 12:18 am

Are you sure? I updated Eviews 9.5 to Oct 5 2017 build, but the final Excel file is the same: rows from 1 to 3 are ok (columns from A to ZZ), but rows from 5 to 7 are short (only from A to IV). So update didn't help me.

kuku
Posts: 4
Joined: Thu Nov 30, 2017 5:18 am

Re: wfsave does not correctly update .xlsx files

Postby kuku » Tue Dec 12, 2017 2:33 am

So, what is the solution to my problem?

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: wfsave does not correctly update .xlsx files

Postby EViews Jason » Tue Dec 12, 2017 10:04 am

What version of Excel are you using?

Is excel running at the time you run your EViews program?

Please try running your EViews program but shut down any or all copies of Excel. Did this make a difference?

If you remove the 'byrow' option, does all the data appear?

kuku
Posts: 4
Joined: Thu Nov 30, 2017 5:18 am

Re: wfsave does not correctly update .xlsx files

Postby kuku » Thu Dec 14, 2017 2:42 am

I use Excel 2010.

It does not matter whether Excel is running or not, the outcome is the same.

If I remove 'byrow' everything works fine.

Personally, I think that the problem is with ".xlsx" and ".xls" Excel formats. I think so because wfsave populates only columns from A to IV: as far as I remember IV is the last column in ".xls" files.

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: wfsave does not correctly update .xlsx files

Postby EViews Jason » Mon Dec 18, 2017 10:18 am

Can you verify if your copy of Excel 2010 is up to date?

Open any Office 2010 application, such as Word 2010 and create a document.

Go to File > Help > Check for Updates.

Choose Install Updates or Check for Updates. If neither option is available, follow the additional steps provided in the pop-up window that appeared after you chose Check for Updates.



Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 8 guests