字符串存入xls matlab,数组 – MATLAB：将字符串写入Excel

问题出在xlswrite行中：

xlswrite(filename,A,sheet) writes to the specified worksheet.

这意味着您正在使用xlswrite(filename,’b’,’A1′)将字符串’b’写入工作表’A1′;

xlswrite(filename,A) writes array A to the first worksheet in Excel

file, filename, starting at cell A1.

你实际上不需要做任何事情来开始在A1写作.假设b是行向量：

xlswrite(filename,b');

正如你所写,应该足够了.

如果要指定工作表和列,可以使用

xlswrite(filename,A,sheet,xlRange)

更新：我现在不能尝试这个,但我认为它应该有效.

您可以为每个订单计算a和b,并将它们写入xls文件,如下所示：

r = 1; % row number

str = {'a', 'b'};

order = [1 3 5]; % The orders you want to calculate a and b with

for idx = 1:size(order, 2)

[b,a] = cheby2(order(idx), 20, 300/500); % I do not know about second

% and third parameters, you should

% check them.

vals = [a; b]; % assuming they are row vectors

cellName = strcat('A', r);

orderName = strcat('Order ', order(idx));

xlswrite(filename, orderName, 1, cellName)

r = r + 1;

for jdx=1:2

cellName = strcat('A', r);

xlswrite(filename, str{jdx}, 1, cellName);

r = r + 1;

cellName = strcat('A', r);

xlswrite(filename, vals(jdx, :), 1, cellName);

r = r + size(vals, 2);

end

end