EViews.com

Posted: **Thu Sep 05, 2013 2:45 pm**

Hi !

I am trying to export sevral series that I grouped to the same Excel sheet but there is an error message that tells me that table "quarterly!ME6" does not exist. Is it because eviews cannot export to excel after column IV ?

Here is the code I use. Please let me know how I can export all that series to the same excel sheet

'Exporting quarterly_data to Chronologis_réelles.xlsx
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!B6" @keep PRO_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!AG6" @keep GAT_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!BL6" @keep MTL_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!IP6" @keep QUE_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!ME6" @keep SAG_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!NJ6" @keep SHE_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!OO6" @keep TRS_Reelles_Quarterly

Posted: **Thu Sep 05, 2013 2:58 pm**

I cannot replicate what you are seeing. I created a file called "Chronologis_reelles.xlsm" in c:\temp, then ran the following code:

Code: Select all


create q 1990 2000
series pro_reelles_quarterly = rnd
series gat_reelles_quarterly = rnd
series mtl_reelles_quarterly = rnd
series que_reelles_quarterly = rnd
series sag_reelles_quarterly = rnd
series she_reelles_quarterly = rnd
series trs_reelles_quarterly=rnd

pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!B6" @keep PRO_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!AG6" @keep GAT_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!BL6" @keep MTL_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!IP6" @keep QUE_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!ME6" @keep SAG_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!NJ6" @keep SHE_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!OO6" @keep TRS_Reelles_Quarterly

And it worked perfectly.

Posted: **Fri Sep 06, 2013 6:58 am**

Thanks for the quick reply.

I think my problem is that the group I want to export contains 435 series with monthly observations starting in 2002 that I want to export on the same excel sheet. Here is a little bit more of the code that I have before saving to the excel file:

wfselect actual_data_monthly
'Province
group Reelles_Monthly PRO00VENRES_MR PRO00VENUNI_MR .... (and the all the other series in the group, 435 in total)

'Exporting monthly_data to Chronologis_réelles.xlsx
pagesave(t=excelxml, mode=update) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="monthly!A6" @keep reelles_monthly

Still it doesn't work and I have the error message I attached in the doc file.

EViews.com

Exporting after cell IV in Excel

Exporting after cell IV in Excel

Re: Exporting after cell IV in Excel

Re: Exporting after cell IV in Excel