How to saved the data into excel after using regex exp

Help
1

Hi, I hae extracted the data and I want to write into excel plz guide
image

@Palaniyappan Plz help :slight_smile:

2

Buddy can i have yur xaml buddy if possible @balkishan
That could help us solve this easily buddy
Cheers @balkishan

1 Like
3

Main.xaml (5.7 KB)
project.json (762 Bytes)

Yes please @Palaniyappan

Thanks

5

Main.xaml (5.7 KB)
project.json (762 Bytes)

No bro, same xmal file I shared with you, Plz check again

6

Sorry my bad took wrong xaml

7

No worry :slight_smile:

1 Like
8

Buddy kindly send in a zipped folder buddy unable to see the activities buddy
both xaml and project.json file altogether in a single zipped folder
image
Cheers @balkishan

1 Like
9

PdfDataExtractionTest.zip (30.6 KB)

10

Bro can you tell me this.

1 Like
11

@Palaniyappan suppose I am extracting the two value one for duration and another rate, so how to use the expression for two value in a match. Or I have to take two diff match activity.

image
image967×256 10.3 KB

12

2 Matches work buddy @balkishan

i m not sure about this buddy @balkishan

13

Okay no problem bro, can you send me the sample for how to save the value in a excel file. For the previous attachment I shared bro. Thank you :slight_smile:

1 Like
14

Buddy you can write with write cell activity buddy if its of single value been received
if it is of many values obtained from a loop iterating the matched values in matches
then u can use write cell with range alone been incremented with counter like this
in write cell you can mention the range like
“A”+Counter.ToString
where counter is a variable of type integer with default value of 1 (if there is no column) and if there is a column mention with default value of 2
and once after the write cell with this range mentioned use a assign activity to increment the value of counter like this
counter = counter + 1

Thats all buddy you are done
Cheers @balkishan

1 Like
15

I did like this, so can you tell me what activity to use in the loop statement.

Add Data Row?

16

@Palaniyappan If I use the Add Data Row, So in the right side property It is asking me for the data table, AddRow and AddArray ?

image
image856×517 20.9 KB

1 Like
17

in array row mention like what i suggested previously comment buddy like this
{out_matches(0),out_matches(1),out_matches(2)}

and YES we need to create a datatable with build datatable activity buddy
Cheers @balkishan

1 Like
18

did that work buddy @balkishan

19

I am doing that bro

1 Like
20

I used the activity outside the loop is Build DataTable,
image

Now I have Columns here one is Duration, and second is AED(Rate)

21

so here bro, can you please let me know can I use two expression in same Match Activity,

Here is First one for Duration and second one for AED(Price).

Right me if I am wrong.

image
image1011×669 25.2 KB