Read Excel Data Cells and Draw in AutoCAD thru LISP

[NHM]

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...

[fixo]

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/showth...light=topo.lsp

~'J'~

[NHM]

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....

[fixo]

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'~

[NHM]

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...

[fixo]

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'~

[NHM]

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...

[fixo]

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'~

[fixo]

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'~

[fixo]

Attached is what I've ended up my work on today with
(just a sketch only)
I need your opinion

~'J'~