Skip to main content
1-Visitor
February 29, 2016
Question

Excel Integration for Family table

  • February 29, 2016
  • 1 reply
  • 2754 views

Hi,

I wanted to Created Multiple instances of a generic parts, I have all the respective parameters of the Excel. Is there any way to Creo will pull the inputs from Excel and create all the instances.

With Excel analysis, only one part can be created, but how to create 100 instances with Excel inputs.

Thanks


This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

1 reply

10-Marble
February 29, 2016

You can use edit with excel option then copy from your excel.

>First insert an instance.

New Bitmap Image.bmp

> Then select edit with excel

Untitled-1.png  Untitled-2.png

Now you can copy to this xls.

amitshah1-VisitorAuthor
1-Visitor
February 29, 2016

Since, this option is available, but I want to minimize the effort of copy & paste because, copy and paste is more prone to errors and it become difficult if there are hundreds of parameter. I am fine if any third party integration is available which can directly read the excel file.

23-Emerald III
February 29, 2016

How often do you have to do this? Is it really worth the effort to develop a tool for a limited use case?

Cut and Paste  works and does satisfy the requirements of being able to import an external spreadsheet into Creo to create a family table.