Using excel sheet as database table
Excel sheet can be used as a database for the parameterization purpose. Following code demonstrate how to connect and consider […]
Excel - usefull scripts, Using excel sheet as database table
Excel – usefull scripts
Excel - usefull scripts
Working with Excel Sheets – create, open, modify, save, close!!
‘Getting value from an existing excel sheet Dim oExcel, oWB, oSheet, getVal Set oExcel=CreateObject(“Excel.Application”) Set oWB=oExcel.Workbooks.Open(“C:abhikansh.xls”) Set oSheet=oWB.WorkSheets(“Sheet1”) oExcel.Visible=TRUE getVal=oSheet.Cells(1,1).Value
Excel - usefull scripts
Count number of rows in Excel without opening it.
‘Following code demonstrate how to count number of rows in Excel without opening it – using vbscipt in QTP. Set