exporting from matlab to excel

1 次查看（过去 30 天）
joseph Frank
joseph Frank 2013-7-14
I have 236 vectors and arrays named A, B, C.....etc... Some of them are cell arrays and some of them are double vectors. How can I export the data to excel in one sheet where the order of variables is alphabetical? mixing arrays and vectors are a challenge to me as well as exporting them alphabetically in one sheet.

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

采纳的回答

Narges M
Narges M 2013-7-24
编辑：Narges M 2013-7-24
use this example:
A = {1;2;3;4};
B = [9;8;7;6];
C = {5;6;7;8};
D = [5;4;3;2];
for i='A':'D'
eval(sprintf('last = length(%s);', i));
eval(sprintf('xlswrite(''C:\\test.xls'',%s,1,''%s1: %s%d'');',i,i,i,last));
end

更多回答（1 个）

Darin McCoy
Darin McCoy 2013-7-15
I recommend creating sample data so users can mess with what you're working with
Have you checked out this solution on FEX? http://www.mathworks.com/matlabcentral/fileexchange/7601-cell2csv

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by