I use oo draw to open the file and use basic to fetch data from index of each page.
Due to the nature of pdf files, texts are splitted into tiny parts and their positions on the pdf page is given as X/Y positions.
And these elements of pdf page do not necessarily follow any possibler order in the index of pdf page.
Some elements that shown on first rows of the pdf page, are given as last elements of index.
In order to set the accurate positioning of each element from pdf in a calc sheet, I tried dividing its vertical position by the height of the original pdf which is 30500 pixels in this particular case; respectively horizontal position by the width of the original pdf which is 21000 pixels.
I don't need if they look in order when I transfer the data into the calc sheet, for example between some full rows there are blank rows, that aren on the original document. Since because I can bring full neighbor cells into together in a particular cell on calc sheet, using another macro, I can fix such problems easily.
my problem is, since some elements' vertical position in the index of a pdf page, is given less than the former ones, when I transfer the text into the calc sheet I lose original word order. Even though the differences are so minor that it can be ignorable, since there are hundreds and thousands of pages, I can't manage setting an accurate algorithm.
- expl.PNG (2.98 KiB) Viewed 1022 times
Text: "Рынки состояли из торговых рядов, которые в" Vertical Position: 6939
I'm trying to figure out a way to ensure the word order to be kept.
Maybe there are some other tools that could be useful which I did not realize.
Is there any alternative approach to convert positions into cells?
You can see an example in the attached document. I gave the horizontal and vertical ranks of each tiny parts of texts in a calc sheet. If I can find a solution to this, I believe 2023 will be my lucky year
