GUI edit excel file name

1 visualización (últimos 30 días)
Jomei
Jomei el 6 de Abr. de 2020
Comentada: Jomei el 6 de Abr. de 2020
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 comentarios
Ameer Hamza
Ameer Hamza el 6 de Abr. de 2020
uiputfile already gives the option to change the filename.
Jomei
Jomei el 6 de Abr. de 2020
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.

Iniciar sesión para comentar.

Respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by