Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Exporting Tabulat notes to Excel and back

Status
Not open for further replies.

jnikolauk

Automotive
Jul 18, 2011
145
0
0
US
is there a way to exportt tabular notes to excel and back and keep the formating merges cells column widths etc.. ?

I'm using nx 8.0
 
Replies continue below

Recommended for you

Are you talking about back and forth from the SAME tabular note or from one note to a different one?

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.
 
To a different one. Basically I'm trying to develop a template file for a chart that can be Distributed to engineering to be filled out in excel and then sent back and imported into our drawings. We often get cross format errors when we import from a native excel file I was hoping originating the file in NX would solve the problem.
 
You can edit a Tabular Note using a Spreadsheet from which you could then save the Excel file which could be then Copy & Pasted into the Spreadsheet which is opened when you edit the new Tabular Note. However, this will NOT carry over any 'cell' formatting as it applies to the Tabular Note itself, but only the content of the cells.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.
 
No, the only thing that NX uses from the Spreadsheet is the contents of the cells. In essence, the spreadsheet is simply being used as a familiar way to edit the contents of a bunch of 'cells' as well as a sort of 'gateway' where external data can be inserted, via 'Import' or 'Copy & Paste', into a Tabular Note. Now anything that you do in the spreadsheet, in terms of editing the appearance of the cells or relationships, will be saved and will be there when you go back and edit the Tabular Note using the spreadsheet at some future date, but none of that stuff will have any effect on what the Tabular Note looks like other than the contents of 'cells' in the Tabular Note will reflect the VALUE of the corresponding 'cells' in the spreadsheet.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.
 
Status
Not open for further replies.
Back
Top