Wrote out an xlsx file from EViews. R won't load it, giving the following error message:
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.
R or EViews? - Excel
Moderators: EViews Gareth, EViews Moderator
-
startz
- Non-normality and collinearity are NOT problems!
- Posts: 3798
- Joined: Wed Sep 17, 2008 2:25 pm
R or EViews? - Excel
- Attachments
-
- ca disability.xlsx
- (36.35 KiB) Downloaded 822 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: R or EViews? - Excel
Which R function/package were you using to open it?
-
startz
- Non-normality and collinearity are NOT problems!
- Posts: 3798
- Joined: Wed Sep 17, 2008 2:25 pm
Re: R or EViews? - Excel
This happened both just clicking on the file in RStudio and saying import and using read_xlsx() from readxl::
-
EViews Jason
- EViews Developer
- Posts: 870
- Joined: Tue Sep 16, 2008 3:50 pm
Re: R or EViews? - Excel
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.
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: 3798
- Joined: Wed Sep 17, 2008 2:25 pm
Re: R or EViews? - Excel
R seems to work ok on others.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?
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?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.
Return to “Suggestions and Requests”
Who is online
Users browsing this forum: No registered users and 1 guest
