Search found 4 matches

by acharyar
Wed Apr 17, 2019 12:13 pm
Forum: Programming
Topic: How to read data from Excel
Replies: 7
Views: 8150

Re: How to read data from Excel

I have multiple worksheets that I want Eviews to read in one file. Then I want to do vector and matrix manipulation prior to doing any analysis. So, I need Eviews command so that I transfer those excel file in Eview matrices so that I can perform manipulation of rows and columns and matrices. If I h...
by acharyar
Wed Apr 17, 2019 11:08 am
Forum: Programming
Topic: How to read data from Excel
Replies: 7
Views: 8150

Re: How to read data from Excel

I had already gone through the link you provided. But I could not follow it well. I am still trying it. In any case, I wonder why the program cannot be made friendly (and logical and well documented) to make Eviews read multiple excel worksheets with an easy command. I thought that should be the fir...
by acharyar
Thu Apr 11, 2019 8:04 am
Forum: Programming
Topic: How to read data from Excel
Replies: 7
Views: 8150

Re: How to read data from Excel

Thanks for the prompt response with help. But still have difficulty in reading the data. I have the following command. The objective is to read the data from "Input-Output Table.xlsx" and spreadsheet CAN (as I have other spreadsheets in that file). Since there are more rows and columns in ...
by acharyar
Wed Apr 10, 2019 10:47 am
Forum: Programming
Topic: How to read data from Excel
Replies: 7
Views: 8150

How to read data from Excel

When I save data into old excel format (with extension - xls) the following commands work. FOR %y CAN DNK FIN FRA GER IRL ITL NLD SPN SWE UK US matrix (29, 29) {%y} {%y}.read(b8, s = {%k}) "Input-Output Table.xls" BUT when I have these data with -xlsx extension, these command do not work. ...

Go to advanced search