ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question 
Dim ExcelSheet
Set ExcelSheet = CreateObject("Excel.Application")
excelsheet.application.visible = true
ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column 
A, row 1"
' Save the sheet.
ExcelSheet.SaveAs "C:\DOCS\TEST.XLS"
' Close Excel with the Quit method on the Application 
object.
ExcelSheet.Application.Quit

after run this script i am getting error"The test cannot 
continue due to unrecoverable error"
 Question Submitted By :: Keshab
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Dim ExcelSheet Set ExcelSheet = CreateObject("Excel.Application") excelsheet.application.visible = true ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1" ' Save the sheet. ExcelSheet.SaveAs "C:\DOCS\TEST.XLS" ' Close Excel with the Quit method on the Application object. ExcelSheet.Application.Quit after run this script i am getting error"The test cannot continue due to unrecoverable error"
Answer
# 1		 
Hi try this one:

Set ExcelObj=CreateObject ("Excel.Application")

ExcelObj.WorkBooks.Add

		Set NewSheet=ExcelObj.Sheets.Item(1)

		NewSheet.Name="Nagendar"

		ExcelObj.Cells(1, 1).Value = "Number1"
		ExcelObj.Cells(1, 2).Value = "Number2"
		ExcelObj.Cells(2, 1).Value = "23"
		ExcelObj.Cells(2, 2).Value = "53"
		ExcelObj.Cells(3, 1).Value = "63"
		ExcelObj.Cells(3, 2).Value = "33"

ExcelObj.ActiveWorkbook.SaveAs "c:\test1.xls"
       

      ExcelObj.Quit
      Set ExcelObj = Nothing
 
Is This Answer Correct ?    5 Yes 1 No
Nani
 
  Re: Dim ExcelSheet Set ExcelSheet = CreateObject("Excel.Application") excelsheet.application.visible = true ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1" ' Save the sheet. ExcelSheet.SaveAs "C:\DOCS\TEST.XLS" ' Close Excel with the Quit method on the Application object. ExcelSheet.Application.Quit after run this script i am getting error"The test cannot continue due to unrecoverable error"
Answer
# 2		 
Dim ExcelSheet, excelobj
Set ExcelObj = CreateObject("Excel.Application")
excelObj.visible = true

ExcelObj.Workbooks.Add
Set ExcelSheet = ExcelObj.Sheets.Item(1)

ExcelSheet.Cells(1,1).Value = "This is column  A, row 1"

' Save the sheet.
ExcelObj.ActiveWorkBook.SaveAs "C:\TEST.XLS"

' Close Excel with the Quit method on the Application  
'  object.
ExcelObj.Quit

Set excelobj = nothing
 
Is This Answer Correct ?    3 Yes 1 No
Dipti
 
 
 
  Re: Dim ExcelSheet Set ExcelSheet = CreateObject("Excel.Application") excelsheet.application.visible = true ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1" ' Save the sheet. ExcelSheet.SaveAs "C:\DOCS\TEST.XLS" ' Close Excel with the Quit method on the Application object. ExcelSheet.Application.Quit after run this script i am getting error"The test cannot continue due to unrecoverable error"
Answer
# 3		 
hi friends

Try this code. it must work.



setexcel=createobject("excel.application")

setexcelsheet=createobject("excel.sheet")

excelsheet.application.visible=true

excel.activesheet.cells(1,1).value=1111
excel.activesheet.cells(1,2).value=2222
excel.activesheet.cells(2,1).value=1111
excel.activesheet.cells(2,2).value="aaaa"
excelsheet.saveas "c:\xyz.xls"
 
Is This Answer Correct ?    2 Yes 2 No
Abhishek
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
what is Compile Module in QTP? what exactly it contains Functions or Actions?  1
Among the 3 Recoring modes,Standard, Analog and Low Level. which one is mostly used. I know that Analog id used for Graphs, Digital Signatures and Barcoding. so, which one among the 2?  1
Is there a function to find the number of occurrences of sub strings within a string?  1
How to retrieve value (data) from notepad using QTP ?  3
what is recovery scenario in QTP? what is the need of the recovery scenario in QTP? what are the advantages of the recovery scenarios in QTP? CTS3
what is L-trim function will do?  1
what is the advatages of merging of object repositories in Qtp9.0 TCS2
How should i find out whether the cursor is moving horizantally. when tabbing continuously Livetek2
How to call a function in QTP?  3
how will we run batch tests in qtp what is the process to run the multiple test sets?  3
take one exmple and write on that discriptive programe in qtp?  1
What is obsolute path and relative path in QTP..? How to access them and what are the differences between them...?? Virtusa1
explain virtual object? in detailed? pls any one explain me? Cap-Gemini2
is the institute MindQ laid by Mr.Nageswar rao.. heard alot about Nageswar rao...can you briefly let me know about the Nageswar rao inst. and MinQ...THANX IN ADVANCE  15
What is the difference between functions and actions in QTP? Verizon3
How do u fetch data from a database ?  2
We developed 100 descriptive programms and put in running, in the midle if any descriptive program is stucked with some error? what will happend weather it will execute the remaining prg's or it will terriminate ? Kanbay5
What is the latest version in QTP? Polaris26
what are the different Frame Works in Quick Test Proffessional testing Wipro4
What is the process for creating an automated test script using QTP assuming you have reviewed the manual test case and understand the requirements? Infosys1
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com