Issue with table.save to XLSX files (EViews 13 on Windows)

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

madm
Posts: 22
Joined: Mon Oct 23, 2017 1:13 pm

Issue with table.save to XLSX files (EViews 13 on Windows)

Postby madm » Tue Feb 04, 2025 10:30 am

A simple replication of the issue we're seeing is below:

Code: Select all

wfcreate q 1990 2030 series A = 1 series B = 2 group ab A B freeze(test) ab.sheet test.save test_data.csv test.save test_data.xlsx
The problem, which appears intermittently, is that the XLSX file that EViews generates will have a random number of empty rows inserted at the top (usually 1 or 2). This appears more likely to occur once we've interacted with EViews and Excel for some time in the current machine session. Could someone let me know if they can replicate the issue on their side? This is breaking a workflow for us.

madm
Posts: 22
Joined: Mon Oct 23, 2017 1:13 pm

Re: Issue with table.save to XLSX files (EViews 13 on Windows)

Postby madm » Tue Feb 04, 2025 2:32 pm

Ah, I should have checked. Seems that someone has already reported the same issue: viewtopic.php?t=21881

EViews Steve
EViews Developer
Posts: 834
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Issue with table.save to XLSX files (EViews 13 on Windows)

Postby EViews Steve » Fri Feb 07, 2025 8:58 am

This should now be fixed in latest 13 & 14 patches dated Feb 6, 2025.

madm
Posts: 22
Joined: Mon Oct 23, 2017 1:13 pm

Re: Issue with table.save to XLSX files (EViews 13 on Windows)

Postby madm » Fri Feb 14, 2025 11:50 am

This should now be fixed in latest 13 & 14 patches dated Feb 6, 2025.
Ah, many thanks Steve!

Btw, a separate issue with the piece of code sample above is that

Code: Select all

freeze group_object.sheet
will break unpredictably (and without warning from EViews) by not writing out all columns if group_object is too big (5000-6000 vars in our case).


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 2 guests