Documentation

Save the Excel^® file in a folder on the MATLAB^® path.

Open the model containing the lookup table block and in the Modeling tab, select Model Settings.

In the Model Properties dialog box, in the Callbacks tab, click PostLoadFcn callback in the model callbacks list.

Enter the code to import the Excel Spreadsheet data in the text box. Use the MATLAB xlsread function, as shown in this example for a 2-D lookup table.

% Import the data from Excel for a lookup table
data = xlsread('MySpreadsheet','Sheet1');
% Row indices for lookup table
breakpoints1 = data(2:end,1)';
% Column indices for lookup table
breakpoints2 = data(1,2:end);
% Output values for lookup table
table_data = data(2:end,2:end);

Click OK.