Trouble when importing data: __xml_version__1_0__..

[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

[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

[tvonbrasch]

Thank you very much Jason!
Thomas