Integrating with Other Products > Microsoft Excel > Example: Editing an Excel Component
Example: Editing an Excel Component
You cannot copy the expressions from this example.
1. Define a 5 x 5 identity matrix.
2. Press Ctrl+Shift+E to insert a blank Excel component.
3. Assign matrix M to the Excel component, placing the first matrix element in the first Excel cell A1.
If you are referring to Sheet1, you do not have to mention the sheet number.
Besides typing in data, you can also copy data from an external Excel file, and paste it inside the Excel component.
4. Double-click the Excel component table and change the value of cell F1 to 999 inside the Excel application.
5. Press Ctrl+S and close the Excel window. Cell F1 is set to 999.
6. Double-click the Excel component table, change the value of cell A1 to 999, and press Ctrl+S. Cell A1 changes to 999.
7. Close the Excel window. The value of cell A1 is 1 again, since the input expression overwrites whatever is in Excel.
8. Add an output expression that assigns the value of cells E1-F2 to a variable x.
9. 8. Evaluate x.
Empty cells in Excel are assigned as 0 to variables in a PTC Mathcad worksheet.
10. Set the value of cell A2 to 111.
11. Change the order of the two input variables.
Now the value of cell A2 reflects M because this assignment occurs after 111 was assigned to A2.
12. Set the value of cell F1 to NaN.
When you assign NaN to a cell, it becomes a blank cell.
Was this helpful?