EViews.com

It seems that Eviews 8 cannot import .xlsx files.
If this statement is incorrect, how do you import such files?

EViews 8 can handle .xlsx files just fine. Both the WFOPEN and IMPORT commands should recognise the type automatically.

This file can be imported (.xls):
read(e,b10,s=ip_cpi_un) database_monthly_lastfriday.xls EA_IP US_IP EA_CPI US_CPI EA_UR US_UR EA_loans_hh EA_loans_nfcs

This one does not works (.xlsx):
read(e,b10,s=ip_cpi_un) database_monthly_lastfriday.xlsx EA_IP US_IP EA_CPI US_CPI EA_UR US_UR EA_loans_hh EA_loans_nfcs

It is the same file, just the extensions is different. Any reason?

Yes, you aren't using the WFOPEN or IMPORT commands.

The READ command was discontinued in EViews 4 (way before .xlsx was invented).

Unfortunately I could not find the answer in the Command and Programming Reference.

This does not work:
wfopen(e,b10,s=ip_cpi_un) database_monthly_lastfriday.xlsx EA_IP US_IP EA_CPI US_CPI EA_UR US_UR EA_loans_hh EA_loans_nfcs

I need to get the data from cell "b10" in worksheet "ip_cpi_un"

Thanks for your help

What happens if you just try:

In the same file, I have many worksheet.
When I do what you suggest, I get one variable with a time series and other variables with strange names and with a sample size from 1 to 205

You probably need to use the range= argument then to specify which sheet you want.

It would be very useful if Eviews could validate the read command also for .xlxs files.
Is one useful value added compared to STATA and RATZ.

The Import and wfopen commands do everything that Read does, and much much more.

Can you please make me an example of uploading three time series X Y Z from cell B10 in a worksheet titled "Data" which is in a file titled example.xlxs?

Many thanks.

This imports all the worsheet "Data" and not X Y Z.
Immagine I have 100 time series and I want to import only X Y Z starting from cell B10