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 l…

@Aditya10989 -pls check blow post - it might help you! [image] Read only filled rows from excel Help Hi @Alinutza13 , Normally , When you leave blank (“”) in the Range property of ReadRange Activity, it will read all the data into datatable. After that you can filter the …

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

[image] Aditya10989: What I 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

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…?

Hi Did you got any solution…?

How to delete empty rows

Learning Hub

GBK (GBK) May 3, 2020, 11:25am 2

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

1 Like

Topic		Replies	Views
Read range until null/ empty Studio studio , question , activities_panel	11	972	August 29, 2023
Read only filled rows from excel Help excel , activities	10	9267	October 29, 2018
Can we delete row from excel without using read range Learning Hub	2	678	May 5, 2020
Read Excel Until 1st Row Empty Activities excel , activities , question	4	2136	December 1, 2021
Read Range Excel Issue Studio studio , question , activities_panel	11	1094	July 18, 2023

How to delete empty rows

Related topics