I use Eviews 9.5, 27 December 16 build
I found a bug when importing a range covering only one cell in an excel file into a matrix or a table.
For instance, the command
Code: Select all
importtbl(name=testtable, mode=overwrite) "MyExcelFile.xlsx" range="Sheet1!$C$9:$C$9"
imports the whole range right of and below the cell Sheet1!C9 into the table testable, whereas
Code: Select all
importmat(name=testmat, mode=overwrite) "MyExcelFile.xlsx" range="Sheet1!$C$9:$C$9"
imports all the rows below the cell Sheet1!C9 into the matrix testmat.
Same results obtain with the range specification range="Sheet1!$C$99"
Best, mamo