MATLAB: Export cell array of two strings of different dimension to an excel file

cell arraysexportMATLABstringsxlswrite

I have two cell arrays of strings with different dimension:

A={'Arut';'Babu';'Christ';'Daniel'};
B={'Selvan';'Mahesh';'Colin';'Balaji';'Sathish'};

I need to give an header for these two arrays as 'FIRSTNAME' and 'LASTNAME' in excel file followed by the data of A and B. I have tried to concatenate and write the elements into an excel as follows:

    X=[{'FirstName','LastName'};A,B]
    xlswrite('A.xls',A{:},B{:})

For which I am getting an error,

Error using horzcat Dimensions of matrices being concatenated are not consistent.

This is due to concatenation of A and B with different length.

Please suggest me how to export these data to an excel with headers

Best Answer

You need to extend your variables so they have equal lengths, which you can do in a way similar to the code below.

A={'Arut';'Babu';'Christ';'Daniel'};
B={'Selvan';'Mahesh';'Colin';'Balaji';'Sathish'};
if length(A)>length(B)
    %A is larger, pad B
    B{length(A)}=[];
elseif length(A)<length(B)
    %B is larger, pad A
    A{length(B)}=[];
end
X=[{'FirstName','LastName'};A,B];
xlswrite('A.xls',X)

Related Solutions

MATLAB: Write a function called “makemat” that will receive two row vectors as input arguments, and from them create and return a matrix with two rows. You may not assume that the length of the vectors is known. Also, the vectors may be of different length

function [C] = ArmStrong(A, B)
if length(A)==length(B)
    X = A ;
    Y = B ;
elseif length(B)>length(A)
  X = zeros(size(B)) ;
  X(1:length(A)) = A ;
  Y = B ;
elseif length(A)>length(B)
    Y = zeros(size(A)) ;
    Y(1:length(B)) = B ;
    X = A ;
end
C(1,:)=X ;
C(2,:)=Y ;
end

There are multiple ways to achieve the above. In simple:

L = [length(A), length(B)] ;
C = zeros(2,max(L)) ;
C(1,1:L(1)) = A ;
C(2,1:L(2)) = B ;

MATLAB: Concatenating characters in different column to a string

['a' 'b' 'c' 'd' 'e'] is not a 1 x 5 array of strings: it is a single string of length 5, 'abcde', exactly as you want.

{'a' 'b' 'c' 'd' 'e'} on the other hand would be a 1 x 5 cell array of strings. You can convert this cell array to a single string by using cell2mat()

Best Answer

Related Solutions

MATLAB: Write a function called “makemat” that will receive two row vectors as input arguments, and from them create and return a matrix with two rows. You may not assume that the length of the vectors is known. Also, the vectors may be of different length

MATLAB: Concatenating characters in different column to a string

Related Question