Forum Discussion

windend's avatar
windend
Occasional Contributor
13 years ago

How to resolve retrieving data from Excel file slowly.

hi,



we are building a framework on TestComplete. The scripting launguae is VBs. All the test data and test action words are stored in excel. And we using DDT.ExcelDriver or Sys.OleObject("Excel.Application") to initiate an excel app object, then read test data and control process from excel file.



The issue we are facing is that the speed to read data from excel is too slow. Are there any approaches to resolve this kind of issue? To retrieve data from excel get more quicker in TestComplete?



Thank you.

1 Reply

  • Probably reading the whole sheet in one go would help

    e.g. usedrange method gives the complete sheet data in a 2 dimensional array