sumitkr1108 Posted February 12, 2020 Share Posted February 12, 2020 Hi members i want to create this cable trench section using excel file so that i had to enter all the necessary data like circle radius / diameter, distance between circle from excel file and this section should be created in autocad file is it possible to do. please let me know sample.dwg Quote Link to comment Share on other sites More sharing options...
BIGAL Posted February 15, 2020 Share Posted February 15, 2020 (edited) 3 ways the simpler is write a csv file of the info required use lisp to create. Box size, circle,x,y,rad. circle,x,y,rad. circle,x,y,rad. hatch,pattern The next get excel to write a script of all the commands required similar to csv. Lastly get excel to drive Autocad and draw objects or the other way Autocad read cells from excel. So all 3 have been answered so many times. Just google about Excel & Autocad or using csv with Autocad. Edited February 15, 2020 by BIGAL Quote Link to comment Share on other sites More sharing options...
devitg Posted February 16, 2020 Share Posted February 16, 2020 On 2/12/2020 at 8:52 AM, sumitkr1108 said: Hi members i want to create this cable trench section using excel file so that i had to enter all the necessary data like circle radius / diameter, distance between circle from excel file and this section should be created in autocad file is it possible to do. please let me know sample.dwg 165 kB · 8 downloads Please upload such xlsx Quote Link to comment Share on other sites More sharing options...
sumitkr1108 Posted July 27, 2020 Author Share Posted July 27, 2020 On 2/17/2020 at 3:00 AM, devitg said: Please upload such xlsx sir i want to make that excel file so that i can input the all these thing through that excel and my section in autocad get prepared. Quote Link to comment Share on other sites More sharing options...
devitg Posted July 27, 2020 Share Posted July 27, 2020 As to be clear, you want to make a DWG from a XLS via VBA code? Quote Link to comment Share on other sites More sharing options...
BIGAL Posted July 28, 2020 Share Posted July 28, 2020 Here is sample VBA draw objects from Autocad so needs the add certain cell values. I will try to find the good youtube video about using excel to draw in Autocad, thought I saved it. This is one For sumitkr1108 need the xls. excel vba draw acad.txt Quote Link to comment Share on other sites More sharing options...
sumitkr1108 Posted July 28, 2020 Author Share Posted July 28, 2020 4 hours ago, BIGAL said: Here is sample VBA draw objects from Autocad so needs the add certain cell values. I will try to find the good youtube video about using excel to draw in Autocad, thought I saved it. This is one For sumitkr1108 need the xls. excel vba draw acad.txt 3.07 kB · 20 downloads thanks sir but i want to take data from excel kindly find attached the sample for the clearty section.xls sample.dwg Quote Link to comment Share on other sites More sharing options...
BIGAL Posted July 28, 2020 Share Posted July 28, 2020 (edited) You asked for it in VBA excel macro are you saying you do not know how to code in VBA ? That is what I posted. The other way is make a csv file of your excel then use lisp. Plenty of code examples out there. Is this what you want ? Duct Bank Width,900 Duct Bank Depth,600 Conduit to Conduit distance,300 Edge to conduit Distance,150 Number of conduits Rows,2 Number of conduits Columns,3 Default conduit diameter,150 code produces this (setq wid 900) (setq Depth 600) (setq dist 300 (setq Edge 150 (setq Rows 2) (seqt Cols 3) (setq dia 150) Note don't need wid as its calculated based on number of conduits. Edited July 28, 2020 by BIGAL Quote Link to comment Share on other sites More sharing options...
sumitkr1108 Posted July 29, 2020 Author Share Posted July 29, 2020 6 hours ago, BIGAL said: You asked for it in VBA excel macro are you saying you do not know how to code in VBA ? That is what I posted. The other way is make a csv file of your excel then use lisp. Plenty of code examples out there. Is this what you want ? Duct Bank Width,900 Duct Bank Depth,600 Conduit to Conduit distance,300 Edge to conduit Distance,150 Number of conduits Rows,2 Number of conduits Columns,3 Default conduit diameter,150 code produces this (setq wid 900) (setq Depth 600) (setq dist 300 (setq Edge 150 (setq Rows 2) (seqt Cols 3) (setq dia 150) Note don't need wid as its calculated based on number of conduits. Thank you sir for your effort but i dont know to create lisp neither vba i am new to all these thing. I want the some macro should be there in excel with button and when i click that button it should open a new drawing in autocad taking all the data from Excel create that duct bank section. 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.