Integrating with Other Products > Microsoft Excel > To Type Output Expressions in Excel Components
To Type Output Expressions in Excel Components
1. Click the Outputs area in the Excel component.
2. Type a PTC Mathcad variable and then press : (colon) to add a definition operator. The variable you are using can be a previously defined variable or a new one.
3. Type excel and press [ to insert a subscripted string.
4. Specify the output cell range string between quotation marks. "Sheet1!A1:B3" specifies the Excel worksheet name, the top-left cell, and the bottom-right cell. "Sheet1!A1" reads in a single cell.
For example, in the expression the values of cells A1 through B2 are assigned to x.
If you are reading from the first Excel worksheet, you do not have to mention the worksheet name. The expression is equivalent to the above output expression.
Empty cells are read as 0 in PTC Mathcad.
You can also insert an output expression by right-clicking the Outputs area, and selecting Insert Output Expression from the shortcut menu.
Was this helpful?