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
- 27960 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
How to release all resources file from the QTP?
How qtp recognizes the object?
What are the things(properties, and other details) will be recorded while recording an object using normal recording?
Explain in brief about the quicktest professional (qtp) automation object model?
Hi Friends... By using QTP , can we test .net products...and that product supports different languages.. thanx in advance..
What is checkpoints for quicktest professional (qtp)?
If the objects hierarchy is changing from build to build, then how you will handle that condition?
Have you used xml check point in your project? How?
Hi, I'm a beginner in QTP and planning of a certification in QTP, but have no idea about it :P. Could anyone please tell me what certifications that a QTP- beginner can take? What is the fees and the syllabus for the certification? Please reply soon. Thanks Vidhya
.have you ever written compiled module? if yes , tell me about some of the function that you wrote.
If u r using library files (Instead of Check Points) , How do u do bitmap check ?
what is the diffrence bw qtp architectute and qtp framework?
I want to write some certification courses, so friends could you guide me? which certification is best and how to write exam and what tutorials need to be studied,what to do first, I am working on automation tool QTP 9.2
What are the different recording modes and how do they work?
how to use the regular expression for the below code-- swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:56" There is a tree view window of the folder's ie Medication- >Pharmacy(sub folder)with 56 as count of records...The records can be different or if no records present in the specific folder..then it show "Paharmacy:-no records".Whe i record at the first time .....and try to rerun the same script with different records count say "pharmacy:800"..qtp is not regnizing it...therefore i want to user regular expression..but donot now how to use it and where to use...i have tried.... swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:\*"..but it s of no use..plz help..me
