Copy and Paste Lookup Table Data from Excel
This example shows how to copy data from an Excel® spreadsheet or any spreadsheet application into a lookup table.
Add a 2-D Lookup Table block to a model.
Open the Lookup Table Editor. For example, open the block dialog and click Edit table and breakpoints.
Create or open an existing Excel spreadsheet, for example, an Excel spreadsheet that contains this data.
-10 1 25 -7 2 35 -4 4 42
Copy and paste the contents of the Excel spreadsheet into the lookup table spreadsheet.
Notice that the pasted elements in the lookup table spreadsheet have a yellow border. This yellow border indicates that the data has not yet been saved. To save the data to the data source, click Apply. In this example, the data source is the 2-D Lookup Table block.
At the bottom of the Lookup Table Editor is a table of sources for the data.
To display and hide this table, click Data Source in the toolstrip.
To get the data from the data source into the Lookup Table Editor, click Reload. If you do not click Apply before clicking Reload, the editor discards the spreadsheet before loading the data from the data source.
To save the data from Lookup Table Editor spreadsheet to the data source, click Apply.