Jump to content

Read Excel Data Cells and Draw in AutoCAD thru LISP


NHM

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 34
  • Created
  • Last Reply

Top Posters In This Topic

  • fixo

    11

  • NHM

    10

  • ABUSAIF

    6

  • jaypatel187

    2

Top Posters In This Topic

Posted Images

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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;

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...