how to find whole blank row from a excel sheet
Hi there @mhk15,
Do you only want to retrieve the blank rows from a document, or do you want to remove them?
If you want to remove the rows without data (for a certain field), then you can extract the whole Worksheet and filter, using:
dtMyExtractedData = dtMyExtractedData.Where(Function (drRows) String.IsNullOrWhiteSpace(drRows.Item("ColumnToCheck").ToString)).CopyToDataTable
Please let me know your specific requirements.
Thanks once again,