Allsopp Posted January 18, 2011 Share Posted January 18, 2011 Currently i have an excel spread sheet that automatically generates pipe details (length's etc) and a separate drawing with a general code illustrating which dimension links to what part. I want to combine the two so they cant be misread but not have to manually duplicate text. Does anyone know a way? Thanks Kelly Quote Link to comment Share on other sites More sharing options...
JPlanera Posted January 18, 2011 Share Posted January 18, 2011 Yes, one way to do it is like so... You can use fields to accomplish this. do you have much experience with them??? Quote Link to comment Share on other sites More sharing options...
JPlanera Posted January 18, 2011 Share Posted January 18, 2011 If i am understanding your issue correctly, then you would want to utilize DATALINK, TABLE, and FIELD... the datalilnk and table are pretty self explanitory, but using fields to display dimensions from your table will take some explanation... Once you make your TABLE from your datalink, creat your dimension, invoke FIELD, choose formula, then choose the cell option. Click on the cell that holds your dimension data and copy the field expression into the text override of the dimension and you should be set Quote Link to comment Share on other sites More sharing options...
laijumalias Posted January 19, 2011 Share Posted January 19, 2011 It is working for the numbers what about if I want to bring in text and number together from excel cells. Any Idea? Quote Link to comment Share on other sites More sharing options...
JPlanera Posted January 19, 2011 Share Posted January 19, 2011 It should not matter what the cell contains. Quote Link to comment Share on other sites More sharing options...
laijumalias Posted January 19, 2011 Share Posted January 19, 2011 See the results of data fieds with text and numbers, the field with text is not showing correctly, I am using civil3D2009. Quote Link to comment Share on other sites More sharing options...
JPlanera Posted January 20, 2011 Share Posted January 20, 2011 Im at loss at the moment... I will see if there is another way... Quote Link to comment Share on other sites More sharing options...
chelsea1307 Posted January 20, 2011 Share Posted January 20, 2011 just a question for you, what happens when you close out of the drawing and re-open it do either of your fields work? Ive tried the copying of field expression before and it would not work after a dwg was close and openned again Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.