Naming Excel Sheet with xlswrite.

19 views (last 30 days)
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'

Accepted Answer

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

More Answers (0)

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!