Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 3 Answers
- 27868 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhishek
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 ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is meant by a Check Point in UFT? Also, explain the applicable Check Points.
What is the architecture of your project? Can any one answer for this question plz........
How to perform cross platform testing and cross browser testing using qtp? Can you explain giving some example?
What is system testing and what are the different types of tests you perform in system testing?
What is optional step in qtp? How you can add optional step in qtp?
How to find the name of the machine where you are running your automation scripts in qtp?
How to find array size in qtp?
What is action split and the purpose of using this in qtp?
"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
What is data driver in qtp?
how can we preform retesting(DATA driven test) using function please gine the code for loginpage
What is difference between run time object and test object?
What is the file extension of the code file and object repository file in QTP?
Mention the different actions types of qtp.
