AutoCAD Inventor :: ILogic To Insert Row Into Excel
May 28, 2013Is it possible to use iLogic to insert a row into excel?
View 1 Replies
ADVERTISEMENT
AutoCAD Inventor :: Insert IDW Into Excel Spreadsheet
Feb 15, 2012Trying 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.
AutoCAD Inventor :: Insert An Excel Into Drawing
Nov 20, 2013I`m trying to insert an excel spread sheet in to inventor drawing, for some reason inventor cuts off 2 last rows. Is there a limit of how many rows can be inserted ?
it cuts off these two: see attached.
13.2 45FT R2440 Gasket Material Vinyl Foam Strip 2" wide x .125 thk., Black, Weather-Resistant
14 12 TUBES C11272 CAULK, SILICONE - CLEAR
AutoCAD Inventor :: Insert To Lenght Table From Excel
Jul 16, 2012I have problem when insert too lenght table from Excel.
Inventor cut column...I used Manage -> Insert Objec
AutoCAD Inventor :: 2011 - Insert Excel File In IDW
May 9, 2012Trying to place this .xls file into my idw. Does not work too well. Part of the worksheet is cropped off and the images are out of place.
Here is what I'm getting.
Is there a way to get this to show on the drawing. I am using the Manage>Insert Object command.
AutoCAD Inventor :: ILogic And Excel Link
Sep 3, 2013I am trying to use an iLogic Excel link to define the hub and bushing dimensions for a wing pulley part file. I get an error: GoExcel: Could not match the column title: "Size". I've attached the part file and Excel file. The iLogic rule in the part file is called Hub_Bushing.
View 9 Replies View RelatedAutoCAD Inventor :: Create Sheet In Excel With ILogic
Jan 9, 2014I am trying to create a new sheet in an existing excel file and can not figure out how to do it.
I am trying to export parts lists from multiple drawings to an exisitng excel spreadsheet and I'd like have each on their own sheet. I can do everything but create a sheet. How to do this in iLogic?
Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB
AutoCAD Inventor :: ILogic Excel Date - How To Format
Jan 7, 2013I want iLogic to look up todays date in an excel file and then pull information from that row.
The problem I have is that it doesn't seem to like / or - so I am not sure how to format the date.
How would I format my date in Excel so that it matches the wway Inventor stores it in iproperties>Project>Creation Date?
Inventor 2013
DwgNum = iProperties.Value("Custom", "Dwg Number")Client = iProperties.Value("Project", "Vendor")Description = iProperties.Value("Project", "Description")DrawingType = iProperties.Value("Custom", "Drawing Type")author = iProperties.Value("Summary", "Author")Date2 = iProperties.Value("Project", "Creation Date")i =
[Code] .........
AutoCAD Inventor :: Using Excel And ILogic To Control IParts
Jan 9, 2012I am currently using iparts/assemblies to model a resistor bank. We have dozens of different configurations and currently each time we need a new one its is re modeled from scratch.
I have created an assembly with all my relevant parts and controlled it through parameters to auto update when key values are changed.
What I would ideally like to do is to either link my two iparts to the iassembly though the excel sheets they use. Currently I have to added each variation to the parts first and then added the parameters to the assembly.
Would it be possible to have a master sheet were all control values are inputted and then each excel sheet for the different parts are linked to this?
As the excel sheets are saved in the temp file and are deleted once you have finished editing I have found it hard to do this so far. Can I change where they are saved? I tried save copy as which created the file but inventor did not link to it.
If this is not possible can I utilize iLogic to input the key values and then write them to a new row in the table. I have created a rule already to limit the number of elements and also the length of the by's (the space between each supporting rod). I have included a zip file with all my parts in it.
AutoCAD Inventor :: ILogic / Export Parameters To Excel?
May 21, 2013I 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
AutoCAD Inventor :: Get New Part Number From Excel With ILogic?
Jan 28, 2013I have made a configurator, that defines my part. Now i would like to add some intelligence for the Save process...
When i activate my rule it should.:
1. Go to a Excel spreadsheet and find next Empty cell in a specific collum
2. Place Title from inventor in that empty cell
3. Return the value from the cell next to this cell
3. Use this value as the new filename for my part.
Example: here i would like to get the parts tile put into B3 and A3 (103) returned to Inventor as filename to my part
--------------------
A B C
1 101 Title1
2 102 Title2
3 103
If possible, i would like to be able to adjust this alittle as i go forward in my work,
AutoCAD Inventor :: ILogic Excel Save As Command
Dec 12, 2012I have an ilogic rule to open an existing excel file template and export the inventor parameters into it. I am trying to find a way to then save the excel file as a different filename. This way the original template can stay unmodified. I have found the GoExcel.save command but is there some sort of GoExcel.saveas(filename, filepath) command?
View 2 Replies View RelatedAutoCAD Inventor :: Populate IProperties From Excel Using ILogic
Jun 27, 2011I am trying to use an iLogic rule to populate iProperties (some generic, some custom) from a part number spreadsheet (containing columns such as PART NUMBER, DESCRIPTION, FINISH etc) and the rule keeps throwing up the following error 'Conversion from string "" to type 'Double' is not valid.'
Here’s part of the code (would be extended for the required custom iproperties but I’m assuming the same principle is ok)
StartRule:
'read excel file
GoExcel.Open("C:DESIGNDocumentsEXCEL FILESPART NUMBERS", "PARTS")
'index row 3 through 10000
For rowPN = 3 To 10000
'find first empty cell in PART NUMBER column (Column A)
If (GoExcel.CellValue("A" & rowPN) = "") Then
[code]...
Changing the format of the excel data (number or text) has no effect. Is manipulation of the format required so that Inventor can read text and numbers to iProperties in this way?
AutoCAD Inventor :: Using ILogic To Search Through Excel Worksheet
Jul 25, 2011Is there a chance could shoe me how to use iLogic to create copy of part by first searching through an excel worksheet columns, if the name exist in excel worksheet then donot save else create a copy of the part or save as whatever name is defined in the iLogic code.
Core i7-2630K
12GB dual channel Corsair XMS3
Nvidia quadro 2000
128 vortex 2 SSD
WD 7200rpm Black
Asus P8P67 DELUXE
Product Design Suite 2012 Ultimate
AutoCAD Inventor :: ILogic - How To Create Excel File
Jun 27, 2012How to create a excel file using ilogic?
View 6 Replies View RelatedAutoCAD Inventor :: ILogic To Specific Column In Excel Template?
Apr 30, 2012i want to export my part list with ilogic in a excel template but dont want all the part list column and dont erase the column i skip in excel?
View 3 Replies View RelatedAutoCAD Inventor :: ILogic To Find Next Free Cell In Excel
May 27, 2013What im trying to do is take the i properties from an inventor .dwg, and place them into a specific excel spreadsheet. I've managed to get so far, by using code that Curtis posted, which does the opposite of what im looking to do.The code Curtis posted takes info from excel and fills in iprops.
I can fill in specific cells, for instance columns A, B & C on Row 1 and place that info into a specific spreadsheet. But my code falls down when i run the code on another .dwg, It obviously overwrites what was previously in those cells.... I am looking for the code that looks to see if those cells are in use, and if so, go to the next available cell down.
AutoCAD Inventor :: ILogic And Excel Spreadsheets - Linking Values
Mar 6, 2012Ok 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.
AutoCAD Inventor :: (iLogic) Change Excel Chart Location
Nov 29, 2010I have an embeded excel chart on my drawing called CLASS 125 Single Disc.xls. I want to switch this chart with another one known as CLASS 150 Single Disc.xls. How do I do this? I am using Autodesk Inventor 2011.
View 9 Replies View RelatedAutoCAD Inventor :: ILogic - Export Custom Table To Excel
Mar 11, 2013I 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 RelatedAutoCAD Inventor :: Delete Column In Excel File - ILogic
Oct 23, 2013Is there any way using ilogic to find a value in an excel file and delete the column that value was found in?
View 1 Replies View RelatedAutoCAD Inventor :: Insert OLE Object Link Via ILogic
Nov 16, 2011I have a requirement to insert PDF files via an OLE object link into a large number of .iam and .ipt files. Is there iLogic code out there that will perform this feat? The plan would be to gather all file names and associated pdfs in an excel spreadsheet and run the iLogic against that.
i7-2720QM Dell Precision M6600, Win 7 Pro 64-bit, 8GB RAM
Autodesk Product Design Suite Ultimate 2013
Autodesk Vault Professional 2013
AutoCAD Inventor :: Insert Surface And Extrude To It Using ILogic
Oct 11, 2012I’m a design engineer for a company that make press tooling to manufacture parts. I am trying to automate the design process using I logic. I know the basics but the part I’m having trouble with is importing a surface.
Our process is to 3D scan the part which then gets a surface from this and extrude up to the actual surface.
Is there any way in ilogic to automate this process. Ideally I would like it to come up with a browse button you select the surface file .stp or .iges. Once the surface is in the part file it extrudes up to the surface from a plane.
AutoCAD Inventor :: Insert Sketch Symbol Using Ilogic?
Aug 15, 2013I want Inventor to add sketch symbols automaticly on cordinates according to a Custom Text Paramater
for example I have created Custom Multi Value Text User parameter Approved & Not Approved or Plate Work Notes & SteelWork Notes wich each represent diffrent sketch symbols that needs to be placed out base on the value selected. Each sheet consist of diffrent sketch symbols
AutoCAD Inventor :: Insert Sketch Symbol Using ILogic
Mar 21, 2012insert a sketch symbol to a specific coordinate on a dwg border (top middle of dwg)
Workflow needed is as follows
Copy Sketched symbol folder from Standard.dwg from (C:UsersPublicDocumentsAutodeskInventor 2012Templates.Paste into open dwg document and yes to all to overide symbolsPlace a named sketched symbol from drawing resources folder ie (PRELIMINARY) to top center of all sheets within documentreturn to first sheet when complete My new dwg has symbols in correct place so any new dwgs this is ok but we need to add it to hundreds of dwgs when opened or revised,so i want to tie this to external rule and trigger on save event.
AutoCAD Inventor :: ILogic Syntax For Searching In Excel And Update IProperties
Dec 17, 2013I want a ilogic rule syntax for following process:
I have one excel sheet it consists around 5 sheets for Plate, Flats, Rounds, etc. When i am run the rule then it will ask and do the following:
Ask the thickness value.It will search thickness value in “D:LINUS KOTTEstock numbers.xlsx” in sheet 1If thickness value found then fill the stock number in iproperty(project tab-stock number)
Here i am using different rules for plate, flat, round, etc.,
AutoCAD Inventor :: ILogic - Replace Or Refresh Embedded Excel Spreadsheet
Sep 20, 2013For Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.
For now i use the following rule:
For I = 65 To 90 '65=A 90=ZBuchstabe = Chr(I) GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:KonstruktionVorlagenMaterialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")Next I
it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.
Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?
AutoCAD Inventor :: ILogic Rule To Retrieve Part Number From Excel
Aug 15, 2012iLogic rule that will retrieve a part number(s) from an excel sheet. I work for a company that built vacuum trucks and I'm trying to make an . I am template where the user can select different lengths of shells to achieve the desire overall length. I have been able to achieve this using iLogic rules and forms and making the shell length parameter multi value.
But now I need to show predetermined SAP part numbers for the shells in BOM or part list. I all ready have an excel sheet with shell sizes with corresponding part numbers on file. I also thought about incorporating our custom CC parts/shells that already have the SAP part numbers set up as a custom iProperty but might be to complicated for a newbie iLogic user.
AutoCAD Inventor :: Unable To Open Or Communicate With Excel And ILogic (2013)
Nov 20, 2012I'm unable to open or otherwise query an Excel spreadsheet.
I get the following error message. see attached.
What steps must I take to open and query Excel spreadsheets?
I'm using Inventor 2013, Excel 2007 and Vista 64.
Inventor 2012
AutoCAD 2012
Product Design Suite Ultimate 2012, 2013 & 2014
AutoCAD Inventor :: Embedded Excel Spreadsheet (Open / Save And Close) (iLogic)
Apr 30, 2013I have some code (below) that will open my embedded excel spread sheet and it works great. Now I need the code to save and close the excel file after it’s been open.The embedded excel spreadsheet pushes some stuff the model and does a couple other thing. So all I really need is for the excel file to open, save, and close when the rule is run.Imports Inventor.
OLEDocumentTypeEnumExcelApp = CreateObject("Excel.Application")Dim ExcelFile As ReferencedOLEFileDescriptorExcelFile
=hisDoc.Document.ReferencedOLEFileDescriptors.Item(1)ExcelFile.Activate(kEditOpenOLEVerb, ExcelApp)
AutoCAD Inventor :: ILogic - MultiValue Parameter - Get Named Range From Embedded Excel
Jan 9, 2013I have a MultiValue Parameter that I want to populate using a named range from an embedded excel spreadsheet. I would like an iLogic solution if possible because I need other people to be able to understand the code without too much difficulty.
One of the sample snippets given allows access but not if the excel file is embedded.
'GoExcel.NamedRangeValue("Part_Width")
The code below works but not when using a named range.
' Load bearing housing typesMultiValue.List("parameter1") = GoExcel.CellValues("A1","A20")
Is there something I'm missing? I was hoping to use something like below
' Populate MultiValue Parameter from excelMultiValue.List("parameter1") = GoExcel.CellValues("3rd Party:Embedding 4", "Sheet", "myNamedRange")