Loading

problem in reading excel sheet

ila

Hi to all

           I have written a program for reading the contents of the excel sheet..

           I have given the condition like

while (((Excel.Range)workSheet.Cells[rowIndex1, colIndex3]).Value2.ToString() != null)
{

           //values of each cell..
}

            It works properly if i have values till row no. 87.. If i include even one more row the loop does not terminate. it keeps on going..

             Can anybody tell me the solution?

With regards

ila

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews16y ago
I think your new row not null but empty. So u need to check llike this
while (!string.IsNullOrEmpty(((Excel.Range)workSheet.Cells[rowIndex1, colIndex3]).Value2.ToString()))
{
-----
}