Search the Community

So, I have successfully used the iLogic browser to input an excel file as a Table on my drawing. Not an issue. However, what I am having an issue with is having Inventor read a column in my new table to find a value specified by a design worksheet; Finding that/those row(s), and then only showing the row(s) that match the values from the design worksheet. ' Set a reference to the active drawing document Dim oDrawDoc As DrawingDocument oDrawDoc = ThisApplication.ActiveDocument ' Set a reference to the active sheet Dim oActiveSheet As Sheet oActiveSheet = oDrawDoc.ActiveSheet ' Create the placement point for the table Dim oPoint As Point2d oPoint = ThisApplication.TransientGeometry.CreatePoint2d(25, 25) ' Create the table by specifying the source Excel file ' This assumes that the first row in the Excel sheet specifies the column headers ' You can specify a different row using the last argument of the AddExcelTable method Dim oExcelTable As CustomTable oExcelTable = oActiveSheet.CustomTables.AddExcelTable("K:\Inventor\ADTLETMODELDATA.xlsx", oPoint, "Evaporator Information") This code works fine. I am also familiar with how to get a value from a spreadsheet and use it. Just wondering how to browse a column and then only show the needed values. Any ideas or help would be appreciated.