How to count number of rows and column in excel

[Pinaki Mishra]

Hi,

Can can any one help me to count number of row and column that contains data only in excel?

Cheers,

Pinaki

[Sreedhar Mallipeddi]

use "Used Range" ..u will the total no of rows and column used in excel

--
Mallipeddi Sreedhar
91-9000994721

[rentala vdml]

create an excel object in QTP.

We can reteive no of rowa and cols using Row Count and Column Count Methods

 

On Wed, Aug 19, 2009 at 4:11 AM, Pinaki Mishra <pmish...@googlemail.com> wrote:

[rentala vdml]

Hi,

 

Here is the code for your refernce

set obj=CreateObject("Excel.Application")

obj.workbooks.open("file path")
Set obj1=obj.Sheets("Sheet1")
set obj2=obj1.UsedRange
n1=obj2.Rows.Count
n2=obj2.columns.count
MsgBox n1
MsgBox n2

 

 

On Wed, Aug 19, 2009 at 4:11 AM, Pinaki Mishra <pmish...@googlemail.com> wrote:

[naveen naveen11]

 In addition to this you can also "UsedRange" for column count so that you will get exact column which used.

[Neo Motlokoa]

Hi, 

You just made my day supper, I'm daniel