Dimensions of arrays being concatenated are not consistent.

Here all the variable are of 1X3 except velocity which is 1X2

So,how shall I add even that value in the sheet ? as I get Dimensions of arrays being concatenated are not consistent error

%save as excel

filename = 'Nomexhole2.xls';

Results_Names={'Amp','N','T','velocity'};

Results_Values=[Amp',N',T',velocity.'];

sheet=1;

xlRange='A1';

xlswrite(filename,Results_Names,sheet,xlRange);

sheet=1;

xlRange='A2';

xlswrite(filename,Results_Values,sheet,xlRange);

winopen('Nomexhole2.xls');

[Bob Thompson]

Why not just preallocate the concatonated array to three columns of NaN? Then when you replace the velocity values the last one will just be NaN?

[Adam]

It depends what you expect to happen. As you yourself point out, you have 1x3 variables and on this line:

Results_Values=[Amp',N',T',velocity.'];

you transpose them all to 3x1 and try to horizontally concatenate with a 2x1 result, which clearly cannot happen. what do you expect to happen with the missing value? Why are there only 2 velocities? Do they correspond to the first two rows, the 2nd two, the first and last? Only you know what you expect the end result to be.

[Ramesh Bala]

Thanks Bob and Adam

I know that I cannot concanate it as its 1X3 with 1X2

2 velocities is between the 3 points. as you've mentioned is correct.

How shall I add NAN to the 3rd row ?

Also,i tried to put that 1X2 in sheet 2 but it shows similar error ?

[Bob Thompson]

If you want to keep all of the data together, using preallocation:

Results_Values = nan(3,4);
Results_Values(1:3,:) = [Amp',N',T'];
Results_Values(4,1:2) = velocity.';

When you tried to print the velocity values to the second sheet, what command did you use? It may not have been the writing command that was actually causing the issue.

[Adam]

Results_Values=[Amp',N',T',[velocity NaN].'];

should also work.

[Ramesh Bala]

Thank you Bob and Adam

When I used Preallocation it showed Unable to perform assignment because the size of the left side is 3-by-4 and the size of the right side

is 5-by-3

But [velocity NaN] worked well ,also I've used this command also worked

velocity(end+1:numel(T))=0;

Thank you again !

Kindly put this agian in the answer this question section ,so that I can mark it as complete with a vote.

Answer 1

[Adam]

Results_Values=[Amp',N',T',[velocity NaN].'];