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 RepliesWell I had a day and a half trying to figure out how to bring Excel data into LT. Again. Here is what I have found out:
Running Excel 2010 I have a xls files (of type '97-2003 xls - file includes VBA). The file spits out a ton of data that I want to put in a schedule in AutoCAD. The schedule format needs to match our standard format - RomanS in white and blue.
If I copy and paste as a link the font remains stuck as Arial (regardless of source font) and can't be relaxed unless you go one cell at a time in the text editor. Also the resultant table size is tiny -
If I save the file to .XLSM (macro enabled '10 excel file) the results are the same. If I save the file to .XLSX ('10 excel file and ditch the VBA project) the results are sublime - the font is ok and I can go back and forth from AutoCAD to my now broken spreadsheet because VBA IS MISSING! The resultant table size is tiny but I can deal. I don't see how AutoCAD can work with xlsx but not xlsm.
I also found that if I save the sheet (values only) as a .csv file I can use that to create a table from file without font overrides screwing everything up.
I'm running AutoCAD LT 32bit on a Win7 32bit OS. My Office version is 2010. I would like to link data to a '97-'03 version of an xls or an xlsm without having the font overridden to Arial.
I am linking a model to an excel spreadsheet. Normally you would specify what cell on the first sheet (Sheet1) to start in. I have been told that you can link to other sheets in the workbook as well. Is this possible? I have tried, but have not been successful. If it is possible, how is it done?
View 6 Replies View RelatedI'm trying to figure out a way to do the following:
I have several drawing files in DWG. Each DWG has a block placed in a drawing sheet. The block contains attributes which would like to link to an Excel file.
Then if I update the attribute in the drawings this would change the linked attribute in the Excel file, and vice versa.
Note that there are several drawings which I would like to handle in a single Excel file.
Create a large number of polygons (plines, parcels, whatever) that represent spaces on a building plan
Assign a space number to the polygon
Link the space number to an Excel spreadsheet (or Access DB) so that the characteristics of the polygon (line and fill color, for example) are chosen based on the "owner" of the space (e.g.; Engineering, Common Areas, etc.).
Display a label stating the space number and the space name. Is this best done with "Parcels" in Civ3D, or with "Polygons" in Map, or some other way.
As everybody know copy/paste excel file into an inventor drawing is sometimes difficult. As you can see in the printscreen a special character is not converted. I supposed it's because this special character is not in the AIGDT or is in the extended character set wich is not considered in Inventor?
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...
What I would like to do is find a way to use a dynamic block, which has already been created, and once I put in the proper length, speed, type of conveyor, etc., it will automatically update an excel spreadsheet, for example a power estimate, or cost estimate sheet. Is this possible, if so, what is the quickest, and easiest way to do this?
Also, what formula would I use in excel to link back to the DWG?
Ok what I'm tring to do is have a spreadsheet that has a list of prices in it that we could modify if needed for all these parts i'm making. Best way is to have the spreadsheet obviously external of the file.Though now I do not know how to do this in iLogic.And example of what I'm trying to do is, with 3 parameters.
A, B, and P
Value "A" and Value "B", these are just read items which when combined will give Value "P" to be imported into the Part file. So need A & B to be read and give the row number for P to be imported.
when i try to link an excel file to the parameters dialog box i get a message telling me it is "NOT IMPLEMENTED". i just upgraded to windows 7 because it is now supported by autodesk.
View 9 Replies View RelatedI am trying to link excel file to drawing file (idw), but couldn't succeed.
View 2 Replies View RelatedI've previously used Autocad 2008 Electrical. I've just started a new job and I have been asked to update some electrical drawings from a recent project. My current employer use Autocad 2010 as opposed to Autocad Electrical which I have previously used.
The problem I have is that I have a drawing with a table linked to an Excel spreadsheet that displays an I/O table.
Since the drawings have changed the amount I/O has increased.
I have a new excel sheet with the new I/O list which is larger than the old I/O list.
When I "point" the Table to look at the new spreadsheet in the "Modify Excel Link" Dialogue and alter the "Link to Range" Tab to my new desired excel sheet and apply the changes the table. The new excel sheet populates the table correctly until the end of the old table used to stop then the format goes all to hell and the new part of the table is way out of scale and at 90 degrees out to the original table.
I think I am possibly missing a step somehwere when updating the Data Table Links!?!?....Do I need to alter the table properties somewhere too?.
Op System: Windows 7 Home Premium
Processor: Intel Core I7 960
Ram 12.0 GB system 64 Bit operating system.
MIcrosoft Excel info: Excel 2010 (14.0.4756.1000) MSO(14.0.5113.5000) Microsoft Office Home and Student 2010
Inventor Info: Autodesk Inventor Professional 2012 54 bit edition
Build: 160, release 2012 RTM Date 3/1/2011
When trying to link to excel file get error "Not Implemented". Have tried the registry 'fix' - does not work. Need to get these links working to drive models. This same Excel version works fine for Solidworks which inks perfectly with no issues whatsoever. Inventor has been a problem for 2011,and now 2012 - still not working.
I am trying to link a Excel spread sheet to an Inventor 2009 part. It worked great on Friday now it is not working. The only thing that changed was that there was a windos update. When it does work I am unable to update any of the parametes that are linked to Excel file as the update button has disappear.
View 2 Replies View RelatedI'm really in trouble at work on linking Microsoft excel tables to Photoshop. I have some excel tables. I want to import them into Photoshop (not as an image) that when i changed the values in cells (excel) i want the Photoshop file to update.. Should i use a script or any programs?
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 RelatedRegarding the conversion of an excel sheet into Illustrator variables... I am able to import an excel sheet into Illustrator datasets. I am curious if it is possible to link the excel file to the Illustrator data sets, so that when I alter something within the excel sheet, the data sets automatically change. Is this possible? Or must I always freshly convert/import the excel file?
View 2 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?
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 think it's quite a lot of useless work to always select objects before or during a command, if you manipulate the same set of objects over a longer period of time. Say, as an architect I have a floor plan with a table and chairs. Now I want to copy, translate, rotate and scale the table with the chairs until they fit my floor plan. So I have to select the furniture, copy it, select it again, move it, select it again, rotate it, select it again and then scale it. Of course, there is the "previous" option, but is there a way of keeping a selection set active after the command so you just can go on to the next command without re-selecting the whole thing? My favoured workflow would be: Select the objects, copy them, move them, rotate them, then scale them. The objects should be active all the time and deactivated with ESC after the manipulation.
View 3 Replies View Relatedlinking database records to graphical objects within AutoCAD2012?
View 3 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 RelatedWhere are the options to add objects & ActiveX objects to the VBA project? i can reference them but thats it... Have i got to do everything late binding or can i drag an object onto a form in design view?
View 1 Replies View RelatedIs 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.
i want to select all the objects in active artboard using javascript
View 5 Replies View RelatedWe need a script that select all pattern objects in the active document in illustrator.
View 5 Replies View RelatedSince Edge only has rectangles and ellipses built in as available shapes, how to I/we work with polygon shapes and active mouseover areas INSIDE of these shapes and non-active mouseover areas OUTSIDE of the shapes?
Problem/symptom: when I import a polygon, be it any file format from from Photoshop or SVG from Illustrator, a rectangular border/background (transparent) gets applied, leading to this rectangle defining the mouseover area of the shape - and not the shape itself (be it a star or whatever).
WHAT I WANT: the very shape defines the mouseover area. How do I achieve this?? See examle below:
WHAT I DON'T WANT: how is is now:
I did some work with ai and want to export the coordinates of my objects to csv or excel. Is this possible and if yes how?
View 2 Replies View RelatedWhen I link in an excel document to my model all parameters in that excel gets the unit (mm).
How can I change this? For instance I want some of the parameters to be an angle.
Recently I have been trying to build table driven products and ipart tables, but when I copy a member to create a new part number, upon exiting the iassembly author I get the following message "excel installation is required for this operation. failed to launch excel". I have a fully functional version of 2010 Excel installed which has been used so it should be recognized in the windows registry. I am running Windows 8 and Autodesk Inventor 2014.
View 6 Replies View Related