Import Data Into xls file by using MatLab Command
3 次查看(过去 30 天)
显示 更早的评论
I am having difficulties to import file into MatLab due to unusual *.prn file format . I was thinking to open excel by using MatLab code an then Import data into it . For matlab help I learned to open excel workbook . But I don't know how to Import data into that excel file using MatLab command . Please help .
0 个评论
回答(1 个)
Effrom
2012-5-8
Are you trying to save a MAT file to XLS format or trying to run Excel from the command line?
What I've always done is export my array using the xlswrite command and then I would open in manually. I'm not sure if Excel can be run from command line, but if it can, you can try using the system command.
Example:
A = [1 2 3; 4 5 6; 7 8 9];
xlswrite('test.xls',A);
system('Command line code to open file in Excel.');
Make sure you use the single quotes as you would a string in MATLAB.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!