import excel table

Answers

• jmccormick Member Posts: 40 ✭

  March 2021

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

  0
• Alex_Pitt Member Posts: 76 PRO

  June 2023

  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)
  

  0
• MichaelPascoe Member Posts: 2,842 PRO

  June 2023 edited June 2023

  
  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.

  
  

  
  RENDERCAD
  rendercad.ai - Photorealistic product rendering.
  
  ▚▞▚▞▚▞▚▞▚
  ________________________________________________________________________
  

  0