Store extracted pdf data into different columns

excel
activities
studio

#1

Hi,

I am trying to extract the data of pdf. I have used Read pdf text with OCR technique. I have get the extracted data file also. I want to know how i will store the extracted data under different columns in Excel.Please somebody help.

Thanks in advance.


#2

Hi,

 As u know the output text from Read pdf text using OCR technique is not accurate so its tough to sort the text accordingly. If the text is proper u can manipulate the string as per ur requirement to store data to excel columns.

#3

I gave extracted it using Read PDF Text activity also. Now can u please tell as to how to sort it under different columns in excel.


#4

Try using this 3rd party application it will help you.

https://sourceforge.net/projects/itextsharp/

Automate this application to convert pdf to xls