The myOnlineTraininghub blog recently had a post entitled
Import Data from a Picture to Excel
which sounded promising, since I often need to extract data from Autocad files saved to a pdf.
From the link, it seems that if I had a Mac with Excel365 then I could do that, but:
- The app is not available for Windows
- The versions for iPhone and Android work by switching to camera mode when you select the “import data” icon, so that you can take a picture of printed images.
First results from the Android version were disappointing. This table from Roark’s Formulas for Stress and Strain:
was converted into this data:
No doubt more care with taking the original photo would help, but the ability to work with existing image files (including pdf) or screen shots, preferably from a Windows computer, would make the whole process a lot easier and more reliable.
I’ll keep an eye on new developments, but at the moment it seems more trouble than it is worth.