Crash when exporting empty group to Excel

For questions regarding programming in the EViews programming language.

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

JeffvdN
Posts: 22
Joined: Thu Aug 02, 2018 12:18 pm

Crash when exporting empty group to Excel

Postby JeffvdN » Mon Jul 11, 2022 1:29 pm

I run a big routine every week that involves a lot of exports to excel. I know this should be avoided but evidently there were some instances when it was trying to export empty groups using the wfsave command. It the past, it seemed to do it, exporting only the dates. Earlier this week, I applied the latest patch to Eviews 12 (July 6). Now the program crashes on these exports (closes Eviews, no error message). I am not sure if the patch changed the behavior but it seems like it may have. Is this possible?

I took out these unnecessary exports, and added some error checking before the wfsave commands to make sure the groups are not empty. That works for me. I just thought you might like to know about the crashing. It might be nice to trap the error before it crashes completely. With no error messages, it took me a while to find the problem.

Here is the code that crashes Eviews

'making sure the group does not exist
delete(noerr) NewGroup

'create empty group
group NewGroup
wfsave(type=excelxml, mode=update) ExcelFile.xlsx range="sheet1!c3" @keep NewGroup @smpl 1967m1 2022m66

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

Re: Crash when exporting empty group to Excel

Postby EViews Gareth » Mon Jul 11, 2022 1:40 pm

Confirmed, we'll fix.
Follow us on Twitter @IHSEViews


Return to “Programming”

Who is online

Users browsing this forum: Ahrefs [Bot] and 2 guests