How to use writetable to write a file and save this file in the specific location

16 次查看（过去 30 天）

Chao Zhang 2021-11-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1594024-how-to-use-writetable-to-write-a-file-and-save-this-file-in-the-specific-location

评论： Chao Zhang 2021-11-23

Hi all,

I have a structure and use struct2table to convert it as table, then use writetable function to generate a xlsx file, but my question is how to use writetable function to generate the file in the specific folder location, because my code (in the following) is always generate the file in the default location.

%  Output the file
   for i = 1 : size(M,2)
       temp1    = M(i); %The number of columns of M
       
	   TYPE = temp1.type;
	   temp1    = rmfield(temp1,'type');
	   writetable(struct2table(temp1), 'New_file.xlsx', 'sheet', TYPE)
       
	   clearvars temp1
   end
   
   disp('Done!')