Resources

Saving data to Excel

0

How to save a set of variable names and matrix to an Excel so that the file has

Y       X1        X2

2       10         1

3       15         0

4      20         1

.        .            .

.        .            .

.       .             .

 

Tags: asked October 17, 2012

1 Answer

0

Try xlsWrite – commands as below

varnames = "Y" $| "X1" $|"X2";
y = {2,3,4};
x1 = {10,15,20};
x2 = {1,0,1};
xlsWriteSA(varnames', "c:\\temp\\yourfile.xls", "A1", 1,"");
xlsWriteM(y~x1~x2, "c:\\temp\\yourfile.xls", "A2", 1,"");