Hi, i have some data from PDF's that i need to manually import to excel as a data spreadsheet. I was hoping to work out an automation to do this, as the way i go about finding the data is occasionally consistent. The Data in the PDF always has a heading, and contains the name or element Letters. With the newest document the data is always on pages 4 and 5 (Normally, rarely different). See screenshots, the 2 images of page 4 and 5 are the way we will always format the data from now onwards, but we have some older data that has a different format seen in 3rd image. Basically we need to grab that data and place in an excel spreadsheet making sure the values are added to the correct row and column based off the above title. the excel format can not change.
Please see Example from Excel:
ATTAR P0 No. | Sample No. | | | Chemical Analysis | Macroexamination | | Volume Fraction Carbides | Hardness Testing | Micro Hardness Testing | Surface Roughness | Abrasion Testing | |
ATTAR REPORT No. | iron (Fe) | Carbon (C) | Manganese (Mn) | silicon (Si) | sulpher (S) | phosphorus (P) | nickel (Ni) | chromium (Cr) | molydenum (Mo) | copper (cu) | vanadium (v) | niobium (Nb) | titanium (Ti) | aluminium (Ai) | tunston (W) | boron (B) | cobalt (Co) | | | Total Plate+W2:AJ2 Thickness (mm) | Total Weld Overlay Thickness (mm) | No. of Weld Runs | | Volume Fraction Carbides % | Confidence Inerval % | Hardness Readings | Ave, HV30 | Matrix - Hardness Readings | Matrix - Ave, HV30 | Carbides - Hardness Readings | Carbides - Ave, HV30 | Roughness Readings | Ave, um Ra | Mass Loss (g) - Results | Mass Loss (g) - Average | Volume Loss (mm) - Results | Volume Loss (mm) - Average | |
27040 | RD1423-1mm | ATTAR Report 20155.01A | | | | | | | | | | | | | | | | | | | | 11.89 | 1.12 | 1.00 | | 0.29 | 5% | 459, 466, 482 | 469.00 | 513, 485, 496 | 498.00 | 1391, 1176, 1351 | 1306 | 6.3 | 6.30 | | | | | |
27040 | RD1423-2mm | ATTAR Report 20155.02A | | | | | | | | | | | | | | | | | | | | 17.79 | 1.78 | 1.00 | | 0.48 | 6% | 481, 483, 486 | 483.00 | 508, 492, 474 | 491.00 | 1347, 1161, 1196 | 1235 | 6.3 | 6.30 | | | | | |
27040 | RD1423-3mm | ATTAR Report 20155.03A | 0.99 | 3.45 | 0.20 | 0.00 | 0.00 | | 39.50 | 0.05 | 0.12 | 0.01 | <0.01 | <0.01 | 0.07 | 0.05 | balance | | 0.04 | | | 14.09 | 3.04 | 1.00 | | 0.47 | 6% | 479, 502, 552 | 511.00 | 645, 524, 531 | 567.00 | 1147, 1284, 1116 | 1182 | 6.3 | 6.30 | 0.69, 0.48, 0.47 | 0.55 | 85.3, 58.3, 54.2 | 65.9 | |
27037 | P1046 | ATTAR Report 20154.01A | balance | 5.03 | 1.24 | 0.00 | 0.00 | | 0.02 | 0.01 | 0.37 | 23.16 | 0.03 | 0.01 | 0.03 | 0.01 | 5.99 | 0.03 | 0.64 | | | 30.49 | 16.84 | 4 | | 42% | 2.81% | 757, 787, 776 | 773 | 565, 554, 667 | 595 | 1317, 1349, 1284 | 1317 | 1.6 | 1.60 | 0.06, 0.08, 0.07 | 0.07 | 8.2, 11.0, 9.7 | 9.6 | |
27037 | P1071 | ATTAR Report 20154.02A | balance | 5.23 | 1.42 | 0.71 | 0.02 | 0.01 | 0.36 | 24.65 | 0.03 | 0 | 0.03 | 0.01 | 0.02 | 0.05 | 5.95 | 0.02 | NA | | | 30.51 | 18.27 | 4 | | 41% | 2.00% | 734, 748, 730 | 737 | 771, 689, 655 | 705 | 1334, 1449, 1270 | 1351 | 3.2 | 3.20 | 0.08, 0.09, 0.12 | 0.09 | 10.2, 12.0, 15.8 | 12.7 | |
27037 | P1057 | ATTAR Report 20154.03A | balance | 5.05 | 1.58 | 0.69 | 0.02 | 0.02 | 0.43 | 24.78 | 0.04 | 0 | 0.03 | 0.01 | 0.03 | 0.04 | 6.2 | 0.02 | NA | | | 31.33 | 18.34 | 3 | | 40% | 1.97% | 660, 712, 679 | 684 | 636, 707, 691 | 678 | 1386, 1621, 1594 | 1534 | 3.2 | 3.20 | Na | Na | Na | Na | |
