How to export an array text which created by a string and numbers to excel?

1 次查看（过去 30 天）
Khanh
Khanh 2014-10-4
评论： Khanh 2014-10-4
Hi,
I have a numeric array a=0:100:1000
I want to precede each element of the array with 'WL' and I will get a new array: 'WL0', 'WL100', 'WL200',..., 'WL1000'.
Then I will export it excel by xlswrite. Could someone please help me to do it? I wrote by myself but I couldn't get the result I desired.
Here is my code:
clc
clear all
format short
a=0:100:1000;
wl={};
for i=1:length(a)
text=sprintf('WL%d',a(i));
wl={wl;text};
end
xlswrite(filename,wl,1,'A6');
Thanks.

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

采纳的回答

Geoff Hayes
Geoff Hayes 2014-10-4
Khanh - you almost have it. w1 has been (correctly) defined as a cell array, it is just the vertical concatenation that is failing at the line
wl={wl;text};
which seems to result in a 2x1 object where the first is a cell array, and the last is the last value added (text). Just change this line to the following which will create the column that you desire
wl=[wl;text];
and assign a filename
filename = 'myExcel.xls'
and you should be good to try again.
  1 个评论
Khanh
Khanh 2014-10-4
While waiting the answer, I wrote the 2nd code to do it. But it consumed more time than the 1st one with your help. Thank you so much.
My 2nd code:
for i=1:length(a)
text={sprintf('WL%d',a(i))};
range=sprintf('a%d',5+i);
xlswrite(filename,text,1,range);
end

请先登录，再进行评论。

更多回答（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!

Translated by