How to extract data from PDF and save it in excel

[supermanPunch (Arpan)]

Hi @Vincent_Nuestro ,

Could you check the workflow provided in the below post :

PDF TABLES EXTRACTION EVEN WHEN ROWS ARE DYNAMIC

Hi @bhanusai_sajja , I believe the Sample PDF shared is a sample data only and not of confidential data. If it is confidential, Do Let me know. However, I am excluding the PDF sample that was provide to me in private. Check the below workflow : PDF_To_Excel_Corrected.zip (4.0 KB) The Data that you have provided, seemed to have some problem with the column name, and hence it was throwing out error. I did correct that part by implementing a counter/index to the column names if it was already h…

If the PDF has a Simpler table, this workflow should be able to extract and save it in Excel. This might not work for all types of PDF.

However, Do try this and let us know if you get any errors.

Also, for the regex method extraction, we would require a Sample PDF or the exracted text to check further the patterns, analyse and provide a better solution. You could also research on the regex part as there are many tutorials available in the Forum :

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…