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
- 27763 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
Can any give an example(if possible templates) how to test web application using QTP. thanks in advance
Explain about business process component? types and usage?
What are the technics follow in writing VB script?
what is the diff b/w assistive and mandatary rules of object repository in QTP???
tell me QTP standards ?plz
why text area checkpoints cannot used for web applications
How to find the length of the string in qtp?
Explain the concept of object repository and how quicktest professional (qtp) recognises objects?
Suggest and Define a solution for an application whose objects are not recognized by UFT?
Without using gui map editor we can recognize the application in winrunner ?
Explain building blocks of the bpt framework ?
How to write business scripts using object repository with different scenarios
Can any body please tell me the steps of keyword driven frame work in qtp. My mail is saswat445@gmail.com please send some materials on keyword driven testing in qtp. thanks a lot...
What is an optional step in qtp ?
What is throw Object?
