How to get only visible data from excel

[nilesh.mahajan]

I want to get the Data from specific Column which has text. Currently I am using Read Ranege and For each row activity to fix this. But it gives me entire cell data including null and due to that I am unable to update this data into Web application rich text box.

I want to coly only this 27 cell’s data.

[prasath_S]

Hi @nilesh.mahajan

Use filter datatable activity and give column name not equal to “” (empty string)

Or

inside for each row put an if condition and check if the value is empty or not
In if condition (row(“youcolunnname”). tostring <> “”)
In then part of if condition you can use to fill your data into the application