AutoCAD Inventor :: Delete Column In Excel File - ILogic

Oct 23, 2013

Is 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


ADVERTISEMENT

AutoCAD Inventor :: ILogic To Specific Column In Excel Template?

Apr 30, 2012

i 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 Related

AutoCAD Inventor :: ILogic Error Cannot Find Excel File After Saving File As Template

Dec 6, 2012

I'm linking an excel file to an .ipt file with iLogic code determining if the Material type is a certian value it will find the correct material thickness. These file work great when working on them thru Vault but when I "Save As Template" and create this file where our other template files are located (not Vault) this fuction does not work. I have realized that I had to place the a copy of the excel file in the same file folder as the template ipt, but even this does not fix the issue. 

I recieve this error:

Error in rule: Material, in document: Part6

'MWW Materials (Inventor).xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.

It seems completly countintutive that just saving the file as a template file would cause this not to work when all files that are required are located in the same file folder. Maybe I need a reference to the excel document within the iLogic code.

View 3 Replies View Related

AutoCAD Inventor :: ILogic - How To Create Excel File

Jun 27, 2012

How to create a excel file using ilogic? 

View 6 Replies View Related

AutoCAD Inventor :: How To Delete All Parameters In A File With Ilogic

Aug 22, 2012

Working code ...... attaching file

Auto = iLogicVb.Automation
Dim iLogicAuto As Object
iLogicAuto = Auto
Dim oDoc As Document
oDoc = ThisApplication.ActiveDocument

[Code]...

'but now something more i wanna do is...... delete parameters

        If Not (param Is Nothing) Then
        
            For Each param In params
            i = MessageBox.Show("Checking for Parameter in File")
            i = MessageBox.Show("No.of Parameters exists are ="& param.count)
 
[Code]....

View 5 Replies View Related

AutoCAD Inventor :: Open Excel File (start Application And Show Worksheet From ILogic)

Nov 11, 2013

I'm trying to start Excel and show the results of some BOM items I have written to a file like item number, part number and description.The task is to find components in an assembly that have a part number longer then 39 characters, due to ERP limitations.

What I´m doing is cycling through all BOM (structured) items on first level and check if the part number is longer then 39 characters.

I write these item number, part number, description to an Excel file (temp.xlsx), so the user sees which Components he has to check for the Part Number (make it shorter). I figured it would be best to do that with an excel file, so the user can save the results to a new file or just check it.

Values will be erased from the temporary excel file afterwards.Here I can't figure out how to start the excel application and open the file in an actual application window if possible.

how to list the results with plain iLogic that would do it too or some other solution to list a snapshot from the BOM.I guess there is no way to add your custom BOMViews ?

View 6 Replies View Related

AutoCAD Inventor :: Inputting Comment Column In Excel Spreadsheet

Jul 26, 2012

My "parameter names" and "value" columns fill in under the Inventor Parameter chart, but for some reason I can't get the comment section to fill in.

Inventor 2011
07 Excel
Inventor 2011
Intel Core 2 Duo 2.93GHz
8GB RAM
Windows 7 Pro

View 1 Replies View Related

AutoCAD Inventor :: How To Delete Custom Iprop Column From BOM

Feb 7, 2011

I have an assembly with a custom iproperty column that filled a need that has recently been removed. How do I delete the column from the BOM editor? I realize the iProp will still exist in the part files, I just want it gone from the BOM editor when I open it. I thought I could just delete it from the "Add Custom iProperty Columns" button but no dice.

Inventor Professional 2013 (SP-2.3), Product Design Suite Ultimate
Desktop: Intel Core i7 3.4GHz, 16.0 GB RAM, Windows 7 Ultimate SP-1, 64-bit OS, (2) GeForce GTX 580 (331.81), Space Pilot Pro (3.16.1)
Laptop: Intel Core i7 3.9GHz, 16.0 GB RAM, Windows 7 Pro SP-1, 64-bit OS, GeForce GTX 780 (331.81), SpaceNavigator (3.17.7)

View 6 Replies View Related

AutoCAD Inventor :: ILogic / IPart Custom Column Value Setting?

Dec 3, 2010

it is possible to set the value of one or more "custom" column of an iPart row.

Per example woul this iLogic method work?

iPart.ChangeRow("iComponentName:1", "RowMemberName", customParam1, customParam2)

If so, could you demonstrate how to use it?

View 4 Replies View Related

AutoCAD Inventor :: Part List Column Width ILogic

Jun 11, 2013

I found the following code on Curtis Waguespack site. [URL] ........

View 3 Replies View Related

AutoCAD Inventor :: Write Text String To Parts List Column With ILogic

Mar 5, 2013

I'm trying to create an iLogic rule that will print a text string to a cell or column of a parts list in inventor.My code so far...

