AutoCad :: Excel File With Large Amount Of Technical Data
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.
Trying to export points to a csv with the object data that is attached to the point. I can use this and it works great for smaller projects, but crashes every time when I try to export a larg amount of points. The most it has successfully exported was 9000 points but on average it usually will get to 3000 points before i get a fatal error and everything crashes.
Dim CSV_FileName As String = Nothing ' navigate to the point text csv file using a file dialog Dim dlg As New System.Windows.Forms.SaveFileDialog() dlg.InitialDirectory = "C:"
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
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!!!
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 ...
I have an excel spreadsheet with a lot of coordinates. I know how to insert a large amount of coordinates as an block in my dwg. But what I want is to connect my Excel to my dwg, so if I change my Excel automatically the blocks in my dwg change.
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.
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?
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.
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?
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
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.
After fairly smooth sailing for using X6 I ran into a problem that's caused me to switch back to X5 for the time being :(
I work in files that have thousands of individual characters in them. In X5 if I wanted to change the color of about 10,000 individual characters it would take about 3 seconds to do so. If I do the same thing in X6 I takes at least 30 minutes (or longer, I just killed it by that time).
Working with large amount of texts is incredibly slow X6, not just 5 or 10% or slower, doing somethings takes up to 10x times as long.....
I know there is a lot of features for text in X6 but this decrease in speed puts a complete block in my workflow. Maybe Corel could have a feature that individual text characters have minimal properties associated with them or something?
Here are my specs:
windows 7 64bit with office 2010 installed Intel(R) Core(TM) i7-2600K CPU @ 3.40GHz NVIDIA Quadro 4000 16.0 GB ram
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.
I am familiar with GIS but I am new to AutoCAD Map 2012.
I have 140,000 lines and 20,000 points.
I would like to have all points closer than 1 meter to a line.
This is what I tried to do:
buffer the lines (_mapfdobuffercreate)overlay points and buffer (_MapGisOverLay) to get all points in the buffer area
This works well with a small amount of data.But in step 1 I have to select all lines (140,000) with the mouse. When I try to select all lines with the mouse AutoCAD Map freezes after some minutes. Is there a way with AutoCAD to work on a “layer basis” and not on a “selection set basis”. Other GIS (ESRI, Quantum, …) work with a complete layer.
In this analysis I work with FDO Data (shp,sqlite,sdf). I have geometries, but no attribute data.
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.
I am having a problem with my table that I insert from excel into ACAD 2010. The Data in excel is on automatic color and arial text, once imported into ACAD as ACAD entities the data in my table does not want to change to being bylayer as the cell type is set to but instead stays on white. The only way I can change the color is by entering the cell and changing it manually to bylayer.
I have been asked to write a module that will export layer data from AutoCAD and put it in an Excel spreadsheet. The user wants to have this done through a macro. I am assuming that I need to create a dll that is called from inside AutoCAD but I am not sure.
They want to start with AutoCAD 2008 and once we get it working there we will convert it to 2011 or 2012.
First of all, I can not find the 2008 API and second of all I'm not sure where to start. I am very experienced at programming. We are going to use VB.NET.
When trying to insert a table linked to an Excel 2010 file, it works up until row 28, however, as soon as I add a 29th row to the table it no longer inserts the table. When I try and insert it, I press ok and nothing happens. I tried inserting it as a smaller table and changing the data link to a bigger range after it was inserted, it just didn't update to a larger range.
Is there a way of getting this to work without having to insert it as two different tables?
Seems like i export the data of thickness, diameter, lenght and mass to excel via dataextraction, but if i change something in the drawing, its not updated in the excel file..
I also wanted to export the data to an already existing part list template, but this seems impossible...
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?
I am trying to create multiple block missing in our database, actually i have all the measurement of the fitting inside excel this is mostly elbow and T fitting.
I was thinking of a dynamic block with editable lenght (strech parameter with a mix of constraint). but before digging too deep in a wrong direction i want to ask community if something similar already exist?
I have some soil boring data captured, in the field, to an Excel spreadsheet; basically, a bore site ID and coordinates.
I'd like to be able to have the coordinate attributes of blocks inserted into my bore site plans populate automatically, perhaps based off of the value of a bore site ID attribute which is manually entered for each bore site.
Alternatively, if there were a way to insert the bore site blocks based off the actual Excel records, populating all attributes and locating the block by the actual X,Y,Z coordinate, that might be even better.
How to import data from excel (from particular cell) to AutoCAD Drawing. I have already Created a template for both Excel and AutoCAD. I want to do Whenever i am changing the datas in excel sheet corresponding changes to be done in AutoCAd drawing.
Our company does not have the funds to upgrade so we are stuck with CD12. I am using using a windows 7 /64 bit machine. I created this xml template for the writers to place place their graphics in our author software.
I have 4 layers on my file - grid.guide,desktop and template. The template has the instructions and size dimensions. I have them put all graphics on the high lited desktop layer then when this is complete turn off the template layer. One can print this file with just the graphics showing with no problem.
However if I export this a PNG file both the template and desktop layers show up even though I turned off all layers. I just want the desktop layer with the graphics to show up. I have been using Adobe Illustrator for several years and this doesn't present a problem when saving the graphic as a PNG file.
