×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Exporting Tabulat notes to Excel and back

Exporting Tabulat notes to Excel and back

Exporting Tabulat notes to Excel and back

(OP)
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

RE: Exporting Tabulat notes to Excel and back

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.

RE: Exporting Tabulat notes to Excel and back

(OP)
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.

RE: Exporting Tabulat notes to Excel and back

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.

RE: Exporting Tabulat notes to Excel and back

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

RE: Exporting Tabulat notes to Excel and back

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.

RE: Exporting Tabulat notes to Excel and back

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources