Import Text from Excel to AutoCAD

Рет қаралды 42,657

5 жыл бұрын

This session is about creating Text in AutoCAD using data present in an Excel sheet. Using a simple Excel formula we can create 1000s of Text Objects within no time.
Topics Discussed are :
1. Excel Formula for creating Text in AutoCAD
2. Controlling Height and Rotation using Cell References
3. Importing Finished Roads and Original Ground Levels into an AutoCAD drawing
4. A macro for extracting details of all those Text Objects (X,Y,Z Coordinates and Text) present in an AutoCAD drawing
Join my course on VBA for AutoCAD
🔵 www.udemy.com/course/programm...
🟢 www.udemy.com/course/scriptin...
Follow the link to download AutoCAD Macros
🟡 xlncad.com/macros-autocad/
Subscribe to the channel for more
/ ajayanandxlncad
🟠 Books on Excel xlncad.com/excel-resources/
🟡 Get Office 365 Subscription microsoft-us.evyy.net/3NE6y
🔵 Download my free ebook on Excel Macros eepurl.com/gpT0RD
🟢 Read my articles on Excel xlncad.com/
🟣 Join my free course on Excel Tables www.udemy.com/course/tables-i...
Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!
#AutoCAD #AutoCADVBA #AutoCADMacro

Пікірлер: 53

@AjayAnandXLnCAD 3 жыл бұрын

Join my course on VBA for AutoCAD 🔵 www.udemy.com/course/programming-in-autocad/ 🟢 www.udemy.com/course/scripting-in-autocad/

@sarfrazahmed249 Ай бұрын

I tried this. 100 percent working. Thanks

@1963cacalo 5 жыл бұрын

Very good! Clear and comprehensive. Thank you!

@AjayAnandXLnCAD 5 жыл бұрын

Thank you for that awesome feedback ☺️

@abdallahal-qutaishat952 3 жыл бұрын

Thank you, it was really helpful :) But I was wondering if I can add more restrictions to the text, such as the layer type, color ...etc. And does this work with the multileader?

@sarfrazahmed249 4 жыл бұрын

Assalam alaikum Aap Ka samjhane Ka style bahut achchha hai. Today I practice 100% success May God bless you

@AjayAnandXLnCAD 4 жыл бұрын

Glad to hear that

@ROHITKUMAR-qu6si 3 жыл бұрын

but in the case of mtext everything ok but in last (after content) CAD is demanding for an empty cell, not space, any other option?

@manjunathg2652 2 жыл бұрын

Love you Ajay .... Thanks for your VIDEO

@MechScience Жыл бұрын

Very helpful video, thanks!

@jihadabdulhaq 10 ай бұрын

thanks a lot >> easy clear steps to follow

@Gandharpn Жыл бұрын

In version 2021, after specifying rotation angle, the cursor moves out of the command line and doesnt take further commands. How to fix it?

@topocadtechnicianmaster5176 11 ай бұрын

SIR, IF I WANT MTEXT INSERT WITH LEADER AND TEXT BOX THEN WHAT TO DO ?

@thepositiveartist7279 2 жыл бұрын

Thank u sir....this helped me a lot

@mohammedsaifullah6437 2 жыл бұрын

very much informative

@InsideMyWall 2 жыл бұрын

Can you make a video for quantity takeoff from autocad and exporting it to excel. Also how to use count feature to count objects

@mimpianakadam 4 жыл бұрын

great thanks from indonesia.. very hopefull ... :)

@AjayAnandXLnCAD 4 жыл бұрын

My pleasure

@tarnpreetsinghgill3906 4 жыл бұрын

nice approach and great explanation

@AjayAnandXLnCAD 4 жыл бұрын

Glad to hear that ☺️

@servenmasankay9129 4 жыл бұрын

very Good,Nice

@AjayAnandXLnCAD 4 жыл бұрын

Glad to hear that. Please check my video on inserting points into AutoCAD

@KetanNagre Жыл бұрын

Can I make tables too in same format?

@meenakshijena6500 3 жыл бұрын

Thanku so much.. Very Helpful.

@AjayAnandXLnCAD 3 жыл бұрын

Most welcome 😊

@cholmonurejai..........9892 9 ай бұрын

Thank you

@SuperJaice 5 жыл бұрын

Informative...

@AjayAnandXLnCAD 5 жыл бұрын

Thank you ☺️

@koushikghosh9480 3 жыл бұрын

thanks for this useful video. but how can I plot or export chainage with "+" symbol instead of point?

@AjayAnandXLnCAD 3 жыл бұрын

Can you please explain the question with an example?

@shujath9176 4 жыл бұрын

I need some hundreds of text in my construction drawing. But how can I get the coordinates for those locations where I want my text to fit in the drawing..?

@AjayAnandXLnCAD 4 жыл бұрын

Do you have AutoCAD points or any other AutoCAD object at those locations?

@shujath9176 4 жыл бұрын

@@AjayAnandXLnCAD We have Architects Xrefs where we will add circuit numbers as text on it. Can we get coordinates by running a polyline over that paths.

@NimishP 3 жыл бұрын

@@shujath9176 can you provide a sample drawing. Or generate a video of your screen activity to have a better understanding of your workflow.

@piotrpiotrowski3986 4 жыл бұрын

works greit tank u mate

@AjayAnandXLnCAD 4 жыл бұрын

My pleasure friend. Please check my videos on programming in AutoCAD.

@pari111nk9 11 ай бұрын

It is great, also can you show how to add chainage like 0+000.00 from excel to AutoCAD

@mdjewelahammed1935 3 жыл бұрын

Thanks

@jpnfsu 4 жыл бұрын

Thanks!!!

@AjayAnandXLnCAD 4 жыл бұрын

My pleasure. I recommend you to check out my videos on programming in AutoCAD

@nocturnalplayer571 4 жыл бұрын

Thanks can u create a data entry for autocad

@AjayAnandXLnCAD 4 жыл бұрын

Can you be more specific?

@tusherkhan6488 4 жыл бұрын

Thankyou... But autocad to excel data is not update...pls solve this problem

@AjayAnandXLnCAD 4 жыл бұрын

Glad to see that you like it. Can you please explain what you mean by AutoCAD to Excel data is not update?

@tusherkhan6488 4 жыл бұрын

@@AjayAnandXLnCAD suppose i import excel table in autocad & write data in excel table & it is autometic transfer autocad. But this problem is when i input autocad table this is not autometic transfer excel table or sheet.... Pls explain how to transfer autocad input data to excel randomly pls pls pls

@AjayAnandXLnCAD 4 жыл бұрын

@@tusherkhan6488 Sorry to say that I don't understand your issue. If you are looking for Macros that will bridge AutoCAD and Excel, watch my videos on programming in AutoCAD.