How do I export a matrix to an Excel file with a custom file name that can be typed in the command window?
6 views (last 30 days)
Show older comments
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 Comments
Answers (2)
Walter Roberson
on 9 Oct 2012
[filename, pathname] = uiputfile('Where do you want it?");
completename = fullfile(pathname, filename);
xlswrite(completename, TheData)
0 Comments
Sachin Ganjare
on 9 Oct 2012
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 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!