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

Help Community
,
1

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

2

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

3

Hi,

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

4

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()

Thanks

1 Like