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

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)

Answer 1

[Rick Rosson]

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

[Niki]

Hi Rick, your answer sounds nice, but there is a problem,

it works manually, means I should take care of it every second , otherwise I think it is a good idea

[Fangjun Jiang]

No, Mohammad. This is meant to be an illustration. You should be able to make it through. The only thing you need to do is probably to arrange you data so it's easy to reference. Don't name it data1, data2, etc. Instead, make it a cell array. For example

CellData={rand(4);magic(5);rand(6)};

Row=1;

for k=1:length(CellData)

xlswrite(filename,CellData{k},sheet,['A' num2str(row) ] );

Row=Row+size(CellData{k},1)+3;

end

[Andrei Bobrov]

Hi, Friends! Change 'row' on 'Row' in 'num2str(row)'.

[Fangjun Jiang]

Good catch, Andrei! I've been used to mixed case but I copied Rick's code.

Answer 2

[Fangjun Jiang]

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.

[Niki]

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]

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.

Answer 3

[Chirag Gupta]

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');

Answer 4

[Andrei Bobrov]

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

[Niki]

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