How to get the value using header of table in excel file.

Hi,



When using Excel's Sheet.Cells API, you can't refer to the columns by headers. You can only use column indexes (1, 2 etc) or column letters (A, B etc).



However, if you read the file using TestComplete's DDT.ExcelDriver instead, you'll be able to use the column headers:

Call DDT.ExcelDriver("C:\OutputOrders.xlsx", "Sheet1", True)



While Not DDT.CurrentDriver.EOF

  fID = DDT.CurrentDriver.Value("ID")

  ' Do something with fID

  ...



  DDT.CurrentDriver.Next

WEnd

I am using DDT driver to get data from Excel sheet. I want to go to specified row( rowNo x ) in the sheet. How can I achieve this.

( I am using  Test Complete 8.6 )

Hi Uday,



Please find the answer in this thread:

http://www.sqaforums.com/showflat.php?Cat=0&Number=538262&Main=537923



For the future reference, we'd appreciate it if you started a new forum thread instead of posting to the existing threads. Keeping one thread per questions makes it quicker and easier for other people to find answers by browsing and searching for the forums. Thanks!

Thank you very much Helen.