I want to assign values in a table in my software, in first column i will give values, table is of 4x4 i.e 4 row and 4 columns, i m using VBScript in my automation work. it is a simple table for giving values.
Answer Posted / pravinkumar
Set exc=createobject("Excel.application")
set a=exc.Workbooks.Open("C:Documents and SettingspravinkumarmDesktopNew Folderpra.xls")
Set s=exc.Worksheets.Item ("sheet1")
exc.Cells(1,1)="Hello"
Exc.Cells(1,2)="Welcome"
Exc.Cells(2,1)="Hi"
Exc.Cells(2,2)="Jim"
exc.ActiveWorkbook.Save
'a.Save
exc.Quit
Set a=nothing
Set s=nothing
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
1 Folders in VSS 2 In navigation script there are 100 script i want to run first 50 and 37th script also not needed to run how to do this 3 What is navigation script,Driver script, business script what we are loaded in this script 4 use of resource tab 5 Difference between verification and validation give real scenario example 6 file scripting object when to use it 7 what are the problems you are faced while testing web application 8 difference between expert view and keyword view 9 difference between QTP 8.2 and QTP 9.2 navigation frame work please answer these questions from real time working people as early as possible
i am trying to automate yatra.com,in that site, when i go to automate the Leaving from field showing as a WEBEDIT, but when i enter 1 or 2 char, it displaying dropdownlist, i try to use keyboard automation to select the item from that list but it is not possible, can anybody help he. Thans for posting the Answer
1. What is the difference between Keyword and function in the keyword driven framework? 2. How do you associate Keywords to the script ?
What is output value? How many types of output values are there in qtp?
How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.
Explain process of smart Identification in QTP?
What is the script for database check point, bitmapchek point, regular expression ?
when u script reveiwing in which area u more concentrates?
What are the factors on which script execution time is dependent?
How to use output values in qtp ?
How do you convert manual test cases to automated test cases?
Explain actions in qtp ?
how can i call function (which has link with excell sheet at a remote location) within another function
Our company is having a windows client server application developed in vb.net. so there is a treeview and i am not in a position to record the click events in QTP. so kindly help. Vivek
What is the qtp testing process?