MATLAB: Export a Char String to Excel

cellfunchardynamic matrixexport to excelfor loopMATLABstringstrsplit

Greetings,
in my MATLAB Code (R2017a) i got a variable Matrix ('res') with the typ Char.
For example for one switch it looks like this (8×20):
Carreau-Parameter:  
a = 7521.1446 Pa*s  
b = 0.10637 s       
c = 0.78114         
Aktivierungsenergie:
E = 40281.5361 J    
resnorm:            
0.030751
The rows and columns of 'res' are variable and as you can see it is a String with variables in it. Therfore i would like to export every text and variable of a row (without the spaces) to a seperate column in exel. Here is an example for the last row:
        A1        A2
    __________    __
    '0.030751'    ''
First i build something like this and it worked for just one row:
dname = uigetdir('');
fileName = '\Kapillarrheometer.xlsx';
s = strcat(dname,fileName);
sheet=1;
res = ['Carreau-Parameter:  ';'a = 7521.1446 Pa*s  ']; % and so on...


[r,c] = size(res);
for i = 1:r
    A=strsplit(res(i,:));
end
alltableres=array2table(A);
disp(alltableres);
writetable(alltableres,s,'Sheet',Sheet,'Range','C5','WriteVariableNames',0);
After this i tried to create a dynamik Matrix and it worked but isn't realy a good solution because of the varible size of 'res':
dname = uigetdir('');
fileName = '\Kapillarrheometer.xlsx';
s = strcat(dname,fileName);
sheet=1;
res = ['Carreau-Parameter:  ';'a = 7521.1446 Pa*s  ']; % and so on...
[r,c] = size(res);
%for i = 1:r
    A=strsplit(res(1,:));
    [Ar,Ac] = size(A);
        if Ac<5
            A=[A nan nan nan];
            else
            A=A;
        end
    B=strsplit(res(2,:)); % and so on...
    allres=[A;B];
%end
alltableres=array2table(allres);
writetable(alltableres,s,'Sheet',Sheet,'Range','C5','WriteVariableNames',0);
disp(alltableres);
Here are the results of 'alltableres':
          allres1           allres2      allres3      allres4    allres5
    ____________________    _______    ___________    _______    _______
    'Carreau-Parameter:'    ''         [NaN]    [ NaN]     [NaN]  
    'a'                     '='        '7521.1446'    'Pa*s'     ''
I tried to use the cellfun/arrayfun command but it didn't worked quite well. After one week of work i am very tired of this problem…
I am open for every help you can offer!
(This is my first post at this forum. Please tell me if i did something wrong with my inputs!)

Best Answer

The example doesn't work as is, exactly...
>> res = ['Carreau-Parameter:  ';'a = 7521.1446 Pa*s  ';'b = 0.10637 s    ';'c = 0.78114   ']; % and so on...
Error using vertcat
Dimensions of arrays being concatenated are not consistent. 
>>
Think you'll get along a lot better if you would use cellstr instead of char() array --
>> res=strtrim([{'Carreau-Parameter:  '};{'a = 7521.1446 Pa*s  '};{'b = 0.10637 s    '};{'c = 0.78114   '}]);
>> cellfun(@strsplit,res,'UniformOutput',false)
ans =
  4×1 cell array
    {1×2 cell}
    {1×5 cell}
    {1×5 cell}
    {1×4 cell}
>> ans{:}
ans =
  1×2 cell array
    {'Carreau-Parameter:'}    {0×0 char}
ans =
  1×5 cell array
    {'a'}    {'='}    {'7521.1446'}    {'Pa*s'}    {0×0 char}
ans =
  1×5 cell array
    {'b'}    {'='}    {'0.10637'}    {'s'}    {0×0 char}
ans =
  1×4 cell array
    {'c'}    {'='}    {'0.78114'}    {0×0 char}
>>
Looks to produce what you asked for. You could eliminate the trailing null char artifact from strsplit.
To put into a regular, rectangular cell array would require augmenting shorter rows to length of the maximum.
Alternatively, if there aren't too many, you could just loop over the array to wrtie altho that will be inefficient.
Related Question