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.
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.