Forum Discussion

megha_gambhire's avatar
megha_gambhire
Contributor
12 years ago

Incorrect Row count of Excel, if we delete few rows

I have used followign code to read row count from Excel.   var app = Sys.OleObject("Excel.Application"); var book = app.Workbooks.Open(fileName);   RowCount = app.Acti...
mugheessiddiqui's avatar
mugheessiddiqui
Contributor
12 years ago
Hi Megha



Try this



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



Regards

Mughees Siddiqui