Write Cell的公式怎么写

[yt.yutao]

大家好，
请问我有一个EXCEL表格，需要把每行信息录入到SAP中，然后SAP会生成一个PO号需要再写回EXCEL的K列，我用的For Each Excel Row，请问最后Write Cell的公式怎么写呢？谢谢！

要把结果逐行写入K列

[mkankatala (Mahesh Kankatala)]

Hi @yt.yutao

I think you are using the For each excel row activity to iterate the each row in the excel to grab the values. If Yes, then insert the Write cell activity inside the for each excel row activity and give like below in where to write field.

CurrentRow.ByField("Rework Order")

Check the below sequence for better understanding.

Hope it helps!!

[vrdabberu (Varunraj Dabberu)]

Hi @yt.yutao

Please check the below work flow for the write cell activity

Regards

[yt.yutao]

@mkankatala ，

Thank you for your help, It’s work.

[yt.yutao]

@vrdabberu
Thank you for your help and It’s work too.

[mkankatala (Mahesh Kankatala)]

Thank you @yt.yutao… Happy Automation!!

[Chyj-110 (Eric Chen)]

类似这样的执行log，我都是把源表读取成Datatable后，根据each row来处理，这样也方便设置指针 i x y之类的，方便定位写入的单元格

或者就是 另外设置一个 输出的datatable，用于结果的记录，最后在回写覆盖回去？