How can i save a .xls file in a specific folder?

Question

Francesco Dall'Orto 2017-12-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/374952-how-can-i-save-a-xls-file-in-a-specific-folder

回答： Tristan Yang 2018-1-2

Hi! I'm trying to save a .xls file in a specific folder. I will show you my code:

mkdir (['TEST\' char(nameFolder)]); 
fullPath=fullfile(['TEST\' char(nameFolder)], "*nameOfVariable*"); 
xlswrite(fullPath, "*variable*")

For example if i have a variable named "Hello" that contain the array [1,2,3] I want to create a folder in TEST\nameFolder that contain a file.xls named Hello.xls in which i have the array [1,2,3]

Thank you very much

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

请先登录，再进行评论。

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

Answer 1

Tristan Yang 2018-1-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/374952-how-can-i-save-a-xls-file-in-a-specific-folder#answer_298434

在 MATLAB Online 中打开

If the name of the variable is needed as the filename, it is necessary to store that information as a 'char'. For example:

nameOfVariable = 'Hello';
Hello = [1, 2, 3];

Then you can write the variable to a spreadsheet with:

mkdir (['TEST\' char(nameFolder)]);
fullPath=fullfile(['TEST\' char(nameFolder)], [nameOfVariable '.xls']);
xlswrite(fullPath, Hello);

If you would like to dynamically matching the variable name with the array/matrix value, please consider using one cell array to store all the variable names and another cell array to store the corresponding array/matrix. For example:

names = {'hello1', 'hello2', 'hello3'};
values = {[1,2,3], [4,5,6], [7,8,9]};
mkdir (['TEST\' char(nameFolder)]);
for i = 1:length(names)
    fullPath=fullfile(['TEST\' char(nameFolder)], [names{i} '.xls']);
    xlswrite(fullPath, values{i});
end