Question

Locked

Excel sheet data linking with autocad drawings

By bizserv.2007 ·
Dear sir,
I have lots of autocad drawings of same template. I have an ms excel sheet with the required data (Dimensions etc) to be incorporated on to the drawings. How can I do this by linking the sparead sheet to autocad drawing.
Secondly, I want to know how to incorporate changes made in a template drawing (lines, colors etc) to get automatically updated in all drawings.
Thanks.
Venugopal

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Excel sheet data linking with autocad drawings

by pvlaxmikanth In reply to Excel sheet data linking ...

Excel sheet data linking with autocad drawings can be done using vba with autocad
pl. contact 9880617242

Collapse -

yes

by saanjoo In reply to Excel sheet data linking ...

We prepare custom tools (Softwares) to prepare Autocad Drawings
Of the Engineering Components.Some Of Our Clients Provide the
Design Calculation Steps And Sample Drawings (Templates for Eg the
Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes,
Layouting, General Engineering Components , Mechanical Engineering Components,
Civil/Structural Engineering Components,Architectural Components) to follow
and to meet their standards and specifications.The Tools we develop are
entirely customised and specific for clients own requirements and
they are not re distributed to others.


Let me be precise regarding our job profile and what we can do for you

Suppose you have to develop any design component repeatedly for different projects
Only Some of its parameters are changing and you need the drawing for that component.
you cannot prepare the block for that.Since even in the custom Block in Autocad you
cannot controll all the parameters automatically and very few users in Autocad can follow
the technicalities to handle the customisable blocks in Autocad.
On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can
compute the design calculations.But And it takes a long time to develop the drawings.
Moreover if there is any revision in the General Arrangement drawings or Facilities,
the entire things need to change and you have to start from the scratch again and
draftsman forget to change some of the dimensions or the BOQ values in the tables
attached to the drawings.These things are ridiculous to your clients.
We can understand these issues since we are in the design/Detailing and drafting industry
for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime)
in 3 domains
(Piping,Architecture and Structural)
And now we have attained the expertise to develop the dxf files from Excel/EXE Applications.
We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for)
to develop these drawings automatically.


Suppose you want to develop the drawings of doors/Panels with some given features many/some of
which will change every time from task to task or from revision to revision or from project to project.
You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of
these several components.We can save this valuable time for you through the tools.

Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro
and you have to type the utilisation ratios and reactions beside the members including the sizes also.
Have you ever calculated how much time you spend on that and how much errorprone are these ??????
We can help you in these matters also.

We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the
BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide
tools to you which will read the data from your dimensions in specific layer and will type them
in the excel format.And can prepare the drawings of some other feature from the extracted dimensions.


We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for
MIS purposes and the custom checking tools for word processing industries/Quality control departments.
We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA
PDF technologies also.We work in the digitisation works also.


Contact jhatsolve@gmail.com with subject "jhatsolve"

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums