Hi Team,
I want to convert the PDF file to EXCEL file and stored in one Location
For that i used the “Read PDF Text” control and after that what i want to do ? i don’t know
Sample file: I attached here see below
Church Mutual Comm Dec 2017.pdf (49.0 KB)
1090444_COMS_Commission Statement[1].PDF (148.3 KB)
so kindly help me .
Regards
RaviDevaraj.
Refer this
Hi @arivu96
Using this i have done few thing what i have understand so far ?
but i am totally confuse, related to this topic because i am new to this UIPath too.
i attached the my XAML file here can you guide me where i have done a mistake and guide me?
Main.xaml (10.3 KB)
And my pdf file i have attached here to convert in to excel
1090444_COMS_Commission Statement[1].PDF (148.3 KB)
Hi @arivu96
HI @shankm
Hi @Dominic
can you please solve with this issues and guide me to know this scenario
Thanks in advance
Regards
RaviDevaraj
Hi @RaviDevaraj,
Refer this
Main (32).xaml (11.7 KB)
i just corrected your errors in the xaml file.
but i have few question in your flow.
i dont know in Write line you are given dt.Rows.count but where you are getting the value of the datatable.
Regards,
Arivu
Hi @arivu96
I have given dt.Rows.count but where you are getting the value of the datatable. ?
i need to get data from PDF File only not from DataTable !!
as per my knowledge i saw few examples and theory part i think pdf file can be convert as word only giving so many examples but convert to excel are rare ?
"so it is possible for convert PDF file to EXCEL file "
you have share the xaml file, if i run that shows an error message Like this
Error in For each loop also : see the below error screenshot too
i asked the same question to you in the previous post too.
ok now i got pdf to excel right?
Regards,
Arivu
HI @arivu96
ok now i got pdf to excel right? yes @arivu96
it is possible to do ?
Regards
RaviDevaraj
HI @arivu96
wow Great, what are the steps to follows and then what are the controls need to use to achieve this “convert PDF file to Excel and i need to save in one location”
Regards
RaviDevaraj
Hi @arivu96
the xaml file running successfully ?
but in the project folder i have two excel file shown below:
in both excel empty only there is no data getting from PDF File too ?
why what is the reason we didn’t getting a data from the PDF FILE TO EXCEL File ?
Regards
RaviDevaraj
Hi @RaviDevaraj,
Read PDF text activity → select your pdf file
Write CSV → choose your excel/csv file
Regards,
Arivu
Hi @arivu96
these are details i gave see the two screenshots:
Again why we are using the DataTable here ? see the output screen too 234 records showing ?
In that i am get a data in a single column only is not like in pdf what we expect ?
output of excel sheet find below:
Untitled.xlsx (10.6 KB)
Please find the excate pdf file format how it is ? it has 10 column and two customer name and 12 records only.
see the attchment of pdf file too .
1090444_COMS_Commission Statement[1].PDF (148.3 KB)
Hi @arivu96
i gave filename as untiled But here two files is there like that
see the file type too that is also difference?
Hi @arivu96
Are you there ?
see the previous post and this post to to queries ?
we can able to do the further changes in that xaml file for my requirements
can you please help me ?
Regards
RaviDevaraj.
Hi @arivu96
Are you there?
we can find out any solution for these issues ?
above Previous two post i mentioned?
Regards
RaviDevaraj
Hi @arivu96
Reply me ??
We have a solution for that issues in Excel we are facing right now.
Above posts I mentioned?
Regards
RaviDevaraj
HI @RaviDevaraj,
Sorry for the late reply.
yes you can get like that only.
if you want same as pdf you need to do formatting after reading the pdf then you need to write in excel file.
Regards,
Arivu
Hi @arivu96
As you mentioned above post “if you want same as pdf you need to do formatting after reading the pdf then you need to write in excel file.”
How can we able do that process in Excel ? [Reading the PDF File and writing in Excel formate]
Regards
RaviDevaraj
