How to get the mulitple tables from PDF in excel in document understanding

Help Document Understanding
1

how to get the mulitple tables from PDF in excel in document understanding

2

Hello @dhanashree22!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff

3

That is possible, you can share the file so that we can suggest proper details.

below videos shows the steps clearly, Approach should be same if you go for Document Understanding using Regex extractor. The tables must have a schema and hence can be read as string and converted into datatable using delimiter.

Hope this helps.

4

my excel files getting over write. i have multiple pdf files in folder .but finally it will create only one excel file for last one pdf. why other excel are not genrated . I used their write range activity and logic is Logic.docx (142.3 KB)
please reply

5

yes it will surely overwrite

As you are using the Write Range with the starting range as “A1”. So all the data is being put in that only, at the end of loop you will have only last files data

Only for the first iteration, use “Write Range” and then use “Append Range” for remaining, this can be done using the index variable of that For Loop

Suggest you to use a for each, inside that use Append range. Below is the skeleton you will find it useful

Hope this helps!

image
image1412×721 28.8 KB

6

It is created 4 excel sheet seperate. Actually 1 excel sheet contain 4 sheet but here only for last pdf 4 excel created. no issue is resolved.