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)

.qfl extension for which file? where vl use it

3 Answers   iFlex,

---

Is qtp supports uni-code?

0 Answers  

---

If there is a change in the object type eg: A button is changed as link, 1. How to edit that in the shared object repository. 2.What options are available to edit the object within shared object repository other than copy from loca; 3.What would be the effect of the change in Coded Scripts within QTP and Functions stored in .vbs file which are loaded and used in QTP

0 Answers   HP,

---

What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????

0 Answers   Infotech,

---

What is the difference between "call" and "callclose"

1 Answers   Polaris,

---

Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?

0 Answers   IBM,

---

what is retesting?

2 Answers  

---

What is exact difference between “while” and “do while” in QTP ?

1 Answers  

---

hi, i was adding the two numbers in qtp scripts but i didn't get the answer. see my below script, i dont know wht is the problem. i passed the value a=3 b= 2, i got the ans 32 instead of 5. i thing the problem is to be c = a+b my mail id karthis4u@gmail.com Dim a, b, c a = inputbox("enter the a ") b = inputbox("enter the b ") c = a + b print c

8 Answers  

---

How to Display last item of a Combobox by using QTP?

10 Answers  

---

what is a active x control?can any one brief me about active x controls

1 Answers  

---

is it possible to add sheets to excel at runtime

1 Answers  

---