Fine
Did we try to copy the whole pdf and paste in a excel file
Kindly try that once manually and if that format looks fine in excel once after pasting we can do the same with uipath as well
Then we can try with string manipulation
But is still a complex one
Or
We can try with any python script to read that pdf file
And get the output as Json file which we can later convert to excel
well!
as you can see it’s basically tricky
First you can split into newline and send them in For each loop and split based on spaces like if it as more than 2 spaces it as to split then you can add it to Collection using Add to collection and loop through splitted words and then you can add them to excel! like Item.ToArray using Add data Row
I have a script for my project buddy and I didn’t build that one
But the thing is the structure would differ for each process
If you are good at python or if we can get the help of someone who has python knowledge then this can surely done much more easier
Thanks for reply,
I’m taking help from python developer and he says that it’s not in structured table.
So, he can’t able to pull that table data from pdf.
Any suggestions from ur side??
How can i go forward?