How To write the contents present in a list(integer) to excel sheet

Hi Everyone,

I want to write the values present in a list variable of int32 to an excel sheet.
Example: VerifyList (int32(6){1,1,1,0,0,0} consists 6 elements and write those to the columns E to J in an excel sheet.

Please Help.

Simplest method maybe slow:

  • For each activity |item in YourArrayVar | TypeArgument: Int32
    • write cell - as value use item.ToString


Hope these steps would help you resolve this

—use a excel application scope and pass the file path of the above excel and inside the scope use a FOR EACH activity
—in for each activity pass the above list variable as input and change the type argument as int32
—then inside that loop use a WRITE CELL activity and in input property mention as item.ToString and in cell range mention as Convert.ToChar(69+list.IndexOf(item)).ToString+”1” and mention the sheet name in Sheet property

Pls let know for any further queries

Cheers @Abhi15

1 Like


It is writing only to the E1 and L1 Cells that to in headers. I want to write below that E2 to J2.


Then you can keep it loop based on number of values you have

Like in a while loop