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

Help Studio
, ,
1

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.

Query
Query1078×726 48.3 KB

Please Help.

2

Simplest method maybe slow:

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

Hi

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
4

Hi

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

Thanks.

5

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

Like in a while loop

@Abhi15