How do I export a matrix to an Excel file with a custom file name that can be typed in the command window?
2 次查看(过去 30 天)
显示 更早的评论
Hi everyone.
I am working on a research topic and need to export two matrices into Excel. The matrices can vary in size after a few scripts are run. Ultimately, I need to be able to export the two matrices to two Excel files with the ability for the user to type in any file name he/she wants.
I believe I have to save the file name typed in the command window as a string, then use the xlswrite() command to do it. Not sure where to start. Thanks!
0 个评论
回答(2 个)
Walter Roberson
2012-10-9
[filename, pathname] = uiputfile('Where do you want it?");
completename = fullfile(pathname, filename);
xlswrite(completename, TheData)
0 个评论
Sachin Ganjare
2012-10-9
name_xls1 = input('Enter XLS 1 name:', 's');
name_xls2 = input('Enter XLS 2 name:', 's');
status = xlswrite(name_xls1, MATRIX_DATA1);
status = xlswrite(name_xls2, MATRIX_DATA2);
Hope it helps!!!!
5 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!