Skip to main content

In my workflow I read excel file through "Query Excel Services".  The data read is from the columns A, B and C.  The data is stored in a Collection Variable.

I have a list with three columns - A, B and C.  I want to copy values of Excel file columns A, B and C as List items under column A, B and C respectively

I tried all combinations in For Each loop, Regular Expressions but not getting desired result.

You quick help is appreciated.

Thanks happy.png

Sunil 

Hi Sunil,

Do you have 3 collection variable or just one with all the data.


Hi Sojan,

Only one collection variable as "Query Excel Service" allows storing in one collection variable only.


Reply