Best Practice - Import Excel-file into a Drawing

Partner Channel / Creo Parametric

This guide presents a step-by-step instruction on how to import a Excel-file into a Creo Parametric drawing.
There are some best practices to have in mind. The best way is to export your file to a comma separated CSV-file from Excel, and then modify it before you insert the table in the drawing.

Share on Social Networks

Share Link

Use permanent link to share in social media

Share with a friend

Please login to send this presentation by email!

Embed in your website

Select page to start with

4. Step 2. Replace the Semicolon Creo Parametric uses commas as separators and cannot interpret semicolon as such. You may use the functionality of your text editor to replace them.

1. Best Practice Import Excel- fi le into a Drawing

6. Here is an example of what a CSV- fi le, separated by semicolons instead of commas, looks like in Creo (to the left). Next to it is an modi fi ed CSV- fi le.

3. Step 1. Export the Excel- fi le Save your Excel- fi le as a comma separated CSV- fi le and open your CSV- fi le in a text editor, for example Notepad++. As you can see the columns are not separated by a semicolon.

5. Step 3. Import the CSV- fi le to Creo Open your drawing in Creo and go to Table > Table from File . Make sure you change the fi le type to CSV. Select your CSV- fi le and click Open .

2. There are some best practices to have in mind when importing Excel- fi les into a Creo Parametric drawing. The best way is to export your fi le to a comma separated CSV- fi le from Excel, and then modify it before you insert the table in the drawing. This guides presents a step-by-step instruction on how to do it.

7. If you are working a lot with importing Excel- fi les to Creo and do not want to have to change the semicolon to commas for each import, there are two ways to change the default setting for the delimiter: In Regional Settings in Windows 1. In Windows, click the Start button, and then click Control Panel 2. Go to Clock, Language and Region > Change the date, time, and number format 3. Go to the Format tab and click Further Settings... 4. Type a new separator in the List separator box 4. Click OK twice Within Excel 1.   In Excel, go to Excel Options > Advanced > Editing Options 2.   Uncheck the ‘ Use system separators ’ and de fi ne the separator as per your needs

Views

  • 12 Total Views
  • 7 Website Views
  • 5 Embeded Views

Actions

  • 0 Social Shares
  • 0 Likes
  • 0 Dislikes
  • 0 Comments

Share count

  • 0 Facebook
  • 0 Twitter
  • 0 LinkedIn
  • 0 Google+