Info

此问题已关闭。 请重新打开它进行编辑或回答。

How to write several results in the same sheet of a Xls file ?

1 次查看（过去 30 天）
Niki
Niki 2011-8-30
关闭： MATLAB Answer Bot 2021-8-20
As a matter of fact I would like to obtain some results which are related to each other . I would like to compare them to each other but in the same sheet. It can be easily write the "data" from workspace to a xls file as follow
>> xlswrite('C:\path\filename.xls',data, 'Name of sheet');
right now my question is that, if I want to put new result in the same sheet but I do not want to lose the first result also, what should I do?
the dimension of the first result is not clear (for example it can be a matrix 4*4)
and the second result also, (it can be a matrix 6*6)

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

回答（4 个）

Rick Rosson
Rick Rosson 2011-8-30
In the following code, I am assuming that your data is stored in arrays A, B, C, and D of various sizes:
filename = 'C:\mypath\myfile.xls';
sheet = 'mySheet';
row = 1;
xlswrite(filename,A,sheet,['A' num2str(row) ] );
row = row + size(A,1) + 3;
xlswrite(filename,B,sheet,['A' num2str(row) ] );
row = row + size(B,1) + 3;
xlswrite(filename,C,sheet,['A' num2str(row) ] );
row = row + size(C,1) + 3;
xlswrite(filename,D,sheet,['A' num2str(row) ] );
row = row + size(D,1) + 3;
HTH.
Rick
  4 个评论
显示 2更早的评论
Fangjun Jiang
Fangjun Jiang 2011-8-30
Good catch, Andrei! I've been used to mixed case but I copied Rick's code.
Fangjun Jiang
Fangjun Jiang 2011-8-30
If it's easy to combine all the data into one, then I recommend combining them first and then write.
data1=rand(4,4);
data2=magic(4);
xlswrite('test.xls',[data1;data2],'SheetName');
Or you can write to xls file multiple times, use Range to specify the position on the spreadsheet.
xlswrite(File,Data,Sheet, Range)
You can use size(data1) to get the size of your data.
  2 个评论
Niki
Niki 2011-8-30
as you know, your code works well, but there is some problem with that, because exactly the second result with copied after the first time,
on the other hand, I do not have only two results,
maybe 100 results,
from another point of view I would like to mention all the information of each cell therefore I can not use of yours because i do not have space for the other information
Fangjun Jiang
Fangjun Jiang 2011-8-30
I don't fully understand your comment. But anyway, Rick's solution should work out for you if you have hundreds of matrices to write.
Chirag Gupta
Chirag Gupta 2011-8-30
You can do this accurately, if you know the dimensions of the results.
Otherwise, if you have good idea for maximum size of the result you should still be able to do this fairly accurately:
xlswrite('filename',data,'MyResultsSheet','A1'); % Write this result to the first cell of the sheet
% Assuming that the data max size is going to be 10 x 10
xlswrite('filename',data,'MyResultsSheet','K1');
Andrei Bobrov
Andrei Bobrov 2011-8-30
A=randi(4,3),B=randi(5,4,6),C=randi(7,3,8),D=randi(70,4,3)
Am = {A B C D}
N = cumsum([1 cellfun('size',Am(1:end-1),1)+1])
for i1 = 1:numel(Am)
xlswrite('C:\path\filename.xls',Am{i1}, 'Name of sheet',['A',num2str(N(i1))]);
end
  1 个评论
Niki
Niki 2011-8-30
sounds good Andrei, but there is two problems,
first of all, we do not have all the results together, so that in each for example hour one result will be saved in workspace
the second problem is that there is only one line space between each pair of result

标签

Community Treasure Hunt

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

Start Hunting!

Translated by