Andrew. I am sharing the pdf image of the statement along with the result in excel which I had to clean manually. It took around 4 hours to clean the xlsx converted sheet. I tried to convert pdf to xlsx using different online applications. But I was not able to get the result in the expected order or anywhere near it.
I decided to try and create something similar and this was the first step to copy the data from pdf to word and then the next step would follow.
It tried your code too but the borders are mixing up one transaction with the other. Is it so difficult to get one line of data in one row. or maybe the format of the pdf is completely different which I am not able to understand.
|