shafiqsaidee Posted January 2, 2011 Share Posted January 2, 2011 (edited) Hello everyone, I am using AutoCAD 2011, and I have problem using the following formula which export text from excel to AutoCAD. =CONCATENATE("text"," ","J"," ","MC"," ",B2,",",390," ",0.4," ",0," ",C2,"") this formula worked correctly in AutoCAD 14. this formula has written in excel, the description is as like this: ( "text" which AutoCAD's text command. "j" is stand for justification. "MC" meddle center. "B2" is the text which written in B2 cell in excel and this is text which I want to bring it to AutoCAD, coordinate of x. "390" is coordinate of the exact text in AutoCAD which inserted in AutoCAD. "0.4" is text height, "0" text rotation. and "c2" is coordinat of y axis. if you could please tell me how to do it in AutoCAD 2011. Edited January 2, 2011 by shafiqsaidee Quote Link to comment Share on other sites More sharing options...
shafiqsaidee Posted January 2, 2011 Author Share Posted January 2, 2011 Hello everyone, I am using AutoCAD 2011, and I have problem using the following formula which export text from excel to AutoCAD. =CONCATENATE("text"," ","J"," ","MC"," ",B2,",",390," ",0.4," ",0," ",C2,"") this formula worked correctly in AutoCAD 14. this formula has written in excel, the description is as like this: ( "text" which AutoCAD's text command. "j" is stand for justification. "MC" meddle center. "B2" is the text which written in B2 cell in excel and this is text which I want to bring it to AutoCAD, coordinate of x. "390" is coordinate of the exact text in AutoCAD which inserted in AutoCAD. "0.4" is text height, "0" text rotation. and "c2" is coordinat of y axis. if you could please tell me how to do it in AutoCAD 2011. Quote Link to comment Share on other sites More sharing options...
eldon Posted January 2, 2011 Share Posted January 2, 2011 Have you tried entering your expression at the command line. Since AutoCAD 14, the TEXT command has changed slightly. You do not need to enter "J", just enter the "MC". The y coordinate needs to be immediately after the x coordinate, and the text needs to come at the end. And then you need to enter a further RETURN to stop the TEXT command. Just go through your expression by typing at the keyboard, and you will find the correct order to Concatenate your Excel cells. Quote Link to comment Share on other sites More sharing options...
Ryder76 Posted January 3, 2011 Share Posted January 3, 2011 (edited) Going from Rel 14 to 2011 is a huge jump! You might want to take a look at data extraction and tables in your help files. ACAD can now 'link' to an excel file - it can download data from an excel file and upload the changes you make in the ACAD file to the spreadsheet. Hope this helps. Edited January 3, 2011 by Ryder76 spelling dag nabit Quote Link to comment Share on other sites More sharing options...
Ryder76 Posted January 3, 2011 Share Posted January 3, 2011 This thread is duplicated in the Beginner's section. Moderator may want to consolidate and put in one place. Note to OP, please post your thread only once. Thanks Quote Link to comment Share on other sites More sharing options...
fuccaro Posted January 3, 2011 Share Posted January 3, 2011 Threads merged, thank you Ryder76! Shafiqsaidee, please in the future post a question only once. Quote Link to comment Share on other sites More sharing options...
shafiqsaidee Posted January 7, 2011 Author Share Posted January 7, 2011 you are right Ryder76, I posted question twice because I was new with using, and it won't be repeat in future. thanks, Quote Link to comment Share on other sites More sharing options...
shafiqsaidee Posted January 7, 2011 Author Share Posted January 7, 2011 if i enter this expression at the command line it'll take to much time, because the formula which I wrote it is for one text which is located in c2 cell in excel, but I have plenty of cells if i write just using the keyboard I am sure that it will take more then one hour but this formula which I used AutoCAD 14 it took couple of seconds. and I really don't know, what are the missing data which AutoCAD 2011 doesn't accept this formula. thanks, Quote Link to comment Share on other sites More sharing options...
eldon Posted January 7, 2011 Share Posted January 7, 2011 What I meant when I suggested that you entered the expression into the command line, is that you should take note of the order that you entered the figures successfully, and then you would know what order they should be in the formula. The order of data seems to be wrong in your original formula, and I was suggesting a way that you could correct it yourself. Quote Link to comment Share on other sites More sharing options...
shafiqsaidee Posted January 7, 2011 Author Share Posted January 7, 2011 I checked this formula for second time as your suggestion, and this formula woks in single line text and the order was correct as you see in formula. but the problem is with its angle when paste this formula in command line it says : Specify rotation angle of text : 0 Command: text Current text style: "Standard" Text height: 1.0000 Annotative: No Specify start point of text or [Justify/Style]: J Enter an option [Align/Fit/Center/Middle/Right/TL/TC/TR/ML/MC/MR/BL/BC/BR]: MC Specify middle point of text: 25,390 Specify height : 0.4 but the problem is its angle it says in command line :Specify rotation angle of text : 0 and I don't know how to correct the angle. thanks, Quote Link to comment Share on other sites More sharing options...
shafiqsaidee Posted January 7, 2011 Author Share Posted January 7, 2011 text from excel to Acad.zip please see the attachment, open the excel file select the highlighted cell- copy and past into the command line. Quote Link to comment Share on other sites More sharing options...
eldon Posted January 7, 2011 Share Posted January 7, 2011 OK, already you are entering data differently to your original formula. As I said before, you do not need to enter J for justification. J brings up all the alternative justifications, but if you already know what you want, you go for it directly. This is from my version of AutoCAD, which is older than yours, but seems to work the same. Current text style: "RomanS" Text height: 1.00 Specify start point of text or [Justify/Style]: MC Specify middle point of text: 25,360 (x,y) Specify height : 0.4 Specify rotation angle of text : 0 Enter text: ***** Enter text: When you specify the mid point of text, the coordinates are usually given as x before y. In your first formula, you had the coordinate as (B2, 390). If the rotation is 0, then why not enter 0? The Text is the last to be entered, but in your first formula you had C2 which was your y coordinate. You just have to put the values in the formula in exactly the same order as you would, were you to enter at the keyboard (which you don't want to do). This is all getting too confusing, and I shall have to go and lie down. Quote Link to comment Share on other sites More sharing options...
shafiqsaidee Posted January 7, 2011 Author Share Posted January 7, 2011 thanks for giving the instruction I've corrected a few of them and still I have problem with entering the text. in my formula B2 is the coordinate of x which the value is 25 ( 25 is in B2) and 390 is the coordinate of y.after putting x,y coordinate Autocad is asking for its rotation angle which in this formula rotation angle is 0, and then writing text which in my formula text is "25" which this text is in C2. I know its really confusing question and I got confused too, and I've made many changes in formula just but I couldn't and its in the last value. thanks. many thanks from instructions. Quote Link to comment Share on other sites More sharing options...
eldon Posted January 7, 2011 Share Posted January 7, 2011 I think that you need another Return at the end, to stop one input of text, and allow the next input to go ahead. I am not sure how to enter this last Return. It needs to be a hard Return and not just a space, which usually acts as a Return. Quote Link to comment Share on other sites More sharing options...
shafiqsaidee Posted January 7, 2011 Author Share Posted January 7, 2011 exactly this was the point which you had mentioned, and I don't really know how to stop at the end... I wanted to install AutoCAD 14 for this formula in my computer which has the operating system of windows 7, but I couldn't do this and it says that the version of this file is not compatible with the version of windows you are running..... Quote Link to comment Share on other sites More sharing options...
JPlanera Posted January 7, 2011 Share Posted January 7, 2011 Unfortunately text is goofy when done in this manner.... BUT there is a way around this... use -ATTDEF instead Quote Link to comment Share on other sites More sharing options...
JPlanera Posted January 7, 2011 Share Posted January 7, 2011 Try this on for size! =CONCATENATE("-ATTDEF"," "," ",C2," ",," ",," ","MC"," ","25",",","390"," ",".4"," ","0"," ",B2,",","390") Because the input language is backwards, C2 must be first because attdef asks for "content" first.... Quote Link to comment Share on other sites More sharing options...
shafiqsaidee Posted January 9, 2011 Author Share Posted January 9, 2011 Hiya JPlanera!!! I would like to express my thanks to your help both JPlanere and eldon, finally the formula which you've written for "-ATTDEF" have worked. I was trying to install AutoCAD 14r for this formula but, now I am lucky which I have received the answer and it did help me. I was not sure that this formula will work in AutoCAD 2011, but It's worked 100% just like I was using AutoCAD 14r. " Thanks very much for your help". 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.