Question: how to read data from excel sheet in testcomplete?
Answer: Using TestComplete in-build function DDT. ... 
Using ADODB for excel - This is preferred option for most of the pro users as you will be able to filer the data directly from Excel using ADODB query and if you are familiar with SQL basic query then that will make more easy to create.