NHM Posted November 11, 2009 Share Posted November 11, 2009 Hi All, Need to work out a LISP Routine which prompts the user to open an Excel File and read the data from the used cells of Excel to create a drawing in AUTOCAD depending upon the Excel Cells' Data... Please do help in context to the above mentioned subject... Quote Link to comment Share on other sites More sharing options...
fixo Posted November 11, 2009 Share Posted November 11, 2009 Hi All, Need to work out a LISP Routine which prompts the user to open an Excel File and read the data from the used cells of Excel to create a drawing in AUTOCAD depending upon the Excel Cells' Data... Please do help in context to the above mentioned subject... Grab function EXD from this page: http://www.cadtutor.net/forum/showthread.php?t=25629&highlight=topo.lsp ~'J'~ Quote Link to comment Share on other sites More sharing options...
NHM Posted November 11, 2009 Author Share Posted November 11, 2009 Thanks fixo.... I still need to work out the data from Excel Cells to Draw Beam Sizes as well as laying Reinforcement in it with specific Layer Properties and Linetype as well as Pline width all incorporated (all fed in Excel Data Sheet itself) to complete the longitudnal section of the Beam along with Reinforcement.... I would not want it to get converted into a BLOCK.... Quote Link to comment Share on other sites More sharing options...
fixo Posted November 11, 2009 Share Posted November 11, 2009 Thanks fixo....I still need to work out the data from Excel Cells to Draw Beam Sizes as well as laying Reinforcement in it with specific Layer Properties and Linetype as well as Pline width all incorporated (all fed in Excel Data Sheet itself) to complete the longitudnal section of the Beam along with Reinforcement.... I would not want it to get converted into a BLOCK.... All these stuffs are very difficult for my understanding - but the task is very interesting Please, attach your sample drawing with beam and also the Excel sheet (just one row of this beam data) Hope I could be able to help Or maybe somebody from here knows the exact solution Cheers :0) ~'J'~ Quote Link to comment Share on other sites More sharing options...
NHM Posted November 11, 2009 Author Share Posted November 11, 2009 I shall do the pre requisite in some time from now... Thanks for offering help... Shall mail the sample dwg as well as excel data file... Quote Link to comment Share on other sites More sharing options...
fixo Posted November 11, 2009 Share Posted November 11, 2009 I shall do the pre requisite in some time from now... Thanks for offering help... Shall mail the sample dwg as well as excel data file... You can use "Manage Attachments" button below Or you can send the PM to me ~'J'~ Quote Link to comment Share on other sites More sharing options...
NHM Posted November 11, 2009 Author Share Posted November 11, 2009 Hi Fixo, here is the model excel data file with cells filled from where data is to be read and model drawing based on this data to be drawn in AutoCAD.... Worth mentioning that Layer Properties and other Drafting settings can be developed in AutoCAD itself... Cad Forum_Beam_Detail.dwg CAD_FORUM_BEAM_DETAIL_DATA.zip Quote Link to comment Share on other sites More sharing options...
fixo Posted November 11, 2009 Share Posted November 11, 2009 Hi Fixo, here is the model excel data file with cells filled from where data is to be read and model drawing based on this data to be drawn in AutoCAD.... Worth mentioning that Layer Properties and other Drafting settings can be developed in AutoCAD itself... Ok, I will try to finish it at tomorrow only ~'J'~ Quote Link to comment Share on other sites More sharing options...
fixo Posted November 11, 2009 Share Posted November 11, 2009 Hi Fixo, here is the model excel data file with cells filled from where data is to be read and model drawing based on this data to be drawn in AutoCAD.... Worth mentioning that Layer Properties and other Drafting settings can be developed in AutoCAD itself... One more question... I did not found in Excel the diameter of supports Is it always will be equal to 1? ~'J'~ Quote Link to comment Share on other sites More sharing options...
fixo Posted November 11, 2009 Share Posted November 11, 2009 Attached is what I've ended up my work on today with (just a sketch only) I need your opinion ~'J'~ DrawBeam.LSP Quote Link to comment Share on other sites More sharing options...
fixo Posted November 11, 2009 Share Posted November 11, 2009 One step further DrawBeam.LSP Quote Link to comment Share on other sites More sharing options...
NHM Posted November 12, 2009 Author Share Posted November 12, 2009 One more question...I did not found in Excel the diameter of supports Is it always will be equal to 1? ~'J'~ It is not actually the diameter of Supports, its' basically the column width and not necessarily equal to 1 always.... may be variable; my mistake as I forgot to include the same in Excel Data Sheet.. Thanks so much for offering help.. Quote Link to comment Share on other sites More sharing options...
NHM Posted November 12, 2009 Author Share Posted November 12, 2009 I am going thru the same and shall let you know my comments if any... Thanks so much; Quote Link to comment Share on other sites More sharing options...
NHM Posted November 12, 2009 Author Share Posted November 12, 2009 One step further Fixo, It's working really except for reinforcement... Thanks a million Quote Link to comment Share on other sites More sharing options...
fixo Posted November 12, 2009 Share Posted November 12, 2009 Fixo, It's working really except for reinforcement... Thanks a million I dont finished this routine yet Post your edited Excel file with column withs and sample drawing again I will rewrite it accordingly to additional data ~'J'~ Quote Link to comment Share on other sites More sharing options...
NHM Posted November 12, 2009 Author Share Posted November 12, 2009 I dont finished this routine yetPost your edited Excel file with column withs and sample drawing again I will rewrite it accordingly to additional data ~'J'~ Yeah I shall be doing it in a couple of minutes from now on... Fixo Attachments are duly & completely done from my end for your perusal.. many thanx in advance... CAD_FORUM_BEAM_DETAIL_DATA.zip Quote Link to comment Share on other sites More sharing options...
fixo Posted November 12, 2009 Share Posted November 12, 2009 Yeah I shall be doing it in a couple of minutes from now on... Fixo Attachments are duly & completely done from my end for your perusal.. many thanx in advance... Ok, I got it Just a problem perhaps I will be busy today not sure about though... Anyway keep watching See ya ~'J'~ Quote Link to comment Share on other sites More sharing options...
NHM Posted November 12, 2009 Author Share Posted November 12, 2009 Ok, I got itJust a problem perhaps I will be busy today not sure about though... Anyway keep watching See ya ~'J'~ No Problems Fixo, please do take your own time to respond... I shall be waiting; Quote Link to comment Share on other sites More sharing options...
fixo Posted November 12, 2009 Share Posted November 12, 2009 No Problems Fixo, please do take your own time to respond... I shall be waiting; It is the final version of my spaghetti I have added both enforcements only Unfortunately, I couldn't add the ticks of reinforcements - you'll be need to add it manually I hope it will facilitate your job Remove (C:DBM) at the end of code ~'J'~ DrawBeam.LSP Quote Link to comment Share on other sites More sharing options...
NHM Posted November 13, 2009 Author Share Posted November 13, 2009 It is the final version of my spaghettiI have added both enforcements only Unfortunately, I couldn't add the ticks of reinforcements - you'll be need to add it manually I hope it will facilitate your job Remove (C:DBM) at the end of code ~'J'~ WOW!! It really works great... and the rest of the tactics of reinf. I shall be incorporating it in the program....Do not worry... THANKS SO MUCH for a Splendid job!!!! 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.