### 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