Read Excel Data Cells and Draw in AutoCAD thru LISP

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

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

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

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

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

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

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

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

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

Attached is what I've ended up my work on today with

(just a sketch only)

I need your opinion

~'J'~

DrawBeam.LSP

One step further

DrawBeam.LSP

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

I am going thru the same and shall let you know my comments if any...

Thanks so much;

One step further

Fixo,

It's working really except for reinforcement...

Thanks a million

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

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

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

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

Ok, I got it

Just 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;

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

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

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