Excel import: Identifying number of series
Posted: Mon Jun 10, 2013 1:39 am
by elias41
Hi,
What are the commands to count the number of imported time series from an excel file?
Best regards,
Elias
Re: Excel import: Identifying number of series
Posted: Mon Jun 10, 2013 8:21 am
by EViews Gareth
That's actually pretty tricky. If you're not doing a merged import (i.e. over-writing existing series), then something like:
Code: Select all
group g1 *
!countbefore = g1.@count
import myfile.xls
group g2 *
!countafter = g2.@count
!imported = !countafter - !countbefore
Re: Excel import: Identifying number of series
Posted: Mon Jun 10, 2013 8:36 am
by elias41
Many thanks.