Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts
Friday, December 15, 2017
Ilogic Add Standard Virtual Parts From an Excel File
Ilogic Add Standard Virtual Parts From an Excel File
Issue:
You have a number of standard Virtual parts that you find yourself adding over and over. Youd like to have the ability to add them based on a predefined list.
You saw the post about adding these parts from a text file, but youd like to be able to add standard iProperties for these virtual parts also. This way your Bill of Materials information for the virtual parts can be set when the virtual part is created. So you were wanting to read data from an XLS file that contains all of the information that you typically add for virtual parts.
Solution:
Here is an example iLogic rule that will read a *.xls file and present the contents to the user in an input box list. The user is then asked to enter a quantity for the virtual part, and then the virtual part occurrences are added to the assembly. If one or more occurrences of the virtual part exist in the assembly, the iLogic rule deletes them and just adds back the total number needed.
As the virtual parts are added, the iProperty information found in the *.xls file is added also.
In this example the parts are placed by using the A column, which is the description. Then the other columns are read in and used to populate the virtual parts iProperties.
 |
| An example XLS file list with iProperty information. |
Dim MyArrayList As New ArrayList
MyArrayList = GoExcel.CellValues("U:iLogic examplesVirtual Part List.xls", "Sheet1", "A2", "A1000")
Dim sVirtPart As String
get user input from list
sVirtPart = InputListBox("Select a virtual part to add.", _
MyArrayList, MyArrayList.Item(0), "iLogic", "Standard Virtual Parts")
check for empty input in the case where the user cancels out of the input box
If sVirtPart = "" Then
Return end rule
Else
End if
get iProperties from the XLS file
For MyRow = 2 To 1000 index row 2 through 1000
find the cell in column A that matches the user selection
If sVirtPart = (GoExcel.CellValue("A" & MyRow)) Then
get the iProperty from the XLS file for each column
oProp1 = GoExcel.CellValue("A" & MyRow )
oProp2 = GoExcel.CellValue("B" & MyRow )
oProp3 = GoExcel.CellValue("C" & MyRow)
oProp4 = GoExcel.CellValue("D" & MyRow)
oProp5 = GoExcel.CellValue("E" & MyRow)
Exit For
End If
Next
get quantity from user
iQTY = InputBox("Enter the TOTAL number of:" _
& vblf & " " & sVirtPart & "" _
link download
Read more »
Wednesday, December 6, 2017
Image MS Word Excel Power Point PSD Other Format To PDF Converter Full registered Free Download
Image MS Word Excel Power Point PSD Other Format To PDF Converter Full registered Free Download
PDF Forte is capable of converting Word, Excel, PPT, Images, PSD, Dwg to PDF files. You can also use this free application to convert Word to Epub. Support batch mode so it will be quite easy and saving your time to convert multiple files. Whats more, it is 100% free now.
Sleek and clean user interface.
Extremely Fast and Stable.
Convert 7 file formats to PDF in batches.
Support 5 languages. English, Chinese, French, German, Russian.
No Adobe and Office software needed or installed
Support Windows 10/8/7/Vista/XP.
Sunday, December 3, 2017
iLogic TitleBlock Project Data From Excel
iLogic TitleBlock Project Data From Excel
Issue:
You have a title block that uses prompted entry, and youd like to fill those fields in from data that is in a spread sheet. You know that the best way to set up a title block is to use the model files iProperties, but unfortunately you cant make changes to the title block that youve been provided. But there must be a better way than just editing each sheet and re-typing the same information over and over, right?
Solution:
Here is an iLogic rule that asks the user to browse for an spreadsheet. Then it reads in the data and matches the field name to the title block field, and if a match is found it writes the field value to the title blocks prompted entry field.
Here is an example spread sheet:
Here is an example Title Block:
And here you can see the field text in the title block, with those that are prompted entries denoted by carats: < >
So the iLogic code gets the information from the spreadsheet and then writes it to the title block for every sheet in the drawing.
Ive added some lines to activate each drawing sheet and a delay timer to step through each text field so that you can watch the changes, but all of that could be removed if youd prefer to speed up the running of the rule.