Page 1 of 1

Header row in Excel file written by R

Posted: Tue Jan 28, 2025 10:21 am
by startz
Not clear this is exactly an EViews bug...but...

If you read in an Excel file using write_xlsx() EViews will not pick up the variable names in the header row. Quite possibly something not quite right at the R end.

Re: Header row in Excel file written by R

Posted: Tue Jan 28, 2025 10:31 am
by EViews Gareth
If you open the file in Excel, and then save it as a new .xlsx, does EViews open it fine? If so, its probably an issue in the .xlsx produced by R.

As an aside, I tend to use write.csv in R instead of xlsx. Seems to work better for me.

Re: Header row in Excel file written by R

Posted: Tue Jan 28, 2025 10:34 am
by startz
Yes. Suggesting R is doing something not quite standard. If it's easy to catch, would be nice if EViews handled it.