Hi every body, I am new to QTP.pls help me if anybody knows
the solution.
Here is my doubt:
I have 3 excel sheets in my local drive out of which one is
password protected and i want to get the data of all these
xL's either by importing or by reading the data finally i
have to update this data in the website.(and the site is
secured site)

I tried by importing all XL"s one by one but couldn't do so.
plss send me the code or atleast suggest me the approach.
Thanks in Advance
Padmaja

Answer Posted / nani

Hi,
As per my knowledge.

generally you will know how to import the data from excel
sheet to web application right.
and you are saying one is password protected one so do one
thing for that one
you can write a script and give tha password then in the
general way you can import the data.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any pdf or online book for QTP Scripting? Let me know more about QTP Scripting.

2421


How to upload excel files into Quality Center using QTP Script and how to delete excel files from Quality?

606


How to customize qtp?

606


How do you convert manual test cases to automated test cases?

571


Describe the differences between functions and actions in UFT?

602






What is the use of an object spy tool in qtp?

553


What is the syntax to call one action in another?

544


How does qtp recognize objects in aut?

576


What if recovery scenarios is also failed for identify the alert ? (We are handling unexpected popup through recovery scenarios but if still recovery scenarios also failed than what should be the approach)

1005


What is the registration process and examination fees?

545


I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?

1839


how to post xml data from QTP scripts to any application?

1497


Hi.. I want to do parametrization for selecting perticular flighr say XYZ by using local table: criteria: 1.If flight is available msgbox "Flight is available" and then select flight from flight table and click to ok button after that as enter username and ticket no and then stop 2. otherwise msgbox " Flight is not available" and stop Please help me out ..and let me know your responses on dipak.bachhav@gmail.com Regard, Dipak

1612


in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?

6310


how to create flat file datasubmission in qtp

1896