I have an alternative solution.
Try doing this.
use datatable.importsheet "<Path of xlx file> and then
count number of rows of the data table
Try doing this.
use datatable.importsheet "<Path of xlx file> and then
count number of rows of the data table