importtbl/importmat: bug when importing a "one-cell range" from excel
Posted: Thu Nov 09, 2017 5:47 am
Dear Eviews team,
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
imports the whole range right of and below the cell Sheet1!C9 into the table testable, whereas
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
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