Header row in Excel file written by R

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

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

Header row in Excel file written by R

Postby startz » Tue Jan 28, 2025 10:21 am

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.

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

Re: Header row in Excel file written by R

Postby EViews Gareth » Tue Jan 28, 2025 10:31 am

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.

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

Re: Header row in Excel file written by R

Postby startz » Tue Jan 28, 2025 10:34 am

Yes. Suggesting R is doing something not quite standard. If it's easy to catch, would be nice if EViews handled it.


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 2 guests