Get text write to excel

Help Studio
, ,
1

I have an automation where i have to get text multiple times from the web and then write those text to a data table later. is there a way to store all the texts i retrieve into a variable to write to the excel later?

2

You can create a data table with build data table activity, get the text and add it using add data rows to the datatable. At the end of the extraction, write your datatable that you built to excel

1 Like
3

I hoped that helped. If you need some more help we can schedule a Zoom or Teams call on Saturday or Friday late afternoon?

4

Chris,
I will try that route out today and get back to you, Thanks Cousin!

5

Chris,
When i extract the text it is in a string format. Ho do i add that to the datatable that i have made with the build data table activity?

6

Use a Add Data Row activity
image

and in the ArrayRow in the Properties of the activity put your text variable you created in Brackets such as {yourvariable}. If you have more than one column of text you are retrieving, each column with a different variable name it would be {yourvariable1,yourvariable2,etc}. Then in the DataTable property you will put the name of the dt you created.

Hope that helps

Chris

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.