Insert Excel table to nx5 drawing 2

[Berserk]

Hello,

Is it possible to copy and paste a table from excel into a drawing? I tried it, and it wont show up.

TIA!

UGNX5.0.4.1 MP6 \ WinXP-SP3
Productive Design Services

http://www.productivedesign.com

 

[mmauldin]

You can insert a Tabular Note, then right click on the note and select "Edit Using Spreadsheet". Paste your copied data into the spreadsheet window that pops up, then close the spreadsheet. Your data should then populate the tabular note in the drawing.

 

[JohnRBaker]

Not directly, however you can add a Tabular Note using a spreadsheet to define the contents of the rows and columns. So if you have an existing Excel spreadsheet you wish to show the contents of on your drawing, while NX is running and you're in Drafting and the drawing is displayed, open the spreadsheet. Now go back to NX and go to...

Insert -> Table -> Tabular Note...

...and place the table on your drawing with the upper left-corner where you need it to be. Now select the note (it's best to select it at that upper left corner and make sure the entire table is highlighted), press MB3 and select the 'Edit Using Spreadsheet' option. What will happen is that an empty Excel document will be opened and added to the current Excel session. Now just copy & paste the desired rows and columns from your original Spreadsheet into this new one making sure that the first cell is 'A1' (upper left corner). Now close the spreadsheet and you will be asked...

Do you want to update the current tabular note with the contents of the spreadsheet?
Press OK to update the tabular note and exit.

...and you will be given 3 choices...

OK - Cancel - Discard

...OK will complete the operation, Cancel will halt the update but leave you in the spreadsheet and Discard will close the spreadsheet WITHOUT updating the tabular note.

Once a tabular note has been created in can be updated with new spreadsheet data using the same procedure outlined above. Also if you attempt to manually edit any one of the cells of the tabular note it will automatically launch Excel and you will be asked to make your changes there since this note is now stored in NX as a 'spreadsheet record'. Note that this will NOT be your original spreadsheet but rather an embedded record (there will be no separate .xlsx file saved somewhere on the system) in the NX part file itself. So if you wish to reconnect to the original spreadsheet you will need to first open your spreadsheet and then do the edit and use the cut & paste process again as outlined above when I described how to get your spreadsheet data into the tabular note in the first place.

Anyway, that's how it's done.

Now before you ask, there are ways to actually LINK the contents of an external spreadsheet to the contents of a note, but that would involve the use of KF programming or at least the linking of a series of expressions/attributes to the spreadsheet, which could get tedious is there is a lot of data, so as long as you're willing to perform manual updates when needed, the workflow I've outlined here is generally the best and easiest solution to set-up and maintain.

John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Industry Sector
Cypress, CA

http://www.siemens.com/plm

http://www.plmworld.org/museum/

To an Engineer, the glass is twice as big as it needs to be.