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
what is the frame work in J-meter?
in qtp if we record a object and we record the object using virtual wizard then by which way the object is recognized that means recorded
in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?
To retrive the test data which tool vl use and whats basis u vl write test data? its urgent
How will you report the bug and explain the defect tracking sheet you handled?
How is a Step generator used in UFT?
How to write business scripts using object repository with different scenarios
Where we can use the analog mode and where we can use the low – level mode?
what QTP Options do you know?
How to handle the exceptions using the recovery scenario manager in qtp?
How do you synchronization point through DP?
Is there any pdf or online book for QTP Scripting? Let me know more about QTP Scripting.
suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?
How you can delete excel file in qtp?
What is the descriptive programming?
