How to write table from pdf to excel

[sophiey]

Hi guys,

Im trying to write this table from a pdf into csv (comma delimited) but it breaks the values into columns.

I also tried to append text into word (preserved format) but the table structure is not captured.

My end goal is to copy this table from PDF into Excel with structured format.

[Sudharsan_Ka]

HI @sophiey

Checkout this threads

PDF Table extraction

Hi @anand.t, You can try this approach in this thread: Convert PDF Datatable to Excel - Build - UiPath Community Forum If your table has multiple headers, this first approach may not work because the way the table is obtained read and values seperated using string manipulation. If it is a standard single header type, then this will work just fine with some .replace(SEPARATORS,","). Possible solution for multiple headers (may need string manipulation): Brainstorming Solutions for Editing …

Convert PDF Datatable to Excel

Hi Shail, Since your pdf contains structured data, this is doable in a fairly small workflow. Step 1. You first read the pdf file using pdf read activity - save the string and you will spot a pattern Step 2. Perform some string manipulation to get the string output from Step 1 to look like a csv format (replacing double spaces with “,”) Step 3. Uipath can now save that string directly as a temporary csv file, but I see that you want the result in excel. To save the result in excel, there are…

Regards
Sudharsan

[sophiey]

Any tips to keep the values in one column?

[Anil_G (Anil Gorthi)]

@sophiey

Read the data into datatable and proceed as below

1. Add a new column screening atatus
2. Inside assign use `dt.Columns(“screening status”).Expression = “[screening]+ “’ ‘” + [status]”
3. Then you can delete the old columns and these two columns would be joined

Hope this helps

Cheers

[sophiey]

thanks for the info. just found out that there will be null values inside the datatable hence the merging might not helped from the original csv file.

Now i’m looking at to use Start Process open the pdf file and save as docx (table format is preserved this way).

how can i automate “save pdf as docx” ?

[Anil_G (Anil Gorthi)]

@sophiey

The same way you explained…use sstart process try opening pdf in word and then it gives a prompt mostly try to handle the prompt using prallel
Activity to click on the prompt and then save it

Cheers