Write Rangle - Single string

[Add_Bddd]

Hello,

Let say im building excel file. Depends on column i input data from Datable or i have to input constant string value.

Example:

Coulumn1 ( from DT ) | Column2 ( All rows with string " FALSE " )
XXX FALSE
YY FALSE
XZY FALSE

I know i can just iterate through datable and input cells →
For each row in datable {
Write Cell A+Counter
“FALSE”
}

But i think personaly it`s quite not efficient with multiple columns.

What i would like to aquire is something like on below image, but i know i cannot use string type variable in Write Range, so is there any walkaround?

[ppr (Peter Preuss)]

instead of updating it cellwise you can prepare / use the datatable with a second column, set it to False and write range

[supermanPunch (Arpan)]

Hi @Add_Bddd ,

You could use Add Data Column Activity with Default value as “False”

[Add_Bddd]

Thank you @ppr @supermanPunch

That what i though could be done, but was not sure at all. Marked as solution, thank you both!

[ppr (Peter Preuss)]

Have a look on the option: DataColumn.Expression as you can also use for the datatable column value setting to FALSE

How to Update Data Column Values of a Data Table | Community Blog

dtData(“ColStatus”).Expression = “‘FALSE’”