I want to append a string variable(txtString) to result.xlsx. result.xlsx has one column.
What activity I could use is and how to do?
I want to append a string variable(txtString) to result.xlsx. result.xlsx has one column.
What activity I could use is and how to do?
Hi
If you want to add it to a specific row column cell of a datatable then use a assign like this
dt.Rows(rowindex)(columnindex) = Yourvariable.ToString
Where rowindex and columnindex starts from 0 for first row and first column
Cheers @greenlee
If you want to append the string variable value to excel file
use assign activity and write as below
dt.Rows(rowindex).Items(columnName) = YourStringVariable
If you need to append inside the For Each Row activity
Then, declare a variable for Index property let’s say rowIndex
dt.Rows(rowindex).Items(columnName) = YourStringVariable
OR
row(ColumnName) = YourStringVariable
Hope this may help you
Thanks
@Srini84
Yes, I need to append inside the For Each Row activity.
I’m beginner So could you show me the flowchart screenshot?
Hi @Srini84
Your video clip helps my full understanding.
How to learn more about writing code like ‘dtSiftTimings.Row(index).item(“Difference”)’?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.