Click here to Skip to main content
15,896,118 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
suppose if there are 20 svg files with the same circuit components but with different component values, I need to extract the content of transistor(model number) in the circuit alone and automatically export them to excel sheet. Kindly help. TIA

What I have tried:

i ve tried opening the svg file using OCR.
Posted
Updated 29-Jul-17 22:00pm
v3

1 solution

OCR will not work as SVG files are in text format, XML format to be more precise.
Just open one with a text editor to see how it looks.
Here is an example of working with XML files in VBA: Working with XML files in VBA (VBA XML) - The Analyst Cave | Excel, VBA, programming and more[^]

To learn more about workig with Excel VBA objects look here: VBA Excel Objects[^]
 
Share this answer
 
v2
Comments
Uma Subramanian 30-Jul-17 4:08am    
Thanks for the suggestion Rick. After extraction of text, how to automatically store data in excel?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900