How to get data from a pdf to excel in a particular template?

Samarth_Singhal · December 13, 2019, 3:18pm

I want to add from pdf into a predefined excel template

Shriharsha_H_N · December 17, 2019, 4:54am

Welcome to Community

Could you share the pdf and excel template format?

Happy to help

Samarth_Singhal · December 20, 2019, 5:38am

@Shriharsha_H_N I have attached the pdf and excel template. Thanks!
Example Data Template.xlsx (9.2 KB)
abc (1).pdf (81.5 KB)

Shriharsha_H_N · December 20, 2019, 6:21am

@Samarth_Singhal :
1. Use PDF activity and save it strPDFOut
2. after that extract the details using Regex method

Topic		Replies	Views
How can I get data from a pdf to a particular excel template? Help excel , pdf , activities , question	1	1151	December 15, 2019
GET PDF Data and enter it to excel into columns Help excel , pdf , activities , question	3	1227	January 24, 2020
How to extract may data from pdf to excel? Activities pdf , activities , question	1	732	April 27, 2021
Extract data from pdf and save in excels Help	1	1022	October 16, 2018
How i can write data from pdf to excel? Activities excel , activities , question	4	835	January 14, 2022