查看: 10092|回复: 8|关注: 0
matlab程序输出的元胞数组如何写入excel中
<h1 style="color:# 麦片财富积分
新手, 积分 5, 距离下一级还需 45 积分
请问如何将元胞数组按excel表格形式输出，请高手指点，拜托各位，不胜感激^^
<h1 style="color:# 麦片财富积分
用xlswrite函数
例如：d = {'Time', 'Temp'; 12 98; 13 99; 14 97};
1、如果你只是想把d简单的导入excel文件，就可以像下面这样写：
xlswrite('tempdata.xls', d)。这样就会在你现在的工作文件夹下自动生成一个名tempdata.xls的文件，数据在sheet1中，是从A1开始导入；
2、如果你还要制定工作表的名称和数据在工作表中的起始位置，那么可以这样写：
xlswrite('tempdata.xls', d, 'Temperatures', 'E1')。
更具体的帮助，你可以从帮助里查找有关xlswrite的内容，希望能对你有所帮助。:)
<h1 style="color:# 麦片财富积分
<h1 style="color:# 麦片财富积分
回复 2# rendong870311 的帖子
但要是这样写怎么就不行了呢：
A = {'Time','Temp'};
B = {12 98 ; 13 99; 14 97};
d = {A ; B};
xlswrite('tempdata.xls', d)
出来就是空的，什么也没有
<h1 style="color:# 麦片财富积分
shirui0601 发表于
但要是这样写怎么就不行了呢：
A = {'Time','Temp'};
B = {12 98 ; 13 99; 14 97};
我也想知道这个问题怎么解决，谢谢！
<h1 style="color:# 麦片财富积分
我也想知道，这个字符串怎么写入excel里呀？高手指点呀
<h1 style="color:# 麦片财富积分
我也想知道这个问题啊！！高手在哪里啊？
<h1 style="color:# 麦片财富积分
我也想知道这个问题啊！！高手在哪里啊？
A = {'Time','Temp'};
B = {12 98 ; 13 99; 14 97};
d = [A; B];
这样再写入就没问题了吧
<h1 style="color:# 麦片财富积分
应该是不能输出一个包含cell变量的cell到excel里面，单纯cell变量可以输出
站长推荐 /2
活动资料已更新点击下载>>
Powered by像中的这种零散的表格，要把它提取出来并排列成下图的样子：
python可以写，不会matlab。
你发的这个地址好像登陆之后可以直接下载&br&如果想从网页上直接读，可以用webread(老版本是urlread)读，之后用正则表达式（regexp）提取，最后写入excel文件&br&&br&&div class=&highlight&&&pre&&code class=&language-matlab&&&span class=&n&&t&/span& &span class=&p&&=&/span& &span class=&n&&regexp&/span&&span class=&p&&(&/span&&span class=&n&&webread&/span&&span class=&p&&(&/span&&span class=&s&&'http://ecorr.org/ecorr/dataSharedetail-1295-73.html'&/span&&span class=&p&&),&/span&&span class=&c&&...&/span&
&span class=&s&&'&table[^&]*&(.*?)&/table&'&/span&&span class=&p&&,&/span&&span class=&s&&'tokens'&/span&&span class=&p&&);&/span&
&span class=&n&&t&/span& &span class=&p&&=&/span& &span class=&p&&[&/span&&span class=&n&&t&/span&&span class=&p&&{&/span&&span class=&k&&end&/span&&span class=&o&&-&/span&&span class=&mi&&11&/span&&span class=&p&&:&/span&&span class=&k&&end&/span&&span class=&p&&}];&/span&
&span class=&n&&head&/span& &span class=&p&&=&/span& &span class=&n&&strtrim&/span&&span class=&p&&(&/span&&span class=&n&&regexp&/span&&span class=&p&&(&/span&&span class=&n&&t&/span&&span class=&p&&,&/span&&span class=&s&&'(?&=&b&)([^&]*)'&/span&&span class=&p&&,&/span&&span class=&s&&'match'&/span&&span class=&p&&));&/span&
&span class=&n&&data&/span& &span class=&p&&=&/span& &span class=&n&&strtrim&/span&&span class=&p&&(&/span&&span class=&n&&regexp&/span&&span class=&p&&(&/span&&span class=&n&&t&/span&&span class=&p&&,&/span&&span class=&s&&'(?&=&td&)([^&]*)'&/span&&span class=&p&&,&/span&&span class=&s&&'match'&/span&&span class=&p&&));&/span&
&span class=&p&&[&/span&&span class=&n&&u&/span&&span class=&p&&,&/span&&span class=&o&&~&/span&&span class=&p&&,&/span&&span class=&n&&id&/span&&span class=&p&&]&/span& &span class=&p&&=&/span& &span class=&n&&unique&/span&&span class=&p&&([&/span&&span class=&n&&head&/span&&span class=&p&&{:}],&/span&&span class=&s&&'stable'&/span&&span class=&p&&);&/span&
&span class=&n&&k&/span& &span class=&p&&=&/span& &span class=&n&&mat2cell&/span&&span class=&p&&(&/span&&span class=&n&&id&/span&&span class=&p&&,&/span&&span class=&n&&cellfun&/span&&span class=&p&&(&/span&&span class=&s&&'prodofsize'&/span&&span class=&p&&,&/span&&span class=&n&&head&/span&&span class=&p&&),&/span&&span class=&mi&&1&/span&&span class=&p&&);&/span&
&span class=&n&&t&/span& &span class=&p&&=&/span& &span class=&n&&cell2table&/span&&span class=&p&&(&/span&&span class=&n&&data&/span&&span class=&p&&{&/span&&span class=&mi&&1&/span&&span class=&p&&},&/span&&span class=&s&&'var'&/span&&span class=&p&&,&/span&&span class=&n&&sprintfc&/span&&span class=&p&&(&/span&&span class=&s&&'v%d'&/span&&span class=&p&&,&/span&&span class=&n&&k&/span&&span class=&p&&{&/span&&span class=&mi&&1&/span&&span class=&p&&}));&/span&
&span class=&k&&for&/span& &span class=&nb&&i&/span& &span class=&p&&=&/span& &span class=&mi&&2&/span&&span class=&p&&:&/span&&span class=&nb&&numel&/span&&span class=&p&&(&/span&&span class=&n&&k&/span&&span class=&p&&)&/span&
&span class=&n&&t&/span& &span class=&p&&=&/span& &span class=&n&&outerjoin&/span&&span class=&p&&(&/span&&span class=&n&&t&/span&&span class=&p&&,&/span&&span class=&n&&cell2table&/span&&span class=&p&&(&/span&&span class=&n&&data&/span&&span class=&p&&{&/span&&span class=&nb&&i&/span&&span class=&p&&},&/span&&span class=&s&&'var'&/span&&span class=&p&&,&/span&&span class=&n&&sprintfc&/span&&span class=&p&&(&/span&&span class=&s&&'v%d'&/span&&span class=&p&&,&/span&&span class=&n&&k&/span&&span class=&p&&{&/span&&span class=&nb&&i&/span&&span class=&p&&})),&/span&&span class=&s&&'merge'&/span&&span class=&p&&,&/span&&span class=&mi&&1&/span&&span class=&p&&);&/span&
&span class=&k&&end&/span&
&span class=&n&&xlswrite&/span&&span class=&p&&(&/span&&span class=&s&&'data.xlsx'&/span&&span class=&p&&,[&/span&&span class=&n&&u&/span&&span class=&p&&;&/span& &span class=&n&&t&/span&&span class=&p&&{:,:}])&/span&
&/code&&/pre&&/div&
你发的这个地址好像登陆之后可以直接下载 如果想从网页上直接读，可以用webread(老版本是urlread)读，之后用正则表达式（regexp）提取，最后写入excel文件 t = regexp(webread('http://ecorr.org/ecorr/dataSharedetail-1295-73.html'),...
'&table[^&]*&(…
已有帐号？
无法登录？
社交帐号登录
帮你从不会写代码到会写代码解决问题的过渡。