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
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
R or EViews? - Excel
- Attachments
-
- ca disability.xlsx
- (36.35 KiB) Downloaded 341 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: R or EViews? - Excel
Which R function/package were you using to open it?
Follow us on Twitter @IHSEViews
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- 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 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.
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: R or EViews? - Excel
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 37 guests