--- This software uses traditional problem-solving methods, and I did not use AI or large models here. A very simple but useful solution in certain specific scenarios. It mainly solves the following two problems Question 1: If I have a large number of PDF electronic documents in the same format and need to extract specific numbers or text from multiple areas of each file, how can I do it? Question 2: I have a batch of PDF documents, but the file names are all garbled. I need to rename these files in bulk based on the title text of the first line of the first page in the PDF file. How can I do this? --- Question 1 idea: We randomly select a PDF file as a sample, then use code to mark the areas to be extracted with boxes, and then save the coordinates of these areas. When batch processing each PDF, we extract the corresponding text or numbers based on the saved coordinates of these areas The drawbacks and points to note of this approach: 1. The location of the data to be extracted from each batch processed file needs to be the same. For example, if the first PDF file needs to extract numbers at the coordinates of [100100], then the numbers to be extracted from each subsequent file must be located at this position. If there are any changes, it will result in the inability to extract the required data. This problem can be solved to some extent by expanding the coordinate range of the region If the extracted text is incomplete, it may indicate that the selected box is slightly too small. In my code, I have set up a separate function to increase a certain area If the PDF is not an electronic version, such as an image or a scanned file that cannot be selected, the OCR switch on the left side needs to be turned on

Batch extract content from PDF to Excel

Batch extract content from PDF to Excel

Batch extract content from PDF to Excel