www.sefindia.org

[vivek_v]

I am having an excel value in the cell named raft length and another named raft width. Is there any way in which an automatic drawing can be generated on AutoCAD, showing a rectangle with dimensions equal to raft length x raft width(values from excel cells) when I run some program or macros or anything?

[sakumar79]

Dear Sir,
   Yes, you can make use of VBA for scripting a macro in Excel so that it automatically opens Autocad and specifies the commands to generate the rectangle. Alternatively, you can do the VBA scripting in Autocad to read the data from excel file and generate the rectangle. Search for "autocad vba tutorial read excel" and "autocad vba tutorial draw rectangle" for doing it the second way...

Hope that helps
Arunkumar

[Sampath]

The requirement is quite novel and I have done this several years before using AutoCAD 2008 and VBA.

I will try to locate and post it soon.

Unfortunately current AutoCAD deprecated VBA I guess so my work will not work any  more in recent versions.

I wrote a Excel VBA macro and from which I read the cell information and using COM Automation of AutoCAD I drew a parametric drawing.

My framework was such that I proposed an EXCEL scripting so that any end user can write the scrip on Excel cells using cell values as paramters.

This makes any non programmer can achieve AutoCAD programming and that to parametric

Sampath

[k.sankarasubramanian]

[someshwar ganti]

upload the sample xls file and if possible a sample output file of what u are expecting,

I shall try write a AutoLISP program (subject to my time availability) and post it here

regards
somesh

[abhio]

While Lisp and VBA are good for producing dialogs/ functions that work right within the program (VBA is superseded by .Net now), a non-programmer can also get a quick and dirty solution by producing script files from his spreadsheet so as to produce drawings.

[vinit]

Hi,
I am civil engineer by graduation and software developer by profession. I have done this kind of work in past. I can do it for you as well. You wont even require excel sheet. I would Create a GUI (Graphical User Interface) like every other software, wherein you would put values and the dxf file would be created with all the details you need.

The charges would be very nominal. If you want to get it done, you can get in touch with me at vinit@structwares.com

[amrita potdar]

hello sir..

i have done these drawings using VB.NET ...
drawings of canal structures,drainage siphons,box culvert, dams..
this is very interesting work...
from excel cell nos.vb.net read that cells and creats drawing in autocad..

[syed_A]

Hello Friend
You can use surfer, but the procedure is as follows
1>Export the Excel file as .csv format
2>change the csv file to .txt format , add in the top total number of lines, for example
you have 100 line, write it as 100,0, then save this file as .bln
3> open surfer, go to map>base map,look for your bln file and open
4>export it as dxf,  edit in Autocad ....done
Bye

[kothavijaykrishna]

Hello everyone...
i am really like to know this.where can i get stuff about this, like materials, examples, websites. If anybody knows, plz let me know.

Thank you in advance