How to read excel column values from the cell by skipping empty cell in Excel

Hi Team,
Can you Please any one suggest me how to read the column data from Excel and if the cell is empty skip that cell. thanks

Read the excel file using read range activity and do all your logical operation on datatable with the help of linq or foreach


Read excel sheet, in for each take one if condition mention current row(column name)=“” and in else part. you can perform logic

Hi @Yogeshwar_Singh,

Read your excel in a datatable and do the following,

Assign: dtCorrected= yourDatatbleVar.Clone

Assing: dtCorrected =

(From r In dtData.AsEnumerable
Select ia = r.ItemArray.toList
Select ic = ia.ConvertAll(Function (e) e.ToString.Trim.Replace(" “,”")).toArray()
Select dtCorrected.Rows.Add(ic)).CopyToDataTable()


1 Like