Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can we open an Excel sheet through the script

Answer Posted / bhaskar pothuri

This question is related to automation. As an example we
can open an excel sheet in QTP using the library functions
available in the VB scripting.

Is This Answer Correct ?    9 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HI I want to know the detials of QTP certifications such as syllabus, study Materil etc. Can any provide me all these details?? my mail ID is krishnuvk@yahoo.com

1975


what r the main attributes of test automation?

1979


Explain the qtp test phases.

993


Hi Guys, I want to place all of my values which i am getting it from a loop in to a global shee. For that i had written the script like this For i = 1 to ECOs-1 ECO = List(i).GetROProperty("innertext") DataTable.AddSheet("ECOList") DataTable.GetSheet("ECOList").AddParameter "ECOList",ECO AbortECO = DataTable.GetSheet("ECOList").GetParameter ("ECOList").Value msgbox AbortECO DataTable.GetSheet("ECOList").SetNextRow Using the above script, whenever the loop iterates it is creating new column "ECOLIST" in the sheet called "ECOLIST". It means, the values are displaying in the column wise even though i added the script " DataTable.GetSheet("ECOList").SetNextRow" . The cursor is not moving to the next line. Anybody help me out how to pass the values from script to the excel(Global/Local) sheet. Pls let me know @ nbabu11@gmail.com if you are not clear about the question.

1854


In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?

1880


What are the different attributes used with regular expression?

957


Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.

2104


How to handle the exceptions using recovery secnario manager in quicktest professional (qtp)?

1003


What are the benefits of qtp?

1056


How do you delete unwanted results in qtp?

1071


In qtp, explain what is crypt object

981


what difference between runtime object and text object and what property they have. whether they have same properties or different properties.

2134


I have 5 save buttons in 5 tabs . The tabs are placed one after the other. My object repository have these added as 5 save buttons with name sav1, save 2, save 3 , save 4, save 5 .all are getting highlighted from OR but they are not getting clicked. After spying each button all the properties are same except First button Index 0 html id:=btnSaveTab1 outerhtml:=", Second button "html id:=btnSave "outerhtml:=", Third button "html id:=", outerhtml:=",

1829


how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods

1867


How many add-ins comes by default with qtp?

969