How to save the extracted dynamic match values into excel sheet

Help Studio
, ,
1

HI team,

I have used for each activity and used match regex expression inside it and then i have retrived the dynamic output values.
I am able to get the match output values.But how do we save those match output values into excel sheet.

Regards,
Bhagyashree

3

Hi @_Bhagyashree
Build datatable and add the matching value to datatable using add datarow activity and then write it in excel file using write range activity

4

Hi @sangeethaneelavannan1

I have used the same.I am getting error as "add data row-object reference not set to an instance of an object.
What we need to add the values in add data row.

Flowchart2.xaml (124.1 KB)

5

Can you give me screenshot?.I couldn’t open xaml file?.in add datarow activity fill datarow with matching output variable?

6

image
image460×580 16.7 KB

7

Remove.to string from current item.to string.just give currentitem

8

image
image1255×418 31.2 KB

9

Current item.toarray try with this remove those curly braces

10

image
image1920×1080 268 KB

11

What is the datatype of currentitem?

12

image
image808×258 8.6 KB

currentrow is from for each loop

13

Give that currentitem in datarow field and empty the arrayrow field

14

image
image1920×1080 302 KB

15

In build data table,what is the datatype of column?
String?

16

image
image1419×364 22.3 KB

Its Int32

17

Change it to string and try with current item in array row field.it should work now

18

It worked but before adding build data table,add data row and write range it was showing two outputs.Now its showing only one output

19

Write range activity should be outside for each activity

20

still same issue

21

Show me the excel output?