I just need to open one excel file and read data from it using codeception. is it possible ?
Codeception has no such functionality built-in.You have to find a PHP library which can read excel files and create a helper class for analyzing file contents.
I used this one module - https://github.com/PHPOffice/PHPExcel
PHPExcel will be archived soon, better to use https://github.com/PHPOffice/PhpSpreadsheet