![]() ![]() GoExcel.CurrentCellValue, GoExcel.CellValue Write to an external spreadsheet: GoExcel.CellValue("Spreadsheet.xls", "Sheet1", "A6") = "Hello World" Message =GoExcel.CellValue("Spreadsheet.xlsx", "Sheet1", "B5") Read an external spreadsheet: head_rad = GoExcel.CellValue("Spreadsheet.xlsx", "Sheet1", "A5") Write to an embedded spreadsheet: GoExcel.CellValue("3rd Party:Embedding 4", "Sheet1", "A1")= head_rad Read an embedded spreadsheet: head_rad = GoExcel.CellValue("3rd Party:Embedding 4", "Sheet1","A1") You can also specify a named range in the worksheet scope. The sheet can be any existing sheet.Ĭell address to read or write to (such as “A7”). ![]() Name of the sheet in the Excel document that contains the target cell. GoExcel.CellValue("filename", "sheetname", "cellnumber") Reads or writes values to spreadsheet cells. The first example references an external spreadsheet, and the second example references an embedded spreadsheet. Dia is equal to 0.2 and Len is greater than or equal to 4.1. These examples set the value of the parameter variable i to the number of the row in the table. Columns must have titles in the first cell of the column.Table configurations must be horizontal (configurations defined by rows, not columns).Input value is wrong type (does not match column value type).The value is -1 if a matching row is not found. The row number (an integer) that matches the search criteria. The title of the second column in the table to be searched. = Find a row with a text or numeric column value equal to the specified value.Ī text or numeric value that can be specified with an explicit value, a parameter, or a local variable.= Find a row with a column value greater than or equal to the specified value.Column titles usually are placed in row 1, starting in column A. The title of first column in the table to be searched. The sheet in the Excel document containing the table to be searched. GoExcel.FindRow("filename", "sheetname", "first column title", "operator", value to look for, "second column title", "operator", value to look for, "third column title".) Searches for a row based on one or more column value criteria. Do not change the Embedded table name from the default name given to it by Inventor (for example, Embedding 1). ![]() If you use an embedded table, embed it using Link on the Parameters dialog box. Specify the name that displays in the Inventor Model tree, under 3rd Party. Use the syntax 3rd Party:LinkedName.xls for linked spreadsheets. Use the syntax 3rd Party:Embedding# for embedded spreadsheets. You can also specify a linked or embedded spreadsheet instead of a filename. You can use a relative path under the project Workspace path. ILogic also searches for the file under the project Workspace path. A relative path is interpreted as relative to the folder containing the Inventor document. If a path is not specified, iLogic assumes that the Excel document is in the same folder as the current Inventor document. However, using absolute paths can make it difficult to send the model to another user on a different computer. The functions require either a filename or a specification of a linked or embedded Excel file.įor a filename, you can specify a relative or absolute path. You can embed Microsoft ® Excel data or link it into an Inventor document, or keep it as an external file. ![]()
0 Comments
Leave a Reply. |