Extracted specific text from pdf paste to excel

Help Insights
,
1

Someone please help me how can i paste the extracted pdf data to excel…i have extracted only registration number from pdf’s and i want to paste that no into excel building a column name of registration no…how can i do that?

1 Like
2

Hi

Once after getting the data u can add it to a datatable

So let’s create a datatable with BUILD DATATABLE activity with columns you want

And then add the data to that datatable with ADD DATAROW activity

And then this datatable can be written to excel file with WRITE RANGE activity

If the excel file is already ready then u can write that value to the excel directly with WRITE CELL activity

Cheers @Priyesh_Shetty1

3

@Palaniyappan all the pdf text extracted in a single variable

4

How can i use that variable in a data row?

5

Hi,

Can you share input example and expected output? It’s no problem if dummy data.

Regards,

6

HI @Priyesh_Shetty1

filter out the registration number using regex, then write the number to excel file using write range.

7

@Priyesh_Shetty1

To extract specific text from a PDF and paste it into Excel using UiPath, you can follow these steps:

  1. Use the “Read PDF Text” activity to read the entire text from the PDF into a string variable.
  2. Use string manipulation or regular expressions to extract the specific text you need from the string variable.
  3. Use the “Excel Application Scope” activity to open Excel.
  4. Use the “Write Cell” activity to paste the extracted text into the desired cell in the Excel spreadsheet.
8

20230427_150943
20230427_1509431800×4000 929 KB

9

I want this 3 text to be pasted in excel with the column name of Registration number.

10

I have filtered but know i am stucked how should i paste that extracted text to excel with column name…

11

Can you share the expected excel result in a screenshot.
Will excel file be empty initially?
Please share sample

12

Yes excel will be empty only…i have extracted the text with the help of read pdf with ocr…Know that extracted text i wanted to paste to excel…How can i do that ?

13

Assign the value to a variable and write using write range.

14

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