Exporting Tabulat notes to Excel and back

[jnikolauk]

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

 

[JohnRBaker]

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.

 

[jnikolauk]

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.

 

[JohnRBaker]

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.

 

[jnikolauk]

So is there any way to maintain formatting? Will NX recognize column width justification and merged cells from Excel?

 

[JohnRBaker]

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.

 

[jnikolauk]

Ok if I'm reading you correctly I have a work around thanks