Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bindu
'Create Excel Object
Set excel=createobject("excel.application")
'Make it Visible
excel.Visible=True
'Open the Excel File
Set workbook=excel.Workbooks.Open("D:\excel.xls")
'Get the Control on Specific Sheet
Set worksheet1=workbook.Worksheets.Item("Sheet1")
'get rows count
a1=worksheet1.usedrange.rows.count
'get columns count
a2=worksheet1.usedrange.columns.count
msgbox a1
msgbox a2
For i=1 to a1
celltext=" "
For j=1 to a2
celltext=worksheet1.cells(i,j)
msgbox celltext
Next
Next
workbook1.close
set excel=nothing
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?
Hi iam shankar here, right now iam working on manual testing. i want to switch over automation tool qtp, right now iam taking training class outside on qtp, please let me know the cost of QTP tool for full version, wether it's an annual subscription or monthly subscription.
What is the quicktest professional testing process?
Explain different type of event trigger option.
On the website, the protocol has been changed https: to https what you will do? Tell me your approach?
How to write business scripts using object repository with different scenarios
how to disable the pop ups through QTP using a script
write the vb script for call to new action in qtp?
Explain the types of properties that quick test learns while recording?
What contains Data Driven Framework document in qtp?
write a script to verify the image path(src property) of the images which are in web pages.
If you have two monitors one is of 19inch and the 2nd one is of 24inch,if you want to write same QTP script in both the two monitors is there any changes required in the script?
They asked by using qtp recording writing scripting
What is post recovery scenario?
How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)
