How to include text and variable in excel sheet name when using xlswrite?

16 次查看（过去 30 天）
Abdulaziz Abutunis
评论： Image Analyst 2017-7-3
Hello, Is it possible to include variable and text in excel sheet name when we writing the result to that excel sheet using xlswrite command.
I know how to include variable only by using num2str(variable(j)).
I have tried ['Classic: ', num2str(variable(j)),'deg']but error message says :
Error using xlswrite (line 219)
The specified data range is invalid or too large to write to the specified file format. Try writing to an XLSX file and use Excel A1 notation for the range argument, for example, ‘A1:D4’.
Appreciate any suggestion Aziz

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

采纳的回答

Image Analyst
Image Analyst 2017-7-3
Yes, use sprintf() to create a sheet name from your variables:
sheetName = sprintf('%s %d', yourString, yourInteger);
cellRef = 'D3'; % Whatever
xlswrite(filename, yourData, sheetName, cellRef);
  2 个评论
Abdulaziz Abutunis
Abdulaziz Abutunis 2017-7-3
编辑：Image Analyst 2017-7-3
The method does work I only added the '' to define the text (e.g. 'yourString')
Thank you very much appreciate your time
Image Analyst
Image Analyst 2017-7-3
You're welcome, and thanks for Accepting the answer. In my code yourString was meant to be your variable name that contains the string. If you want it to be the actual string -- what is called a "string literal" -- then, yes, you would have to enclose it in single quotes.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by