Forum Discussion

vantaku01's avatar
vantaku01
Occasional Contributor
2 years ago

TestComplete working with excel data

Hi Everyone,

 

While working with excel data can we treat particular row data as coloumn Names. Instead of treat first row as coloumn names as shown figure.

 

My coloumn names are starting after few rows. 

 

Thank you so much.

2 Replies

  • rraghvani's avatar
    rraghvani
    Champion Level 3

    The normal format is to either have the first row with names or data values. I don't think the Excel import allows to start at a different row either?

     

    If you want to start at a different row, then you will need to implement your own function to read your spreadsheet

  • Marsha_R's avatar
    Marsha_R
    Champion Level 3

    Is there some reason that you can't re-sort the data so the column names are at the top? Why do they need to be in the middle?