how to import a serie from excel into an existing wrokfile
Posted: Thu May 12, 2016 6:28 am
I want to import a serie from an excel file which is called DM-INF into an existing workfile, how can I do it please?
I used the command capture and it gave me this command:
But when copying it in a program, all the part which comes after the single quotation (') is interpreted as a comment so it's not taken into account. How can I fix the problem please?
Thank you for your responses!
I used the command capture and it gave me this command:
Code: Select all
import "C:\Users\amel.laref\Desktop\Nouveau dossier\DM-INF.xlsx" range='Alger 2001'!$F$73:$FT$73 byrow colhead=0 namepos=all na="#N/A" names=(ipc) @freq M 2002M01 @smpl @all
Thank you for your responses!