Not sure how to use a write cell in a for each excel row

[damian_teo]

not sure how to use a write cell in a for each excel row, so far ive typed in

Excel.Sheet(“Sheet1”).Cell(“AP”)

and it dosent run

[ashokkarale]

@damian_teo,

Refer this solution.

How to write cell in Excel one by one?

Hi @yangyq10 You need not use For Each Excel row. At start befor Get Outlook Mail Messages take a Assign activity and initialize Count = 2. Count varible is of DataType System.Int32. After that below the Multiple Assign you can use Excel Write Cell to write the values and below the write cell take assign activity and increment the counter by 1 i.e Count = Count + 1 . Below flow will help you complete the workflow [image] Make sure to pass the sheet name in place of yourSheetName. Regards

[lrtetala (Lakshman Reddy)]

Hi @damian_teo

@damian_teo

not sure how to use a write cell in a for each excel row

Can you try like below

Regards,

[Anil_G (Anil Gorthi)]

@damian_teo

1. In for each row in table you would have already provided till sheet or the range
2. Now you can use currentRow("ColumnName") in the write cell
   Chewrs