I have a table in excel and I'd like to have text in cells link to nodes on a map.
i.e. I have the traffic volume of a road section in a table. I'd like to show that volume on a map beside a circle where the count was taken. I'd like to be able to update the table value and have it also update on ythe map.
I am trying to link my extracted data from blocks with attributes to an extenal source so that the table I create and place into the drawing already has the formulas I need to due the required calculations. But every time I create and place the table the formulas are not in the table. I include the columes that contain the data but it doesn't seem to be working.
View 2 Replies View RelatedIf it is possible to set a block's dimensions to read a table's cell value. Say a rectangle has dimensions x wide by y tall and a table has the x and y values given in cells a1 and b1 linked from an excel spreadsheet.
I would like to link it like this because i have an excel file that will update and then output to AutoCAD. Is this possible and if so how? I have figured out how to link the excel table into AutoCAD. I am using AutoCAD 2012.
Is it possible to link the dimensions in my .idw to the table in the upper left corner? I want the information in the table to reflect what is in the drawing.
I'm using Inventor 2012
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Is it possible to embedd data in a table so that a user can select from a group of data within one cell?
I use this technique quite often in Excel. One cell in a table can have various values: A, B, C, or D. While another cell can have a different set of values to choose from: BLUE, RED, ORANGE, or PURPLE. The user can pull down an arrow (similar to a dynamic block) and choose from a set list of values.
Is it possible to add data to a feature data table? Example: The shape file data downloaded from NRCS only has the Soil number for the State. As I check out features I would like to add data for the soil name, soil group, etc. as additional columns in the data table and have it available in the future by checking the feature back in to my local information.
View 2 Replies View RelatedI would like to link an Excel table to a SHP file via a column in commun. My SHP file and Excel Spreadsheet share one same column filled with numbers. So it's neither simply import Excel table, nor import with points.
But I don't know if I should use "Data Link" or "Add ODBC connection" or "FDO import", or some other fonctions...
I work at a machine shop and have a Dynamic Block setup with quite a number of Blocks in it where I can choose whichever tooling I am working with to place into a drawing.
I am also Data-Linking parts of the drawing to Excel that has information fields to be updated in the drawing for these same toolings.
I would like to setup my drawing so that when I update the data links from the Excel spreadsheet the Dynamic Block I mentioned will also be automatically updated and display the appropriate block drawing for the tooling retrieved from Excel.
I need to export the areas of multiple closed polygons to excel and update that excel as soon as the areas change. We've been using an outside contractor who is able to do this using land f/x.
View 2 Replies View Relatedlinking database records to graphical objects within AutoCAD2012?
View 3 Replies View RelatedIs 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 RelatedI have been creating grading objects from my curb lines, assigning grades using the editor, then offsetting that line for the BACK of curb, and using the raise-lower command to raise the curb line height. If I edit the original face of curb line (gutter grade) then I go back and redo the process. Is there any way to intelligently link these two lines so that if one gets edited C3D knows the other is 0.5 feet higher (or lower) than its neighbor?
View 9 Replies View RelatedI'm having some trouble setting my workflow and I need linking data to corel draw from excel. Basically, what I want to do is to have excel data automatically copy from Excel to Draw and "Paste Special / Paste Link Objects/MS Excel Worksheet is almost what I need.
It would be perfect if only it would copy CONTENT of the Excel file or cells, not their formating (font, size, border etc.) which I want to do in Corel, since separation of the content (excel) and form (draw) would be just natural and functional - don't want my number crunchers to affect design of the Draw document, just as I don't want to have my designer to do the math
So - is there way to link objects (cells from Excel) but to transfer content (text) only or should I revert to VBA?
Is there away to link a i.e. (a stoop to a finish flood elev)? So that, if I were to raise the finish floor, the stoop would move also. I understand I could possible to a create grading feature line for a stoop, but what happens if the stoop would be irregular shapped and not a rectangle?
View 5 Replies View RelatedAny Extension that Links Smart objects. Much the same way you would link in InDesign or Illustrator?
I used to use one in CS4 'Smart Objects Link Panel',but since upgrading to CC I cannot use this extension.
Is that possible to read the Autocad Table data , without opening the Autocad from VB.NET. I tried with opening one autocad then loading the source dll. it was working perfectly.
But i need to without opening a application its possible or not?
How can I Get table name of the object data of a selected layer, with C#.
View 4 Replies View RelatedI am working on a co-ordinate utility that utilises data extractions. I am able to extract the data that I want to an XML file, but how do I create a dxe file and link it to a table? I have found the WizardSettings has a table style, but that is as far as I have reached.My code is below.
using Autodesk.AutoCAD.ApplicationServices;using Autodesk.AutoCAD.DatabaseServices;using Autodesk.AutoCAD.DataExtraction;using System.Collections.Generic;using System.Data;using System.IO;using AcApp = Autodesk.AutoCAD.ApplicationServices.Application;namespace acmCoordinates { public class DataExtraction { const string outputXmlFile = @"c:empdata-extract.xml"; public static void.
[code]....
Most people that I work with don't use autocad map, they use the regular Autocad. So they can not access the table data of my vectors. Is it possible to transform the table data that I choose and place it as text in the appropriate place ?
View 2 Replies View RelatedHere is what i would like autocad to do
I work in architecture, and every time i create an opening (door, window) i add a block next to it with an attribute to the reference number
I was wondering if it would be possible when creating that little block to give it more information and later on extract the information from it to a table
Ex: door 106-02, steel finish, 3'x7' , isolated, steel frame, 2" thick etc.
If it is possible to plot points (or a PLine, or a mesh) in AutoCAD from a table of values in EXCEL (columns of x,y,z coordinates).
View 8 Replies View RelatedI am using data extraction and data linking to an excel file to count blocks and list details. I need to be able to update automatically and the most trouble I have been having is that I need the images of the blocks to come out in the table as well. so far only have been able to get the text data to come out in the table.
View 3 Replies View RelatedI am having problems regarding Data Table Types.
I utilize Excel to build BOM's. I import them through data connection, I than will tell it which cells are Headers / Data / Titles. At which point text sizes / styles ... are applied.
Problem,
I have a cell that is enlarged with small text in the middle. I can orientate the boxes to increase in the Vertical or Horizontal directions larger than the original Excel Data File but i cannot get them to shrink?
I want .05" on the left / right of the widest data, and .02" on the top and bottom. If i change Vertical to .02 it puts the text at the top of the cell.. but if i put it at 1, it enlarges the cell and places it in the middle.
Horizontal i want .02 from the left, but if i align left it goes all the way to the left line.
Can a table format re-define an external excel spreadsheets cell lengths? Obviously taking into account if Wrap text is Enabled it takes the width and defines only the height?
How can I display the object data in a grid with vb.net and also add new features to the same layer along with the object data.
View 3 Replies View RelatedI want to export my slope - table - legend to an excel or txt file.
(Of course only the values)
Civil 3D (2013)
Is there any way to do this in Autocad? Split a table so it is in 2 sections side by side, rather than one verrrrrry long one? Similar to what you can do in Inventor?
[URL]
I am trying to insert a table using a data link. I set up the Link through the DataLink manager and then insert the table using a range. I click OK to insert the table and after a few seconds of thinking ACAD sits there with no table on the screen. When I look in XREFs, the DL is there but says it is unrefrenced. Tried multiple ways of entering or setting up information to no avail.
View 6 Replies View RelatedHow to insert a linked excel table into my drawing, however I have not figured out how to add rows to the table, the option is greyed out. I can insert rows above and below the (inserted) table but not anywhere in the middle.
I've tried everything I can think of, even removing all the formatting in the .xls spreadsheet to no avail. The cells are unlocked, I can manipulate the data, but not being able to insert rows is really hindering the efficiency of using a data linked table.
i get an error message telling (invalid thread data table. Please check Thread.xls file.i tried to reinstall the windows and the autodesk inventor but the error keep appearing.
1.my os is windows xp sv2 32 bit
2. inventor version is 2011 32 bit i also had the same problem with 2010
3. i tried to reinstall without any antivirus on my pc but i still have the same problem
4. what's a UAC?
5. yes i've office 2007 installed & i had tried with office 2003 but also the same problem.
1 the first time i used, i made the bolted connection once, but at the second time i kept having this issue.
2 my last trial was installing a freh copy of the windows then install office and the inventor only but nothing changed
3 i tried to install the inventor on another pc but i also had the same issue
4 i searched the c drive for the file THREAD.xls, and i found three of it and i guess they are fine.
I found out you can export the data table of feature properties from an SDF connection by choosing Options > Select All and then Options > Export and obtained a .csv file I was able to bring in Excel...but there are no headings for the data. How to export the column headings as well?
View 2 Replies View RelatedUsing AutoCAD 2010 LT with service pack 1 and 2
I created a link to an Excel file to create a table. Before I ETransmit the AutoCAD file (along with many other files) I want to remove the link so that the table is embedded with no need for the external file. When I have somebody who doesn't have the linked file on their machine open the file they get a "missing external file" message" despite the fact that I ran the detach data link command and have purge selected in the ETransmit setup. The table shows up with the data, but I want to eliminate the nag pop up about the missing file. I know you can click the ignore button, but I don't want our customer to have to bother with it.
Any way to save a list of files for ETransmit like you do in a .dsd file for batch plotting?