Reply

Excel & Solid Edge

[ Edited ]

Hello,

 

We are looking for a good way to include portions of an excel file into a draft. Can anyone explain or link me to an article for what's the difference between a normal copy/paste (select some cells & copy in excel - paste in Solid Edge) and the "Insert Object" command in the draft environnement?

It seems with just copy/past that the excel becomes a part of the draft and has no connection anymore with it's original excel file. If double clicking on the inserted excel, it's another kind of editing mode and it does not open the excel as it used to.

 

Where is the excel saved when just doing a copy/paste, or does it become a part of the draft?

 

Thx, Johan

10 REPLIES

Re: Excel & Solid Edge

Hi Johan,

 

I frequently use Excel for BOMs in draft files.  When you want a link between Excel and Solid Edge, use the "paste special" command in Solid Edge and make sure the "paste link" option is selected.

 

Kyle

 

 

Kyle Joiner
IPA LLC
ST9 MP1

Re: Excel & Solid Edge

Will you please show how to do this.
Sorry, I still couldn't understand this.

Re: Excel & Solid Edge

Here is a video.  Looks like if you open the Excel file directly and edit, rather than opening it from within Solid Edge Draft you may need to open the Draft file, then Edit/Open the table in Excel and the changes will push into the Draft file from the Excel file.

 

(view in My Videos)

Brian Fritz
Solid Edge Certified Professional
ST10 latest MP

Re: Excel & Solid Edge

Thank you so much Mr Fritz,

You really saved lotz of my time.

 

Thank you.

Re: Excel & Solid Edge

[ Edited ]

This question wasn't answered here I don't think:

 

"Where is the excel saved when just doing a copy/paste, or does it become a part of the draft?"

 

If you paste it without using special and link or you insert object without linking then it becomes embedded in the draft but it still needs Excel installed to edit it. Same thing with Word documents, etc.

 

If you do link it then it's dependent on the external file.

Bruce Shand
ST9 MP8 - Insight - Win10 - K4200

Re: Excel

It worked for me.

First you must create the excel file and save it.(without saving it will
not work).

Then follow the steps given in video.

Dft and xls are two separate files.

If you change the location of excel or move the dxf file to different
location, you must also update the links. Because the links will not auto
update itself.

Re: Excel

@JacksonBeno

 

That is not true if you don't link it.

Bruce Shand
ST9 MP8 - Insight - Win10 - K4200

Re: Excel & Solid Edge

I would like to ask you if it is possible to get TEXT from Excel to Parts List automatically.

With numbers everything working fine but I can not find out how to make it with text.

Re: Excel

You can do in draft only.