1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

with out using import sheet came is it possible to get the
excel sheet ?

Question Posted / murali127

Answers were Sorted based on User's Feedback



with out using import sheet came is it possible to get the excel sheet ?..

Answer / sandeep

i think no

Is This Answer Correct ?    1 Yes 1 No

with out using import sheet came is it possible to get the excel sheet ?..

Answer / chaitu.c

Dim ExcelObj
Dim ExcelWB
Dim NewSheet

Set ExcelObj = CreateObject("Excel.Application")
Set ExcelWB = ExcelObj.Workbooks.Open ("D:\Documents and
Settings\Administrator.SEERVER\Desktop\Test.xls")
Set NewSheet = ExcelWB.Sheets("ranga")
NewSheet.Cells(1,1)= "CHAITU"
ExcelWB.Save
ExcelObj.Quit

Set NewSheet = Nothing
Set ExcelWB = Nothing

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More QTP Interview Questions

Give me At Least 5 Differences between DOCUMENTATION OBJECT MODEL(DOM)and COMPONENT OBJECT MODEL(COM)? Interviewer said me to WRITE the difference only in points not as you WRITE a paragraph ???? only in points

1 Answers   BirlaSoft,

why can't you use excel directly in qtp. why we want to import excel data into Datatable.

1 Answers   BoA,

Can objects recognised without repository?

5 Answers  

Describe how Smart Identification is used

1 Answers  

What is Descriptive Programing? In which cases, we will go for descriptive programing?

2 Answers   CTS,

Definationions for keyword view and tree view?

1 Answers  

what kind of frame work you used in your last project?

0 Answers   Deloitte,

What is the new version of qtp which is recently released in the market?

0 Answers  

DIFFERENT RUN MODE IN QTP..1-VERIFY MODE 2-UPDATE MODE 3- dEBUG MODE. My question is in whic sitution we use these modes Explain me with example

1 Answers  

Difference between image checkpoint and bitmap checkpoint

2 Answers  

Explain types of output values?

1 Answers  

I wnnt to learn about QTP Automation Framework,please give URL Address to get more information about AFW.

0 Answers   UHG,

For more QTP Interview Questions Click Here
Categories