The command used to retrieve data from excel sheet is

technology testing

  1. Set ab = Connection("srcfilepath ") , Set ws = ab.getdata(sheetid)

  2. Set ab = GetObject("srcfilepath ") , Set ws = ab.getsheet(sheetid)

  3. Set ab = CreateObject("srcfilepath ") , Set ws = ab.getsheet(sheetid)

  4. Set ab = GetObject("srcfilepath") , Set ws = ab.worksheets(sheetid)

Show answer
Correct Option: C

Find more quizzes: