i'de like to create a map with several colored zones. the colors in these zones would depend on data in a spreadsheet. is it possible to link photoshop to a spreadsheet and have the colors change when the data changes?
View 2 RepliesI WANT to break a link between an OLE object and the spreadsheet. I check drawings from several subcontractors to make sure they meet the clients standards before submitting to the client. The client doesn't want any OLE objects in the drawings but the subcontractors occasionally use them. What is the easiest way to break this link? The client wants AutoCAD entities only such as lines and text.
View 3 Replies View RelatedI am trying to link an excel spreadsheet to my acad but I can't see it once i've linked to it?
View 2 Replies View RelatedI'm trying to link a text from Autocad to an excel spreadsheet so that when changed in Excel, be changed in autocad.
After searching on some forums, I started doing database through ODBC.
I made a table in excel selecting and naming fields, added the file in windows OBDC manager, able to make the connection through dbConnect autocad, created label ...
Now I need to put the information in the database autocad text entity and already there I'm not getting more done
I have several drawings with tables on them with broken links to spreadsheets which have been deleted.I can't edit the tables.
Is there a way of reusing the information in the table to recreate the spreadsheets or new tables.
I know there are lots of sources for keyboard shortcuts in PDF form. But any source for a list (or summarized) shortcuts tabulated in spreadsheet form (or exportable to a spreadsheet).
View 2 Replies View RelatedIn Bridge tools in CS2, at least with Mac version, there is Export files to a spreadsheet --
Is this gone is CS3?
I'm messing around with tables and data links, practicing. I copied a range of cells in Excel, and did paste special to create a linked table.
Now I can delete the table object, but I cannot delete the link, cannot detach it.
When in Data Manager if I right click on the data link and click delete I get the error message "The data link is being used and cannot be deleted".
I have tried detaching, and the detach does not seem to take.
Now also, the table will not update from the source xls.
Win XP, AcadLT 2011, Office 2010. Using compatible setting for saving spreadsheet, for Office 2007 (not xlsx).
If I create a linked table by starting with the Table icon, choose "from a data link", choose the excel spreadsheet, etc., then I am able to later update the table from the spreadsheet, detach, delete the link, etc. But I can only delete the link if the table is not selected when I open the Data Link Manager.
But the one that was created following the directions from the Autocad video, with the copy, paste special, that link will not detach nor delete.
I am using AutoCAD Map 3D 2011 and I am plotting a map with transparent polygon features as well as an Excel spreadsheet inserted as an OLE object. When I plot with transparency turned off (in the _plot dialogue box) the spreadsheet is white but the features are solid. When I plot with transparency turned on, the features look great, but the spreadsheet has a black background with white text.
How to get the spreadsheet to keep a white background while plotting transparency is turned on? I have tried changing the background of the spreadsheet to 254, 254, 254 with no change in the results.
We are using SSM, and it is getting quite annoying right clicking each sheet to input the info for each sheet, as not each sheet has the same info. Is there not a way to import the data from a spreadsheet, so you can fill out all the data in a spreadsheet how you want it, then import it into the SSM?
View 2 Replies View RelatedThe Edit via spreadsheet option does not work, it will not call up Excel, although it believes that it does. The computer is running Win7 Ultimate sp 1 64, Office Home and Business 2010 sp1 32, Inventor 2012 sp2. The software (windows, office) is up to date, I have done the registry edit that other sites have mentioned.
I will bring up an .ipt, right click on Table, click on Edit via spreadsheet. I will get a circle for a cursor for a moment as if it were processing, then nothing. I right click on it again, and just get the How To option, so it believes Excel is open when it is not.
Is it possible to extract coordinates to a spreadsheet or display them on screen of points in AutoCad. I would like to know the coordinates of all the intersections of the lines in the model shown in the attached pdf. The 3d model was drawn in Revit as model lines. If there is a simple way to draw this shape in AutoCad, it is part of a torus.I imported it into AutoCad as Revit had a few limitations.
View 5 Replies View RelatedI have just inherited a project where I have been asked to supply our purchaser with a list of non-stocked fixings.
OK so far, i hear you ponder, but the designer for reasons of speed (his words) didn't add the fixings to the assmbly!
Is there any way to list all tapped hole features to an excel spread sheet so that i could then just sort and count and then be able to hilite the specific parts in inventor to find the length?
The prospect of looking at each individual part for tapped holes fills me with dread (shudder).
HP z210 16Gb ATI FirePro5800
Autodesk Produst design Suite 2012
Trying to figure out the best method to insert an IDW into an Excel spreadsheet without sacrificing quality. I have tried several methods to go straight from Inventor(2012) to Excel(2010) using print PDF at press quality, export JPEG, and even the snipping tool as a last ditch effort all of which inevitably loose all line quality when inserted to Excel.
I have only had success bringing a PDF from Inventor into Adobe InDesign where I am able to mimic the design of my Excel spreadsheet and create an additional PDF to include with the Excel document. It seems like there would be an easier way for Inventor and Excel to work together without sacrificing quality or adding additional steps.
Got a new computer, put AutoCAD LT 2010 on the machine, justlike the rest of the office, but also installed excel 2010, when the rest ofthe office has 2007. when insertinglinked spreadsheets from the new computer, and we update the links on our oldcomputers, Acad fatal errors out. Thisis because of the difference in the excel versions correct?
View 1 Replies View RelatedI have an Excell spreadsheet with X,Y, and Z coordinates.
I wish to import it into Revit and create a Topo surface from the spreadsheet. Is this possible and if so how do i go about it.
I am trying to export some data from my BOM. I require the part names, quantities and lengths. I have followed a previous topic in these discussions which is now closed. it seems simple to follow but requires me to click on the export BOM icon in the top left of the browser. In my instance this is greyed out. D
View 4 Replies View RelatedHow do i create a spreadsheet for title blocks. i want to be able to fill in a spreadsheet and automatically fill in the title block....
View 1 Replies View RelatedI have been trying to plot an excel spreadsheet within LT2009. See attached files.
Test Adobe.pdf was created using "Adobe PDF" driver, paper size A3. Looks good except for the exta lines running through columns 1 and 9.
Test Dwg to.pdf was created using "dwg to PDF.pc3" driver, paper size ISO A3 (420x297mm). The excel portion looks good but it has cut off the border all around.
Border size is 410mm x 287mm.
Using Acrobat 9 Pro and MS Office 2010.
If it's possible to import Excel spreadsheets into my drawing, instead of using the tables? (Using AutoCAD LT 2014)
I guess technically it would be easiest if I could import LibreOffice Calc spreadsheets, but I can get access to Excel easily enough if it's the only option.
On several projects there are long lists of images linked in the Illustrator file. I need to find a way to export the names of these links to a spreadsheet for another department to reference. Is there a way to do this (in Illustrator Cs5 or CS6)?
View 1 Replies View RelatedI have a document that I would like to import an Microsoft Excel spreadsheet into.
Basically, my document is a diploma that can range anywhere from 15-250 different names and corresponding dates with those names. It would save a great deal of time if I didn't have to manually type the names and dates into their respective spots.
I have a Microsoft Excel spreadsheet that if possible, I would like to autofill the information into the Illustrator file.
Between the second & third lines of text is where I would like to enter the first column of text. It would be NAMES that go here.
Then, between the fifth & sixth lines of text is where the second column of text from my spreadsheet would go. This area would be filled with dates.
I would like to use a multi-value custom iProperty 'item_finish' in the part or assembly model to drive an iLogic rule.
'item_finish' would be 1-24 from the list.
The part file would have an embedded spreadsheet with column A corresponding to the 'item_finish'.
The spreadsheet would have column B containg long text descriptions of the finish process.
The ilogic rule must take the 'item_finish' number, find the corresponding row and then return the B column cell text to a user parameter 'defined_finish'.
The 'defined_finish' parameter can be called in a sketched symbol to describe the finish.
It appears this is all possible, but I cannot find enough information describing the snipped code requiremnets to accomplish the goal.
Using AutoCAD 2010, and I'm having problems printing with one dwg, that I've had to copy an Excel Spreadsheet into. The spreadsheet was created with Excel 2007, and has quite a bit of text in it, and I'm trying to print it on an E size sheet, to an HP Designjet 4000. AutoCAD hangs up each time I try to print this, and my computer gets a message indicating that I'm low on disk space, even tho I do have plenty of space. It's like Autocad is taking more resources than it normally should. How I can insert this spreadsheet into AutoCAD and be able to print it? I've inserted the spreadsheet in model space, and the titleblock/border is in paperspace. I've tried printing to pdf and exporting to other formats to see if that will work, but AutoCAD keeps hanging up. Any other AutoCAD dwg works fine to print to the printer. It's just this one file with a spreadsheet inserted into it.
View 5 Replies View RelatedI am using Auto Cad LT 2012. How do I import an Excel spreadsheet into my drawing?
View 2 Replies View RelatedIm struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
[URL]
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...
I am working on a gearbox design that requires multiple iterations on the shaft dimensins and other parts, so linking the dimiensinos to a spreadsheet would make this easier. However, I'm using the design accelerator for the shaft and other components and I cannot find any information on how to connect the dimensions I enter in that design accelerator to a speadsheet.
I know how to link to a spreadsheet for a regular component, but haven't used that much.
Is there a way of inserting points from an excel spreadsheet that come into the part file already fixed, instead of manually selecting the points and selecting the fix constraint?
View 2 Replies View Relatedwhat is the easiest wqy to extract information from an attrbuted block into a spreadsheet (excel)?
View 1 Replies View RelatedI try to edit the table of an iPart via a spreadsheet (EXCEL 2010) and it does not launch EXCEL. I saw other posts with changing the registery and I am not too confident on what to remove or even how to do it.
View 6 Replies View RelatedI need to find a way to export my BOM data to an Excel spreadhseet. Some of my BOM's are in tables, most are not. I found a lisp routine that will export this data to a csv file, but it's clunky at best. I don't want to use the "ole" method, I don't feel like fighting that battle.
So outside of plotting to a "png", and pasting that into Excel, are there any other options that are feasible?
°°AutoCAD Rel 1 - 2014°°