How to include a variable in "xlswrite" matrix name and cell range?

Dear members,

I want to include variables x,x1 and x2 in the following function, where x represents the matrix and xls file names and x1 x2 represent the range overwhich the matrix will be written in excel.

xlswrite('Jx.xls',Jx,'Ax1:Bx2')

This function will be written in a "double for loop" that subtitutes x first then x1 x2 thus generating multiple excel files.

Thank you!

Answer 1

[Walter Roberson]

Put your arrays into a single cell array Jx

filename = sprintf('J%d.xls', x);
range = sprintf('A%d:B%d', x1, x2);
xlswrite(filename, Jx{x}, range);

You might have noticed that I did not dynamically generate variable names J1 J2 and so on to write out. See http://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval

[Ahmad Fakih]

Thank you, works well except Jx{x} form isn't working.

[Ahmad Fakih]

Nevermind, figured it out and it works well. Thanks again!