AutoCAD VB :: Drawing Polylines From Data In Excel File
Apr 26, 2013
I would like an VB application that from within autocad can open an excel file,from there select 2 columns containing x,y co-ordinates. Which when selected will draw a polyline in the acad drawing.
I usually do this the long way, but it seems I'm doing it more and more so would like to have it fairly automated.New to VBA and stuck at even opening the excel file....nevermind the actual selecting columns and drawing of the polyline!!!
View 4 Replies
ADVERTISEMENT
Jul 24, 2012
Can you take text from a drawing and export it out to excel? My thoughts are room numbers, employee names, department names, etc.
I need an excel spreadsheet showing this information to then upload to my CAFM Application? Is there an alternative to obtaining a report from a drawing?
View 4 Replies
View Related
Jul 24, 2013
I want to link Microsoft Excel data with AutoCAD drawing (like dimension or values). When I made some changes in Excel data, value in AutoCAD drawing can be changes automatically.
View 1 Replies
View Related
May 18, 2013
this dwg file data reading with c#?
View 9 Replies
View Related
Oct 13, 2011
Can I export the text from autocad 2012 LT to excel file.
View 1 Replies
View Related
Jul 5, 2013
example
[CommandMethod("Test")]public static void TestMethod(){ Document doc = Application.DocumentManager.MdiActiveDocument; Editor ed = doc.Editor; Database db = doc.Database; using (Transaction Tx = db.TransactionManager.StartTransaction()) {
[Code]...
1-autocad program will be closed
2-be selected within the file path c sharp example: csharp.jpg
3-I want to read data from a DWG excel file using C#. examples: dwgfile.jpg and drawing1.dwg
4-I want to list here DataGridView data
5-c sharp winform .net 4.0
View 1 Replies
View Related
Aug 29, 2011
I have an autocad drawing with so many light fixtures with all different names.Now we have to change all those names, i already have an excel sheet containing two columns with first one containing "name in drawing" and second one containing respective "new name".
Is there any way to replace the names in cad file using that excel sheet.i just dont want to do all those thousand rename manually ...
View 6 Replies
View Related
Oct 12, 2012
I'm currently working on building up a library of 3D models of crane rigging for a new job. Specifically, I'm creating wire rope slings (like this 3/8" wire rope sling) but with less of an emphasis on visual detail and more on precise measurements.
In order to simplify the process a bit, I created an excel file to enter the basic four measurements of a sling (length, rope thickness, eye width, and eye length) which then calculates and displays for me the coordinates and measurements of all the objects needed to make the sling (arcs, lines, circles to sweep along those lines, etc.)
I realize now that I'm really just creating a task of endless copy/paste, and I'm looking for a better way to get through the process. How to make this work as efficiently as possible.
Is there some way that I could point AutoCAD to the Excel file and have it read all the coordinates and measurements to draw everything automatically? I also considered creating a line in Excel that would give output that I could copy and paste into a .scr, but I have never used any scripting in CAD before, so it would be new territory for me.
View 5 Replies
View Related
Jun 12, 2013
We have a custom LISP program (Written, upadated in 2003) that takes a keyed in item number, opens and searches a .txt file with four coulmns, for the keyed in item number (column 1) and returns a part number (column 2), description (column 3) and any information in column 4.
Here is the Part of the cod in question:
(setq recx (open "H:/ACAD2012/alcocustm/LISP/hardware.txt" "r"))
(setq d "?")
(setq rec (read-line recx))
[Code]....
A quetsion was asked if the data in the .txt file could be put in an Excel file. I tried looking at other post, but I can't seem to find a clear cut way to open and extract the data. Or this old dog overlooked a boand. Is there a easy way to do this, similar to the above?
View 8 Replies
View Related
Oct 7, 2011
I would like to be able to retreive data from a sepcified cell, in a specified worksheet, from an excel file.
I don't have any clue how to connect to an excel file and read the data. Most seems to think you already had an understanding but I'm starting from the beginning.
View 5 Replies
View Related
Jan 15, 2013
Is there a possibility to furnish a hyperlink linking on a defined Excel-data sheet within an Excel file? Are there other possibilities to tie together to a drawing object external additional information, e.g., a product name, product data or product pictures?
View 1 Replies
View Related
Feb 6, 2014
I have a very large excel file with a list of companies in this format:
company_category company_name company_description telephone email
In InDesign I have paragraph style for each one but I need a solution to import all this data and apply the styles automatically.
Few things:
- I don't want to import all these into a table. I want all the info in a 3 text columns format that will run accros 150 pages (more or less)
- I'm using InDesign CS6
Is there any way to automate this?
View 2 Replies
View Related
Jun 9, 2010
I am using Civil3D 2010. I am trying to export the offset/elevation data from my cross sections to a text file or excel file so i can paste the info into another program. so far i've been labeling the offset/elevation info on the section and typing it into excel by hand.
View 9 Replies
View Related
Apr 20, 2013
I have an excel file with a column containing polygon vertices like follows:
Row 1 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
Row 2 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
Row 3 x-Cord1|y-Cord1 x-Cord2|y-Cord2 x-Cord3|y-Cord3....
I am looking for a .Net code that can read each row cell and draw the polygons automatically in AutoCAD window. I am having a bout 100 rows (polygons) and hence I prefer that the code will display all polygons at once in AutoCAD window and not draw them one by one.
I am already having Autolisp code to draw them one by one but I wish to have a .Net code to allow batch polygons drawing instead.
View 5 Replies
View Related
Dec 22, 2011
I am using Auto Cad LT 2012. How do I import an Excel spreadsheet into my drawing?
View 2 Replies
View Related
Jan 7, 2014
I am trying to link excel file to drawing file (idw), but couldn't succeed.
View 2 Replies
View Related
Feb 26, 2013
I've a map of an area, which has more than 50 streets and I want to name the streets from the excel work sheet. The streets are polylines. I want to show the street names on the polylines.
View 9 Replies
View Related
Sep 22, 2011
I'm trying to create about 150 cross-sections, each consisting of 9 closed polylines of which I have created the coordinates. My issue is making the list of coordinates create separate polylines instead of one enormous polyline. Any way to setup the columns, perhaps with blank rows, some way of applying ASCII code, etc. to automatically break up these polylines? (even if they aren't closed that's fine, I just need to make the polylines separate.)
View 1 Replies
View Related
Jun 3, 2011
I am looking for a way to use the .dwg file properties of a drawing to generate an updateable drawing list/register. One that will update automatically as the file properties are updated. I have already created a title block that uses text fields to display custom properties of the file on my title block, such as the job no., drawing no. etc.
I have searched the web for answers, came across this site, joined and searched through it... There are a number of threads that 'sorta' deal with my needs but alway tend to digress more towards the "poster's" needs and away from mine. I noticed that they all talk about Lisp Routines and I have no knowledge of using them. Is that the only way to go or can I use another route? Another one was the Sheet Set Manager but I don't think that this is exactly what I am looking for...
View 1 Replies
View Related
Jun 9, 2011
We need to take polylines from AutoCAD Map 3D to 3ds Max and rename each polyline to have a name of something like "Building Number-Room Number", both of which are defined in our properties for each polyline. Because none of this data is kept on import to Max, we need to do this all in Map 3D, which we are not experienced with. Is there a way to do this, and if so what? We are importing the .dwg files in Max with polylines as splines.
View 2 Replies
View Related
Apr 25, 2012
How to compare two drawing file with object data(two version of the same drawing) . Any source code (C# Arx) then will be much better.
View 7 Replies
View Related
Jul 18, 2012
I imported survey data from a file into the drawing and created a surface from the points and figures. No problem. Engineer wanted to change the datum from assumed to known. At this point all figures have been copied to a new layer flattened and changed to 2D polylines in order to hatch. Then the figures reimported. I raised all the points with the edit datum and raised the figures with edit survey figures. Surface was adjusted and tweaked. Everything was fine. I open the drawing and all the figures are back at assumed datum and the points are on the right datum. Now when I tweak the surface it uses the bogus elevations from the figures. How can I get my figures to save the adjusted elevations?
View 4 Replies
View Related
Feb 15, 2013
I want to create a road map using the survey data. Iv'e got some examples attached below.
How to create such type of drawings in autocad civil 3d.
View 2 Replies
View Related
May 17, 2011
I have polylines that when selected, under properties it lists Object Data for the selected polyline. There are like 10 categories. This drawing is actually creeks in a county and they have object data connected to them where some are "a" some are "b" classification and I want to select all of the "a" polylines and put on a diffrent layer.
View 1 Replies
View Related
Sep 15, 2011
is there any possiblity to convert the Polylines containing object data to a 3D Solid so that the object are also copied?
View 9 Replies
View Related
Oct 31, 2012
In autocad 2013 is the best way still to convert data you have connected to, for example a shape file, as feature data in order to convert that into polylines and text is the best method saving it all as a seperate drawing using the "save as autocad drawing command"? Is there way to do it individually in the current drawing so that I do not always have to be saving things out as seperate drawings and then copy and pasting them back into my working drawing?
View 5 Replies
View Related
Oct 24, 2012
I need to have symbolized linestyles on a number of 3D polylines in mapping data.We normally would simply explode the 3D poly's, and our linestyles display fine.
The linestyles also display fine if we change the 3D polylines to polylines.HOWEVER, with the current dataset we have very high point density on our 3D polylines, and we need to preserve the elevation attributes of the lines.
If we explode the lines we end up with so many tiny segments that they will not display the linestyles - changing the linetype scale eventually will show the style, but at far too small a size to be relevant.
We also, in most of the layers, are not able to change the 3D polylines to polylines - we must preserve the 3D attributes of the lines.So the problem is that we can't explode the 3D polylines, and we can't flatten them either, but we want the linestyles to display.We are using Map3D primarily, but can access C3D if a solution is available there.
The precise scenario is for instance a line which is a top of embankment, but which has points at around 30cm intervals, over a line length of 206m. This particular dataset has several hundred lines like this, and the linestyle we are trying to display is a simple set of repeating ticks off one side of the line.
We are experimenting with weeding the points, but the shape of the lines is being considerably downgraded by this process.at this point we are most likely going to have to present this data without linestyles for these features - not our first choice.
View 1 Replies
View Related
May 20, 2013
There is a AutoLISP for extract START and END coordinates in X, Y, and Z planes, and extract length of Polylines and Arcs.?
View 7 Replies
View Related
Jan 31, 2012
Running a Query that inserts a block with attributes filled with text derived from a file that has a large set of polylines with object data (text)? Is it easier just to insert this object data as text with a query. Or can I place this object data (text) into a block that inserts?
Example:
- You have land locations defined within the object data assigned to a set of closed polylines. (Large subdivision)
- Field name for object data on each closed polyline is "LAND_LOC"
- Now, I'd like to label these locations with a block that inserts to a central point within the closed polyline.
- Block Attributes with "get" the information from the polyline / object data and place this value in the block attribute.
- I have 1 drawing file that has closed polylines with object data assigned to them.
- What is the best method for this? I'd like a block with attributes to insert and pull the object data / field and place it into the block with a defined attribute, that is central to each of the closed polylines. (LAND_LOC)
View 2 Replies
View Related
May 29, 2013
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
View 8 Replies
View Related
Nov 8, 2011
I saw a youtube video "Cross Section in AutoCAD".But i could not understand how to transfer the data from excel to AutoCAD.There is a file TMaker.exe to make template of excel data.I could not find that elsewhere on net. Making earthwork x-sections with AutoCAD.
View 9 Replies
View Related
