Automatic Generation of a ClassDiagram from Excel-Source-Data

I have a very big data structure from an ERP-System that is completely mapped in a Microsoft Excel table in the attached way.
It would be really nice to automatically generate a class diagram from that.

Does anybody know a way to realize that ?


SourceData for ClassDiagram.JPG

Hi Raphael,

Thank you for your post.

You may consider saving your Excel file as .csv file, and then write a Java application that processes the .cvs file and create classes in your Visual Paradigm project. In order to do this you need to have not only Java knowledge but also knowledge about our Open API. the following page provides you with guide, sample and API doc:
http://www.visual-paradigm.com/support/documents/

Hope this helps. If you have any questions please feel free to contact us again.

Best regards,
Jick Yeung