Trouble when importing data: __xml_version__1_0__..
Posted: Wed Nov 06, 2013 7:14 am
by tvonbrasch
When opening the attached excel file in eviews, using the command wfopen(p=lp) "lp.xlsx" , a series named __xml_version__1_0__.. is created, and it cannot be renamed or deleted. It seems that there is a problem with loading the series named time.
Can you please explain what i am doing wrong.
Sincerely
Thomas von Brasch
Re: Trouble when importing data: __xml_version__1_0__..
Posted: Wed Nov 06, 2013 9:55 am
by EViews Jason
The series names in your excel file are actually on line 2. Cell B1 contains the string '__xml_version__1_0__..' which is why EViews is behaving the way it is. To prove this fact, if open the file in Excel, you will notice row 1 is missing. The row height for row #1 is actually 0. If you increase the height of that row, you will see cell B1 and the text ' __xml_version__1_0__..'.
You need to tell EViews the series names are in row #2. For this particular case I would use
Code: Select all
wfopen(p=lp) "lp.xlsx" namepos=last
Re: Trouble when importing data: __xml_version__1_0__..
Posted: Thu Nov 07, 2013 1:41 am
by tvonbrasch
Thank you very much Jason!
Thomas