PDF-Excel

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
Screenshot (56)
Getting the header multiple times

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

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

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

Can you share me your xaml file>???

Hi @abivanth.r

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

Regards

printed a single invoice id.xaml (19.5 KB)

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

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

@Vinit_Mhatre
Thanks a lot!!!
Worked :partying_face:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.