Incorrect Row count of Excel, if we delete few rows

Hi Megha



you can handle the above problem simply looking for empty or null value in one of the mandatory column, Once found empty or null break the loop and don't wait for Driver.EOF. I hope this will solve your problem



  var mandatoryField;



  while (! Driver.EOF())

  {       

    mandatoryField = aqConvert.VarToStr(Driver.Value(0)); //assuming first column is mandatory.



    if (mandatoryField== null || mandatoryField== "")

    {

      break;

    }



    // Rest of the code here.

    Driver.Next();



  }



Regards

Mughees Siddiqui

Hi Megha



Try this



RowCount = MsExcel.ActiveCell.CurrentRegion.Rows.Count;



Regards

Mughees Siddiqui

hi Mughees Siddiqui ,



Yoour solution..display a single count. for n number of rows.



if i uses

row = 2

Driver = DDT.ExcelDriver (excel path ..)

 

while (! Driver.EOF())

{

//process datato read ..here i want to rea only added daata in the rows.if the file has 4 rows.. i want to read only 4 data.

I wan tto read from second row. So i defiened

row = 2

}

 

Driver.Next(); // Goes to the next record

row++;



}

But when few of the data row from excel get reoved, it still start to read the blank data.



This is my problem.



Any one has solution ?

 

 

This is the difference between testcomplete and other tool....Testcomplete support team hardly able to answer the queries... 

This is biggest bug with testcomplete.... as its giving incorrect Excel count Number.

How people paying for this buggy tool ?

Thanks Mughees Siddiqui. It really works ! thank you very much.