Answer / uday

strFilePath="D:\EmpDetails.xls"
Dim fileSysObj
Set xlObj=createobject("Excel.application")
Set xlWorkBookObj=xlObj.workbooks.open(strFilePath)
Set xlWorkSheetObj=xlWorkBookObj.worksheets(1)

intRowCount=xlWorkSheetObj.UsedRange.rows.count 'intRowCount
=xlWorkSheetObj.rows.count - it returns the number of rown
in an Excel sheet

intColCount=xlWorkSheetObj.UsedRange.columns.count
' intColCount=xlWorkSheetObj.columns.count - it returns the
number of columns in an Excel sheet

msgbox "No. of rows used "&intRowCount&" and No. of columns
used. "&intColCount

xlWorkBookObj.close
xlObj.application.quit

Set xlObj=nothing
Set xlWorkBookObj=nothing
Set xlWorkSheetObj=nothing

http://hpsqtp.blogspot.com/2009/04/how-to-find-number-of-
rows-and-columns.html

Answer / ur

To get the column count use.
allCols = DataTable.GlobalSheet.GetParameterCount
Msgbox allCols

Answer / basha

for outside xls sheet we have follow below
datatable.addsheet("Sheetname")
datatable.importsheet("sheetname",sheetid,"sheetpath")
rowcount=datatable.getsheet("sheetname").getrowcount
msgbox(rowcount)

for globalsheet
rowcount=datatabe("GlobalSheet").getrowcount
msgbox (rowcount)

for actionsheet

rowcount=datatable("LocalSheet").getrowcount
msgbox (rowcount)

Answer / basha

for global sheet

rowcount=datatable.globalsheet.getrowcount
msgbox (rowcount)


for action sheet

rowcount=datatable.localsheet.getrowcount
msgbox (rowcount)

hi i am new to qtp i need to run all files by a batch what is the procedure and what are following actions to be take?

1 Answers   ADP,

---

I need your help in the below topic using QTP Automation tool. How to automate the right click of mouse on a context menu? 1)Tried low level recording which is working fine but making use of co-ordinates. 2) Also tried changing the mouse settings and properties using Tools ->WebEvent RecordingConfiguration and created a configuration file with required mouse click events and used which did not work.

1 Answers   AppLabs,

---

what are the different kinds of frameworks in automation?

1 Answers   Accenture,

---

What exactly is the difference among all the three recording modes.

2 Answers   TCS,

---

What is expert view in qtp?

0 Answers  

---

Hi, I will provide perticular age,it needs to enter date in text box (MM/DD/YYYY) compare to system date. or already exist data in the text box.

2 Answers   Virtusa,

---

What is test fusion report?

2 Answers   CIL,

---

Hi, I got some difficulties in automating a web check box in a peoplesoft application. Let me explain the scenario, When clicked on a look up button in the application, it navigates to a new page with check boxes and respective options. Below is the source code for one check box and its option. <input type='checkbox' name='H1AU_BUNDLE_WRK_H1AU_SELECT_CH$2' id='H1AU_BUNDLE_WRK_H1AU_SELECT_CH$2' tabindex='34' value="Y" onclick="this.form.H1AU_BUNDLE_WRK_H1AU_SELECT_CH$chk$2.valu e=(this.checked?'Y':'N');submitAction_win0 (this.form,this.name);" /> </td> <td align='left' class='PSLEVEL1GRIDODDROW' > <span class='PSEDITBOX_DISPONLY' >$29 - $29 Cap with FREE Mobile</span> I want to parametrize using "$29 - $29 Cap with FREE Mobile". I am not aware of how to parametrize this. Currently I am parametrizing with 'H1AU_BUNDLE_WRK_H1AU_SELECT_CH$2' Can any one please help me out with this??/

0 Answers  

---

1. What is the difference between Keyword and function in the keyword driven framework? 2. How do you associate Keywords to the script ?

0 Answers  

---

How to create a standard checkpoint ?

0 Answers  

---

What are the features and benefits of quick test pro (qtp 8.0)?

0 Answers  

---

How to identify flash application when the qtp is not identifying the flash application objects.

2 Answers  

---