GUI edit excel file name

1 次查看（过去 30 天）

Jomei 2020-4-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/515892-gui-edit-excel-file-name

评论： Jomei 2020-4-6

Hi,

Now I set my excel name is 'filename1'. How can I use the edit box to change the file name, so the user can store the name whatever they want?

filename = 'filename1.xlsx';
writetable(Table,filename);
header={'Data Number',  'Effective Thickness', 'Refractive Index',...
        'geometrical factor', 'Concentration', 'Donated Density', 'Settle Time',...
        'Electron Settle Time', 'Hole Settle Time',...
        'Epsilon', 'Fill Factor', 'Maximum Time', 'Minimum Time',... 
        'Y-axis Maximum', 'Y-axis Minimum','Maximum Frequency',... 
        'Minimum Frequency', 'Chi_Texting', 'Charge Carrier Density, n(σ)',...
        'Charge Carrier Density, n(ωp)', 'Effective Carrier Mobility'}; %etc
xlswrite(filename,header,1); %1 is the sheet number which is by default 1
[file,path] = uiputfile('filename1.xlsx');
winopen(filename)

2 个评论
显示无隐藏无

Ameer Hamza 2020-4-6

uiputfile already gives the option to change the filename.

Jomei 2020-4-6

Thanks for answering.

Sorry I didn't say really clear. This coding doesn't work perfectly. Because the first run the excel file 'filename1.xlsx' exist, so run second time it will have error.

And I pretty sure that I need to use uiputfile , but I don;t know how to use it.

请先登录，再进行评论。

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