Hiding Rows in an Excel Worksheet programmatically through automation.

[sumitrishi]

Need to hide all the rows till the end that dont have any data in an
excel worksheet. Please sugest how should I do it .