AutoCAD Inventor :: Excel Linking / Special Characters?
Aug 30, 2013
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?
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?
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.
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.
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.
Is there a way to find and/or replace "very" special characters like [carriage return], [backspace] or even [tab mark], considering that the first thing that comes to mind when saying special characters is the standard and extended ASCII only.
I'm trying to write a simple Custom Command that sets any layer that matches "$-*" to a specific color. But as soon as AutoCAD sees the $, it thinks I'm trying to do a DIESEL expression. Supposedly, the quote marks specify that the enclosed characters should be treated as plain text, but that doesn't happen.Here's what I've got:
^C^C-LAYER;C;252;"$-*";;
And this is what I get:
Command: -LAYERCurrent layer: "$-HATCH-00-002-PW-BOAT"Enter an option [?/Make/Set/New/Rename/ON/OFF/Color/Ltype/LWeight/MATerial/Plot/Freeze/Thaw/LOck/Unlock/stAte/Description/rEconcile]: CNew color [Truecolor/COlorbook] : 252Enter name list of layer(s) for color 252 <$-HATCH-00-002-PW-BOAT>: "No matching layer names found.Enter an option [?/Make/Set/New/Rename/ON/OFF/Color/Ltype/LWeight/MATerial/Plot/Freeze/Thaw/LOck/Unlock/stAte/Description/rEconcile]: It stops, hanging at the incompleted -LAYER command prompt.
I've exported the ePub file from InDesign CC and found some special characters are looks as box i.e., as junk. But while unzip the ePub and open the particular XHTML in internet explore, it displays fine.
I've been wanting to upgrade to CS6 but have one issue that is preventing me from using it exclusively during testing that did not occur in CS5.
When typing special characters the formatting jumps all over the place and the speical characters end up at the end of text and not where I typed them.
It seems that I cannot enter a special character into the text of a title with Alt-0xxx, even though this works with just about all other Windows applications. Is this a feature or a bug? Or is there a way to do this that I'm unaware of?
For the moment I'm entering the special characters into a text editor, then copying and pasting them into the title, which works, but is awkward. I don't understand why VideoStudio doesn't let me enter the characters directly.
The characters in question are things like typographic quotes, some accented characters, bugs like copyright and registered trademark, and other things that are not unusual to need to use in a title.
I'm experiencing a very bizarre problem in CS with a font special character. I used Extensis Suitcase to examine all the font characters for a particular font that I'm using on a project. The character mapping shows the key combination for the character I want is (on a Mac) Option/Alt + Z.
This works in every other application on my computer, including my email application, but for some reason, within CS it brings up the Omega character. Any idea why this happens and how I change it? I even tried to type the character in Word and cut and paste it into Photoshop and it changes! What gives?
I want to type in gimp(using text tool) with some special characters from my native language like(ā, ē, č, ķ, ģ). If i try to do it in gimp I get á, é, ć, ḱ, ǵ. Are there some settings or plugins that allow me to type these non-English characters like I do it usually.
when I used VS 10 and VS 11, I was able to enter special characters in Titles (captions) by pressing [alt] and the special character number. For example, when I need a ñ (n with a tilde on top, found in Spanish words), I pressed [alt] and 164 at the same time. However with VS X2, it does not work and I could not enter special characters in Titles. is this no longer available in VS X2 or I did something wrong in the settings/configuration of VS 12?
Windows 7; Photoshop 13 (CS6).I am typing some text in a new layer; no problem so far. I need to insert some special characters that are not on the keyboard, e.g.TōkaiThat also was not a problem; I copied the character from the Windows Character Map.
Now I want to copy/paste more special characters from the Character Map, e.g. ☏ (U+260F) or ✉ (U+2709)
Now all of a sudden this does not work; the pasted characters appear in Photoshop as a boxed X.The font I have been using was Arial, but when I pasted these Unicode characters, the font automatically changed to Myriad Pro. Changing the font back to Arial does not alter the boxed X.
I took these Unicode characters from the Character Map using font Arial Unicode MS. That font does not appear in Photoshop.Questions:are there any Unicode fonts available in Photoshop?is there any other way to paste such characters into Photoshop?
I'm running into an issue when conducting an XML Merge.The situation:
- Document has been structured using tags so that it could be exported to XML - The XML document was then translated by professional translators into Russian from English - All XML tags in English/Russian version are the same, no XML has changed - XML Merge is conducted and all content is placed into the the InDesign document and the English/Russian content both has the proper tags selected - Russian content however, does not include any special characters such as line breaks, or spaces. This is causing Paragraph Styles to be wrong, and essentially the whole document is formatted incorrectly
The Question:
- How can you include special/hidden characters such as line breaks into the original XML Export? I keep getting the error "Content contains characters that can not be encoded" - If line breaks are included and are inserted into XML, when I conduct the XML Merge will InDesign recognize these codes/characters that are between the XML Tags?
When I try to paste in any collection of cells from excel using "paste special" C3D crashes. I'm using 2010. It crashes trying to paste into any drawing, and any group of cells.
My error is:
Unhandled Access Violation Reading 0x209519f8 exception at 478f56h
I use several scripts in Illustrator. Some of them I use in this way: [URL] ....
Now I tried to built in two other scripts in the palette. In this scripts it is required to use special characters in variables. Standalone these scripts are work correct. Here is an simple example:
// exampleScript.jsx var a = 'u201d'+" example "+'u201d'; alert(a)
I get this (correct) result:
But when I call this example script with bridge talk:
var scriptToLoad = new File(pathToScript + "/exampleScript.jsx"); var win = new Window('palette', 'own palette'); var btnSelect = win.add('button', undefined, 'example'); [Code] .....
Well 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 have line in the drawing that exists on layer A-Wall it has different lineweight 0.05 from true wall. Now usually my routine : i select this line and then select similar to convert it to layer glazing.
i need lisp that by one command convert the objects on layer A-wall with layer 0.05 only to glazing.
I'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.
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.
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.