How to change the filename in xlswrite using loop

Question

Prakhar Modi 2019-12-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/497397-how-to-change-the-filename-in-xlswrite-using-loop

评论： Shivam Mishra 2022-3-30

Hello everyone,

now I am writing the one .xlsx file with 19 sheets. For which my code is working properly. This is what I am written till now

for a=1:length(sheets)

xlswrite('rough.xlsx',final{a},sheet{a},xlrange1);

end

Now what actually I want is that I need to write my answers in for different xlsx sheets. Means for every one input sheet I will get one xlsx file with 19 sheets. So, how can I change the filename with a different for loop so that for every different input sheet i will get different xlsx file with 19 sheets each.

means as I am able to change the sheets number but how to change the filename.

Thanks in advance

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KALYAN ACHARJYA 2019-12-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/497397-how-to-change-the-filename-in-xlswrite-using-loop#answer_407074

编辑：KALYAN ACHARJYA 2019-12-19

for i=1:
xlswrite([strcat('Any_Initial_name',num2str(j)),'.xlsx'],file_to_write,'Sheet');
end

2 个评论
显示无隐藏无

Prakhar Modi 2019-12-20

thanks.

Shivam Mishra 2022-3-30

for i=1: means?

请先登录，再进行评论。

Answer 2

Ankit 2019-12-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/497397-how-to-change-the-filename-in-xlswrite-using-loop#answer_407073

using xlswrite in a loop will effect performance. Try this FEX: https://de.mathworks.com/matlabcentral/fileexchange/10465-xlswrite1.

You can try the below changes

for a=1:length(sheets)
fileName = ['rough_', int2str(a), '.xlsx'];
xlswrite(fileName,ARRAY,SHEET,RANGE);
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Ankit 2019-12-20

I tried with random values it is working for me. If I am not wrong length(sheets) = 3?

Just change length(sheets) =3 and let me know your results.

Prakhar Modi 2019-12-20

Thanks man.

But I tried with kalyan answer and that worked for me.

请先登录，再进行评论。