I have a column in excel which can have values or it can be empty. I want to fill the blank cells with the values found in cell above. Making sure not to fill values beyond total row count of the datatable. [image] output should look like: [image]

@SunnyJha Dim previousvalue As String For Each r As datarow In dt.AsEnumerable If r("ColumnName").ToString.Equals("") Or String.IsNullOrEmpty(r("ColumnName").ToString) Then r("ColumnName")=previousvalue Else previousvalue=r("ColumnName").ToString End If Next Use this in invoke code act…

Fill the blank cells in excel with the value above

Help Studio

ppr (Peter Preuss) March 13, 2024, 11:14am 4

An Approach with essentials:

1 Like

Topic		Replies	Views
How to replace empty value with respective of upper row value in datatable Studio studio , question , designer_canvas	7	47	October 12, 2024
Help on filling up with values, when column is empty Studio studio	8	79	October 21, 2024
For each excel row, fill up to cell 15th if cell is empty Activities datatable , excel , activities , studio	11	1023	October 8, 2022
Find/Replace Excel activity Studio studio , question , activities_panel	9	807	June 28, 2024
Excel fill empty cells Activities excel , activities , studio , question	2	680	April 10, 2023

Fill the blank cells in excel with the value above

Related topics