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

supermanPunch (Arpan) October 7, 2022, 5:41am 3

Hi @Ben_siu ,

Could you maybe provide us with an Expected Output for the presented Input ?

This way we can avoid much confusions and get the logic right for the implementation. Maybe also highlight the changes in the Output.

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