PDF-Excel

[abivanth.r]

Hi
I’m reading multiple PDF’s and extracting the data to excel. I am using Regex for that. After using Build data and add data row. The result in excel is this

Getting the header multiple times

[Vinit_Mhatre (BotBuilder)]

Could you show me your workflow? I think you are keeping “Write Range” inside the forloop. Keep it outside of the loop.

[Parvathy (PS Parvathy)]

Hi @abivanth.r

Use Build Data Table at start of the workflow. and Write Range Workbook after the For each loop i.e outside of For Each loop. This will help you avoid multiple times header creation.

Hope you understand!!
Regards

[Vinit_Mhatre (BotBuilder)]

[abivanth.r]

I couldn’t able to find For each row in data table activity

[Vinit_Mhatre (BotBuilder)]

Can you share me your xaml file>???

[Parvathy (PS Parvathy)]

Hi @abivanth.r

I think the below flow will help you solve your issue.

Regards

[abivanth.r]

printed a single invoice id.xaml (19.5 KB)

[Vinit_Mhatre (BotBuilder)]

I saw your workflow, kindly keep the “Build Data table” outside the forloop…

[abivanth.r]

This is helpful. can you please take a look at my .xaml file and help me up

[abivanth.r]

@Vinit_Mhatre
Thanks a lot!!!
Worked