Import excel not reading full file

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

houji
Posts: 11
Joined: Mon Mar 20, 2023 3:19 pm

Import excel not reading full file

Postby houji » Fri Dec 22, 2023 8:39 am

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 24269 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 24269 times


Grateful for any suggestions.

Merry Christmas and Happy Holidays.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13323
Joined: Tue Sep 16, 2008 5:38 pm

Re: Import excel not reading full file

Postby EViews Gareth » Fri Dec 22, 2023 10:07 am

In the first screenshot, change the Range to custom:
Sheet1!A1:l253
Follow us on Twitter @IHSEViews

houji
Posts: 11
Joined: Mon Mar 20, 2023 3:19 pm

Re: Import excel not reading full file

Postby houji » Fri Dec 29, 2023 1:22 pm

Thank you, that worked.


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 8 guests