Sub Main()
On Error Resume Next
Dim oDrawDoc As DrawingDocument
oDrawDoc = ThisApplication.ActiveDocument
[code]...

I want to print what is in the MessageBox into a cell in the parts list, and i am stumped.The cell i am trying to print to is a custom property in the Parts List.

View 3 Replies View Related

AutoCAD Inventor :: ILogic To Insert Row Into Excel

May 28, 2013

Is it possible to use iLogic to insert a row into excel?

View 1 Replies View Related

AutoCAD Inventor :: ILogic And Excel Link

Sep 3, 2013

I 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 Related

AutoCAD Inventor :: Create Sheet In Excel With ILogic

Jan 9, 2014

I 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

View 2 Replies View Related

AutoCAD Inventor :: ILogic Excel Date - How To Format

Jan 7, 2013

I 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] .........

View 9 Replies View Related

AutoCAD Inventor :: Using Excel And ILogic To Control IParts

Jan 9, 2012

I 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.

View 1 Replies View Related

AutoCAD Inventor :: ILogic / Export Parameters To Excel?

May 21, 2013

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 

View 8 Replies View Related

AutoCAD Inventor :: Get New Part Number From Excel With ILogic?

Jan 28, 2013

I 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,

View 9 Replies View Related

AutoCAD Inventor :: ILogic Excel Save As Command

Dec 12, 2012

I 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 Related

AutoCAD Inventor :: Populate IProperties From Excel Using ILogic

Jun 27, 2011

I 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?

View 5 Replies View Related

AutoCAD Inventor :: Using ILogic To Search Through Excel Worksheet

Jul 25, 2011

Is 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

View 2 Replies View Related

AutoCAD Inventor :: 2013 Can't Delete Linked Excel Sheet

Aug 6, 2013

I have a excel sheet linked to my inventor file and I cant delete it. I really only need to change the starting cell, but I can't do that either. It works on some parts to right click on the folder in the parameters window and then select delete or change start cell, but on others it doesn't work.

View 5 Replies View Related

AutoCAD Inventor :: ILogic To Find Next Free Cell In Excel

May 27, 2013

What 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.

View 6 Replies View Related

AutoCAD Inventor :: ILogic And Excel Spreadsheets - Linking Values

Mar 6, 2012

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.

View 3 Replies View Related

AutoCAD Inventor :: (iLogic) Change Excel Chart Location

Nov 29, 2010

I 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 Related

AutoCAD Inventor :: ILogic - Export Custom Table To Excel

Mar 11, 2013

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 Related

AutoCAD Inventor :: How To Delete ILogic Forms

Nov 7, 2012

how to delete iLogic forms from Inventor 2013 parts/assembly using VB.net 2010?

I am able to delete all the rule using "Activated_iLogic.DeleteAllRules(PartDoc)" but "Activated_iLogic.DeleteAllForms(PartDoc)" or "Activated_iLogic.DeleteForm(PartDoc, FormName)" does not give me the result I was expecting and Google is not showing any result related to this.

View 5 Replies View Related

AutoCAD Inventor :: Delete ILogic Rule Using VBA?

Jul 6, 2011

i have an iLogic rule in serveral files. Now this rule has to be deleted. This should be done with VBA. I can not find any function to delete a rule using VBA.

I found a function iLogicAuto.RunRuleDirect(rule), but not iLogicAuto.DeleteRule(rule) ...

I can not find any documentation for iLogic/VBA.

View 9 Replies View Related

AutoCAD Inventor :: Delete Userparameter With Ilogic

Jan 9, 2012

I know how to add user parameters with ilogic, but i would like to dete them as well. I've tried to use the delete option as mentioned in the API but I cann't get it working in ilogic.

How i create a parameter:

Format:HTML Format
Version:1.0
StartHTML: 165
EndHTML: 3855
StartFragment: 314
EndFragment: 3823
StartSelection: 314
EndSelection: 314

DimoDocAsPartDocument=ThisDoc.Document'of : oDoc as AssemblyDocumment = ThisDoc.Document
'nummerieke parameter
Try
prop=oDoc.ComponentDefinition.Parameters.UserParameters?.item("nummer")
Catch
newprop=oDoc.ComponentDefinition.Parameters.UserParameters?.AddByExpression("nummer", "100", "mm")
EndTry

View 1 Replies View Related

AutoCAD Inventor :: Delete All Parameter In ILogic

Sep 27, 2012

In 2009 Inventor iLogic, we have a button to delete all parameters and rules. But now, in 2013 Inventor iLogic, I only find a button to delete all rules. Where is the button to delete all parameters?

View 9 Replies View Related

AutoCAD Inventor :: ILogic Syntax For Searching In Excel And Update IProperties

Dec 17, 2013

I 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.,

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved