Naming Excel Sheet with xlswrite.

5 次查看（过去 30 天）
Samuel Brewton
Samuel Brewton 2021-2-19
编辑： Samuel Brewton 2021-2-19
I am looking to use xlswrite to export a matrix to excel. For the naming convention, I want to name it based on a variable (ex: x=30) so that the excel file would be named "Rule30.xls".
I've tried using xlswrite(FILE,ARRAY) as xlswrite( ('Rule%d',x) , matrix), similar to how I'd use fprintf.
Here would be a quick code example:
x=30 % Defines x
matrix = eye(x) % Creates an identity matrix that's x by x
xlswrite(('Rule%d',x),matrix) % Writes 'matrix' as an excel file titled 'Rule30.xls'

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2021-2-19
FileName=['Rule',num2str(x)]
FileName=sprintf('Rule%d',x)

更多回答（0 个）

类别

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

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by