Export data to existing excel file
Moderators: EViews Gareth, EViews Moderator
-
- Posts: 160
- Joined: Thu Mar 03, 2011 10:07 pm
- Contact:
Export data to existing excel file
Hi
At our institute (NIER, http://www.konj.se) we are now changing from Aremos to Eviews for calculations of macroeconomic forecasts. Very often we combine heavier computation with excel files that sometimes are a better interface. We have therefore a great need to export data to existing excel files.
As we have noted previously it works fine to load data into existing excel file via VBA. But it requires a relatively good knowledge of VBA coding.
As an alternative, it would be highly desirable to be able to export data directly from a workfile to an existing Excel file via code in Eviews.
Are there any plans for this? Thanks in advance.
Johan
At our institute (NIER, http://www.konj.se) we are now changing from Aremos to Eviews for calculations of macroeconomic forecasts. Very often we combine heavier computation with excel files that sometimes are a better interface. We have therefore a great need to export data to existing excel files.
As we have noted previously it works fine to load data into existing excel file via VBA. But it requires a relatively good knowledge of VBA coding.
As an alternative, it would be highly desirable to be able to export data directly from a workfile to an existing Excel file via code in Eviews.
Are there any plans for this? Thanks in advance.
Johan
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Export data to existing excel file
It is extremely high up our list.
Follow us on Twitter @IHSEViews
-
- Posts: 160
- Joined: Thu Mar 03, 2011 10:07 pm
- Contact:
-
- Posts: 160
- Joined: Thu Mar 03, 2011 10:07 pm
- Contact:
Re: Export data to existing excel file
EViews Gareth wrote:It is extremely high up our list.
What about this issue?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Export data to existing excel file
It is still extremely high on our list, and should be implemented in the next version of EViews.
Follow us on Twitter @IHSEViews
Re: Export data to existing excel file
Do you by "next version" mean EViews 7.3 or EViews 8?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
-
- Posts: 4
- Joined: Thu Feb 21, 2013 1:18 pm
Re: Export data to existing excel file
Is that already possible on Eviews 8 Beta?
Thanks
Thanks
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Export data to existing excel file
Using EViews 8 Beta, I am trying to export data from a workfile to an exisiting Excel file using the following commands:
However when I run it I am getting an Error Message that says:
Syntax error: unexpected character '.' in file option settings in "WFSAVE(TYPE=EXCELXML, MODE=UPDATE) RANGE="SHEET1!D54" BYROW POPM.XLSM @KEEP P0TO4MZ1M"
Any idea why this may be happening?
Code: Select all
for %a 0to4 5to9 10to14 15to19 20to24 25to29 30to34 35to39 40to44 45to49 50to54 55to59 60to64 65to69 70to74 75to79 80to84 85to89 90plus
wfsave(type=excelxml, mode=update) range="Sheet1!d54" byrow popm.xlsm @keep p{%a}mz1m
next
However when I run it I am getting an Error Message that says:
Syntax error: unexpected character '.' in file option settings in "WFSAVE(TYPE=EXCELXML, MODE=UPDATE) RANGE="SHEET1!D54" BYROW POPM.XLSM @KEEP P0TO4MZ1M"
Any idea why this may be happening?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Export data to existing excel file
Excel file name goes before the Range= statement.
Follow us on Twitter @IHSEViews
Re: Export data to existing excel file
Ok thanks. But just so you guys are aware, in the EViews 8 Beta Documentation examples under "wfsave", it is the other way around. The example is provided like this:
Code: Select all
wfsave(type=excelxml, mode=update) range=”Sheet2!a1” byrow
macro.xlsm @keep gdp unemp
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Export data to existing excel file
Yep, that's a mistake. I'll make sure it gets fixed.
Follow us on Twitter @IHSEViews
Re: Export data to existing excel file
Please note that the example provided by davey87 was not updated in the documentation that comes with EViews 8. Is it possible for you to update it in when you release patches?
Return to “Suggestions and Requests”
Who is online
Users browsing this forum: No registered users and 29 guests