Forum Discussion

LearningTC's avatar
LearningTC
Occasional Contributor
11 years ago

Data Loop - Not selecting Work sheet from Excel

Hi In keyword test,i'm trying to make a data loop. But the Data driven loop wizard is not displaying the excel worksheet. I've attached the screenshot. Please advice...
mes6073's avatar
mes6073
Contributor
11 years ago
Based on the last screen shot, I am going speculate that the OP is working with Excel 2013. For the OP, is it a requirement for this operation to be performed from the UI or can you leverage the Excel Application object to iterate the worksheet colleciton programatically?
Alain195's avatar
Alain195
New Contributor
11 years ago

Hi,

 

For information, I have exactly the same problem :( and I'm using the Office Professionnel Plus 2010.

So, there is nothing to do to solve this problem ?

 

Regards,

Alain

  • Marsha_R's avatar
    Marsha_R
    Icon for Champion Level 3 rankChampion Level 3
    11 years ago

    Try saving the Excel file as .xls instead of .xlsx - that fixed problems for us.

    • Alain195's avatar
      Alain195
      New Contributor
      11 years ago

      Thanks for the suggestion but unfortunately, it doesn't work.

      • Marsha_R's avatar
        Marsha_R
        Icon for Champion Level 3 rankChampion Level 3
        11 years ago

        I suggest putting in a support ticket so they can step through it with you.

  • vik33's avatar
    vik33
    Occasional Contributor
    11 years ago

    We too just used the extension .xls instead of .xlsx and on the machine where testcomplete is running, we don't even have Microsoft office installed but still it worked for us.