import excel table

jmccormick

Can I create a table in excel then import it onto a drawing?

jmccormick

Okay -  managed to import the CSV file into a Creo drawing then exported a DXF.  I Imported the DXF into Onshape and Created an Onshape drawing of it.  I was then able to copy and Paste the imported table into the drawing I am working on.  Everything looks good except the table and text are a very imperceptible YELLOW color.  I cannot seem to find a way to change the color of the text.  Does anyone have any suggestions?  (I still think that Onshape needs to import a CSV file directly.)

Alex_Pitt

Hi, I've created a VBA script to export JSON from excel in the right format for Onshape. This is shared on another thread somewhere on the forum (I'm currently on my mobile so can easily find it)

MichaelPascoe

Reply from other post:

@Alex_Pitt, here is your post with the JSON exporter: https://forum.onshape.com/discussion/comment/92883#Comment_92883

Alternatively, Table - Custom Feature will let you take a CSV directly from an import which you can use in your drawing. Then if you update the imported file, the table will update.