Page 1 of 1
R or EViews? - Excel
Posted: Fri Jun 05, 2020 9:29 am
by startz
Wrote out an xlsx file from EViews. R won't load it, giving the following error message:
- Annotation 2020-06-05 092519.png (7.37 KiB) Viewed 18252 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.
Re: R or EViews? - Excel
Posted: Fri Jun 05, 2020 9:32 am
by EViews Gareth
Which R function/package were you using to open it?
Re: R or EViews? - Excel
Posted: Fri Jun 05, 2020 9:45 am
by startz
This happened both just clicking on the file in RStudio and saying import and using read_xlsx() from readxl::
Re: R or EViews? - Excel
Posted: Fri Jun 05, 2020 10:05 am
by EViews Jason
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.
Re: R or EViews? - Excel
Posted: Fri Jun 05, 2020 10:16 am
by startz
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?