1

I want to know that how to get the last filled row from excel sheet. I have used FullRow = worksheet.Rows.Count; But it returns all rows from the excel sheet.

Fedor Hajdu
  • 4,657
  • 3
  • 32
  • 50
ShutterSoul
  • 2,551
  • 3
  • 23
  • 28
  • see this question: [How to determine last used row/column](http://stackoverflow.com/questions/11169445/error-finding-last-used-cell-in-vba/11169920#11169920). It's about excel-vba, but can give you the idea how to do it – Dmitry Pavliv Mar 24 '14 at 10:35
  • 1
    possible duplicate of [Programmatically getting the last filled excel row using C#](http://stackoverflow.com/questions/7674573/programmatically-getting-the-last-filled-excel-row-using-c-sharp) –  Mar 24 '14 at 11:06
  • 1
    @mehow Thanks for the suggestion. Deleted. Getting used to SO :) – LakshmiNarayanan Mar 24 '14 at 11:13
  • 1
    no problem @LakshmiNarayanan. I am glad you're following the rules most of people tend to start fights etc... –  Mar 24 '14 at 11:20
  • Thanks every one to give ur tym.Previously the same code(http://stackoverflow.com/questions/7674573/programmatically-getting-the-last-filled-excel-row-using-c-sharp) was not working for me.so i again posted here. But now luck by chance it worked. :) – ShutterSoul Mar 24 '14 at 11:24

0 Answers0