## mathlayer from Excel

### From Cells: Single Line

You can write scripts directly in worksheet cells. Calling "m" function on these cells allows running the scripts.If you want for instance to create a 5x3 matrix with uniform random numbers, you can write in a cell:

x = rand(5,3)

And from a different cell call function "m":

mathlayer returns information on the objects created:

[x:5x3 double]

in this case a 5x3 matrix of doubles named x.

### From Cells: Multiple Lines

In order to execute multiple lines of script directly from Excel you have two options: writing the full script within a single cell or spreading the lines of code in multiple cells.Let's run the following script:

z = zeros(100) for i=1:100 for j=1:100 z(i,j) = sin(i/12) + cos(j/12) end end

from a single cell:

from multiple cells:

we get the same output:

[z:100x100 double][i:100][j:100]

### Getting Data in Excel

You simply need to add hashtag # symbol after a variable name to output its values.In order to output matrix z (as defined in script above) into Excel you run "z#" on a range of cells:

in order to get matrix output into Excel you need to press CTRL+SHIFT+ENTER:

More information about array formulas in Excel.

### Loading Data from Excel

Calling "m" function with more than one argument allows loading data from Excel to mathlayer: first argument defines variable name and second argument must be an Excel range with the data to load.- Matrix

- Cell array

- Table: third argument must be an Excel range with variable names and fourth argument (optional) defines row names.