Page 1 of 1

Import excel not reading full file

Posted: Fri Dec 22, 2023 8:39 am
by houji
Hi,

I'm trying to import an Excel file through drag and drop and the results differ whether I have the Excel workbook open or not.
When I have it closed, only 2 of the 11 series are loaded. When it's opened, all 11 series load fine.
eviews excel.png
loading via drag and drop
eviews excel.png (54.08 KiB) Viewed 48197 times
I also checked to see if I had saved the series in alphabetical order, and it seems that I have.
series order.png
ordering seems correct
series order.png (21.96 KiB) Viewed 48197 times
Grateful for any suggestions.

Merry Christmas and Happy Holidays.

Re: Import excel not reading full file

Posted: Fri Dec 22, 2023 10:07 am
by EViews Gareth
In the first screenshot, change the Range to custom:
Sheet1!A1:l253

Re: Import excel not reading full file

Posted: Fri Dec 29, 2023 1:22 pm
by houji
Thank you, that worked.