R or EViews? - Excel

For making suggestions and/or requests for new features you'd like added to EViews.

Moderators: EViews Gareth, EViews Moderator

startz
Non-normality and collinearity are NOT problems!
Posts: 3573
Joined: Wed Sep 17, 2008 2:25 pm

R or EViews? - Excel

Postby startz » Fri Jun 05, 2020 9:29 am

Wrote out an xlsx file from EViews. R won't load it, giving the following error message:
Annotation 2020-06-05 092519.png
Annotation 2020-06-05 092519.png (7.37 KiB) Viewed 299 times


Don't know if the problem is R or EViews. I have attached the Excel file.

If I open and save the file in Excel, R then reads it in without fuss.
Attachments
ca disability.xlsx
(36.35 KiB) Downloaded 12 times

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

Re: R or EViews? - Excel

Postby EViews Gareth » Fri Jun 05, 2020 9:32 am

Which R function/package were you using to open it?
Follow us on Twitter @IHSEViews

startz
Non-normality and collinearity are NOT problems!
Posts: 3573
Joined: Wed Sep 17, 2008 2:25 pm

Re: R or EViews? - Excel

Postby startz » Fri Jun 05, 2020 9:45 am

This happened both just clicking on the file in RStudio and saying import and using read_xlsx() from readxl::

EViews Jason
EViews Developer
Posts: 784
Joined: Tue Sep 16, 2008 3:50 pm

Re: R or EViews? - Excel

Postby EViews Jason » Fri Jun 05, 2020 10:05 am

I know you have written other Excel files from within EViews. Does R seem to have problems with those as well? In other words, does R seem to have issue with all Excel files written by R or just this particular one?

I've examined the contents of your Excel file and the particular file 'xl/workbook.xml' R thinks is missing does in fact exist. So it's unclear as to the exact issue.

startz
Non-normality and collinearity are NOT problems!
Posts: 3573
Joined: Wed Sep 17, 2008 2:25 pm

Re: R or EViews? - Excel

Postby startz » Fri Jun 05, 2020 10:16 am

EViews Jason wrote:I know you have written other Excel files from within EViews. Does R seem to have problems with those as well? In other words, does R seem to have issue with all Excel files written by R or just this particular one?

R seems to work ok on others.

I've examined the contents of your Excel file and the particular file 'xl/workbook.xml' R thinks is missing does in fact exist. So it's unclear as to the exact issue.


If you open and save the Excel file, R will read the saved version. Can you look at both original and saved and see if there is a relevant difference?


Return to “Suggestions and Requests”

Who is online

Users browsing this forum: No registered users and 3 guests