Write back to excel

[sanjog]

I am testing Facebook messenger, where each response captured is matched against the excel containing the output. If it is matching then pass is displayed else fail.

Now I want to insert the status “Pass” or “Fail” back into the excel sheet along with the response.

Could you please let me know how we can insert the status and the Facebook messenger response back into excel which contains input and output questions.

Regards,
Deepa

[Dominic]

@sanjog, Refer this,

How do you properly append a data column as the end of your last row? I'm trying to add a column of rows to state if an update has been completed

Hi, Just to answer this quickly, The easiest way would be to use Read Range range inside an Excel Scope, and store your table into a DataTable, Then, use Add Column activity if the column does not exist. Then, to process each line item and update the status as you go use a For each row In DataTable Assign row(“Status”)=“Status Update” The Assign will update the DataTable column for Status. Lastly, you use Write Range to output your updated DataTable back to the file (you can also do this…

Regards,
Dominic

[sanjog]

Is there any example or demo for it. It would be great if you could provide it.

Regards,
Sanjog

[Dominic]

@sanjog, Refer this,

Update each row in an Excel document

Hello, easy, I would suggest you to write on a particular cell if the row or data has been processed. then every time you run the artifact make it read the cell that could indicate if the process has been done. and move to the next. here is an example. faite0.zip (13.6 KB)

You can search this forum for more details.

Regards,
Dominic