EViews.com

Dear all,

I am trying to import in EViews (versions 9.5 and 10+) Excel files that are generated using R packages such as openxlsx and writexl. The files are seamlessly opened in MS Excel 2013 and 2016 but cannot be imported using the import command. I am attaching an example xlsx file here.
What I was able to see was that the xml files that underlie the xlsx's are different from the ones generated by MS Excel itself.
I would be grateful for a solution (different from re-saving the files in Excel or using csv).

The xlsx file is missing the 'spans=' attribute for each row. Without the 'spans' attribute, EViews cannot tell (without great difficulty) how many columns are in a row.

You can either re-save the Excel file (which you've already mentioned you don't want to do) or ask the authors of writexl to add the 'spans' attribute to the row specification.

Thank you for your reply. I will write to the package authors.