EViews.com

Posted: **Tue Feb 04, 2025 10:30 am**

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


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.

Posted: **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

Posted: **Fri Feb 07, 2025 8:58 am**

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

Posted: **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).

EViews.com

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

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

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

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

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