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

3 次查看（过去 30 天）
Ahmad Fakih
Ahmad Fakih 2019-10-29
评论： Ahmad Fakih 2019-10-29
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!

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2019-10-29
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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by