Hi all, I want to know if it is possible to implement this: for each rows in the excel file, if the row is not filled up to cell 15, then fill it up with an empty string “” . My data looks like this [螢幕截圖 2022-10-07 上午10.59.27] However, I want the workflow to work in any data types, not necess…

[image] Sudharsan_Ka: HI @Ben_siu Check with this expression Before using this expression you need to assign another dt Dt2 = dt.Clone (From r In dt.AsEnumerable Let ra = r.ItemArray.Select(Function (x) If(String.IsNullOrEmpty(x.tostring),"you can give whatever string you need",x.ToString)…

For each excel row, fill up to cell 15th if cell is empty

Help Activities

Sudharsan_Ka (Sudharsan Ka) October 7, 2022, 7:13am 10

After this if you write range this datatable in the excel you need you can get your output @Ben_siu

Topic		Replies	Views
Help me to fill the missing data in the Data Table with the preceding values of the cell in a specific coloumn Learning Hub datatable , excel , activities	4	1933	April 9, 2020
Excel fill empty cells Activities excel , activities , studio , question	2	682	April 10, 2023
Hi all. I want to fill data in the specific excel sheet. How can i write next empty cell from specific cell Activities excel , activities , question	5	432	August 18, 2023
Filling Excel file using DataTable Activities datatable , excel , activities , question	0	648	October 13, 2022
How to copy down data from previous rows in empty rows Studio studio , question , find_references	4	1106	May 30, 2023

For each excel row, fill up to cell 15th if cell is empty

Related topics