I would like to be able to export the description column of a BOM to an excel file, and exclude all the other data. I can't see any reference to doing this in the API. We have almost 20 columns so deleting them once the file is made is a bit of a pain.
View 3 RepliesProblem:
How to read real number data from selected columns in an Excel spreadsheet into an illustrator javascript array variable, so that then I can use this information to construct an illustrator polygon.
Further information:
I am new to javascript (and not much of a programmer in the best case, but do have some basic knowledge using ancient languages like FORTRAN 88). I am sure I am just missing an important step here despite all morning browsing with Google for answers (something to do with variable definition I assume?). I have some survey data defining the outline of features in map view listed in a string of point (x,y) values in adjacent columns in excel (these x,y point values calculated from GPS data using a commercial program to converted 3D position to a 2D x,y by geoid projection, and then in excel to re-scale point locations to illustrator’s artboard). What I am trying to do is select columns of x,y value pairs in an excel spreadsheet, copy these values to the clipboard, and then develop an IA JavaScript to draw a polygon through the specified set of x,y points. It seems easy enough to script illustrator to draw the polygon once I get the values from the clipboard are in a javascript array (lots a good tips here [URL] ....), but pulling in the clipboard data seems to be beyond me. I have tried populating a defined array with various combinations of array declarations and app.paste(); or windows.clipboardData.getData('text/plain'); with no satisfaction. I then had the idea to try to pull in the clipboard to one long continuous string, place that in a text box (see see its structure), andthen read and split up the text in a loop to populate the JavaScript array…but that deposited a complex illustrator table object into my text box, and several attempts to force the clipboard to paste text did not work (again probably having problems understanding variable type declaration).
I would be happy to find any method of scripting the pull of the selected on an excel spreadsheet for use in an Illustrator script…so if I am making this all harder than it needs, be I would be grateful to know that also!
I got this routine off the In The Trenches blog and am trying to change it, some. For some reason when I export I can only get 4 columns to export. So what the heck am I missing here? The Part List I am using has all the colums I am trying to export on it.
'-------------Start Of ilogic ------------------------------------------------
'get the path and name of the drawing file
path_and_name=ThisDoc.PathAndFileName(False)' without extension
'define oDoc
oDoc=ThisDoc.Document
[Code] ....
Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB
I have assembly with over 100 sub assemblies. I need to export the COG for each sub assembly to excel. The COG must be in relation to the parent assembly's origin point.
I can get coordinates manualy (right click on sub assembly - iProperties-Phisical), but it is take a lots of time.
Autodesk Inventor Professional 2013
Windows 7 64-bit
How do I get a BOM exported from my assembly into Excel? The only option I have is export as XML format which is useless to me.
View 9 Replies View RelatedI created a program to export the Assembly BOM to Excel. I am running into a some strange behavior regarding Weldments and Inseparable assemblies. Here is a snippet of my
'Create BOM Object
Dim oBom As Inventor.BOM
oBom = oAssyDoc.ComponentDefinition.BOM
oBom.StructuredViewEnabled = True
oBom.StructuredViewDelimiter = "."
[code].......
'This is where I put my code to export and write the file.
Next
I run into the issue of the items inside a Weldmant assembly is not being exported. Yet I am able to create a structured multilevel partslist on my drawing showing all the items inside the Weldment.
Whats strange is that even if I change the Weldment assy’s BOM structure to Normal, it still does not make a difference. Is there a way to get the items of a Weldment into my BOM Rows object so that it will export? Whats strange is that if an assembly is set to “Inseparable” but is not a weldment then it exports the contents.
I tried to export BOM to excel with Thumbnail. May I know how to do that. I am using IV2010.
View 8 Replies View RelatedI 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 RelatedI have created a quick tool to export the contents of Inventors Structured BOM to Excel including the Thumbnail. One of our customers requested it and I could not find another way of doing this so I created a little app for it.
Download: [URL] ........
Im 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 want to export reference parameters to an excel table using i-Logic
I found the function GoExcel.CellValues("filename.xls", "Sheet1", "A2", "A10") = MultiValue.List("d0")
It looks like the syntax calls for the file location and name if the xls file is not open and if open is not supposed to be required.
I have entered it both ways and with and with out the target file open and with the function GoExcel.Open("pathFilename.xls","sheet1") and continue to get the error:
we couldn't find C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls. Is it possible it was moved, renamed or deleted?
Also, I was expecting that to fill in the sheet cell's would be MultiValue.List("d0","d1","d2")
but the system give me an error that says
Error on Line 3 : Overload resolution failed because no accessible 'List' accepts this number of arguments.
See below
GoExcel.Open("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST")GoExcel.CellValues("C:AbellAbell VaultWorkSpaceDEVELOPMENTAC100-0100MRLTEST Table.xls", "AC-100-0101003-TEST", "A2", "A10") = MultiValue.List("d194_A")GoExcel.Save
You can't export parts list to Excel file but you can export CSV file without any problems.
View 3 Replies View RelatedI want a part number which is made with a parameter write to excel to the excel sheet to link to acad. I have the following code that runs smoothly and requires the excel sheet to save but get nothing written in the cell.
GoExcel.CellValues ("M: AutoCAD AutoCAD 2012 Inteco3D File Test ExportPartNumber.xlsx", "Sheet1", "A1", "A10") = MultiValue.List ("Part Number")
I have a drawing with multiple sheets (spool drawings) all with there own parts list and I need to export them all to excel. This takes a long time when you have 100 sheets. So my question is how can I do this, how should the code look like?
View 2 Replies View RelatedIs there a specific reason that you can only export a parts list from a .IDW to a MS Excel 5.0/95 format? Is there a conflict with the newer formats of Excel?
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
I have a script which saves the flat pattern from a sheet metal part as a dxf file. But we also have standard part files that we save a face as a flat pattern. So I'm looking to be able to select a face then run a script to save the selected face as a flat pattern in a dxf file.
View 1 Replies View RelatedI'd like to save a position representation to an image, but if I do this, it will save the master representation. So, how can I export a selected view?
Software: Inventor Series 2011 SP1 x64
OS: Vista Business x64
CPU: E6400
RAM: 2*2Gb GeIL
VGA: Quadro FX 550
I tried Curtis Waguespack's iLogic: Export Parts List with Options, and it works great on Part Lists. I'd like to do the same thing on a custom table, but I don't know what needs to be changed.
View 3 Replies View RelatedI'm trying to build a VBA code in inventor 2010 to export the Center of gravity coordinates (X,Y,Z) from an inventor assembly to an excel sheet.
But I'm not able to get the iproperties for the COG from my assembly.
I have been searching for a macro to export the start and end point of a line coordinates to excel, but I can only find information on how to export 3D Points.
Is it possible to program a macro that allows me to export the start and end point of various lines in a sketch?
The objective of this is to connect an excel file which is updated when I create a line with it correspondent points, then i could not only import these x,y,z coordinates from excel to inventor but I whould be able to update my spreedsheet whenever I change my sketch.
When 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 RelatedI'm wanting to know if there is a way to Copy a selected area from Excel and Paste into Autocad and have it as lines and text objects?
Before everyone is entering the information in RED multiple times, once in excel and again in our cad file.
I don't want a data link because we are sending, only, cad files to our customers.
When I am exporting a jpg from CorelDraw X6, I keep getting random columns of white pixels to the right of the graphic image. If I switch the matte color in the export dialogue to black, I get random amounts of black pixels. In X4, when I would export a jpg, the resulting file would be cropped right to the image edge, with no extra pixels. I'm getting anywhere from 1 to as many as 8 columns of extra pixels on the right hand side, which is problematic for utilizing the resulting files for page layout.
I achieve the same results when choosing "Export for Office" and "Export for Web".
I'm running a 64-bit install on a Win 7 64-bit box.
Is there a way to get columns in form? I would like to put
Hole F Type { List the types} Hole F Location {input box}
Hole N Type { List the types} Hole N Location {input box}
Hole G Type { List the types} Hole G Location {input box}
If not this form will be off the monitor.
I'm doing a revision rearrangement and would like to add to the BOM New, Existing, and Relocated properties. The problem is that each individual component may be unique. Ie. I have a desk w/ 3 identical monitors. One monitor is existing and the others are new. I'd like to have the BOM show that I have 3 monitors, 2 are new and 1 is existing. The BOM would have 4 columns, one for the total number of parts and 3 for the New, Existing, and Relocated counts.
I don't mind if the new columns need to be manually updated.
Is there a way to set the decimal place for the columns in Autodesk Inventor 2011? I have a length column I am trying to use for the p/n but I need it to be 2 places and they show up from zero to 4 dec places. I have set it inside excel but it never retains the setting.
View 9 Replies View RelatedI am currently working on a project where I am taking a lot of Autocad Attributes and Exporting them to an excel file so they can be referenced in a table of contents type of manner. My question is if there is a way to have excel automatically update the tables after changes are made to the autocad file. This file is an ever changing thing so going back and running through the entire "Eattext" command and re exporting and overwriting the existing file is very tiresome, especially when I am adding and deleting attributes daily. Is there a VBA program I can run to accomplish this task, I have fairly limited VBA skills and haven't written in VBA for years. I am fairly new to exporting autocad attributes to excel . I attached a very simplistic example of the general Idea of what I am trying to accomplish.
View 3 Replies View RelatedI want to export a table to excel but i am failed.and is here any way that when i give coordinate it automatically exportes to excel.
View 2 Replies View RelatedIs there any way that values in BOM columns would automatically change depending on the characteristics of the part?
Example:
I have a parametric metal rod that depending on its length has a different part number assigned to it in our company's catalog.
When I change its length in parametric assembly (50" rod is has different number than 70" rod) I want the part number to change as well in the "part number" column.
Is there is any way to re-arrange the columns in my ipart table without having to delete all of my parameters and then adding them back in the order that I want them to appear in? I would like certain information grouped together instead of having to scroll back and forth across the row to edit certain parameters.
View 5 Replies View Related