Import of Excel files generated by R

[kganev]

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).

[EViews Jason]

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.

[kganev]

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