How to delete empty rows

I have excel sheet which contain 7 lakhs records.After run macro it left almost 15000 records.Now I want to get this record in read range.But after run 3 hours it still executing.I did not got record in read range.
What I have observe read range activity also count empty row.So it not work for 7 lakhs records.So what can I do it run for 15000 records which left not for every record…?


@Palaniyappan @GBK @Pradeep_Shiv

1 Like

@Aditya10989 -pls check blow post - it might help you!

1 Like

This not work for me.Because above case they got data in read range then dt.row.count.tostring
But In my case Read range showing executing not throw any error and also not got any data.it executing from last 4 hours.As mention above attachment.

@lakshman @nisarg_kadam @aksh1yadav

Hey @Aditya10989,

To delete Empty Rows you can use this
DtVar=in_DataTable.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”))).CopyToDataTable()

thanks for reply where I need to use.Because I am not getting data in data table.Since 5-6 hours it still showing in progress.I did not got any error or output

after read range!

but my read range not executed it still show in progress even after 7 hours.if you don’t mind shall I give you excel sheet.you can also check your end…?

Sure,
pjpradeep191@gmail.com

1 Like

thanks.I send you file.

1 Like

Hi Did you got any solution…?

1 Like

i need to check ill get back to you asap

1 Like

thanks