How to write cell array to excel file

47 visualizaciones (últimos 30 días)
parham kianian
parham kianian el 9 de Abr. de 2020
Respondida: Qiang Lei el 20 de Mayo de 2022
I have a cell array whose elements have different sizes. How can I write it to an excel file?
For example:
a = rand(10,1);
b = rand(5,1);
c = rand(4,8);
X = {a, b, c};
How can I export X to an excel file?

Respuesta aceptada

Walter Roberson
Walter Roberson el 9 de Abr. de 2020
If the desired output is a worksheet in which the first column has 10 rows, and the second column has 5 rows, and then the next 8 columns have 4 rows, with the unused portions of each column being empty: then you cannot directly do that.
However, you can use:
vars = {a,b,c};
varnames = {'a', 'b', 'c'};
rows = cellfun(@(M) size(M,1), vars);
cols = cellfun(@(M) size(M,2), vars);
maxrows = max(rows);
T = table();
for K = 1 : length(varnames)
T.(varnames{K}) = [vars{K}; nan(maxrows - rows(K), cols(K))];
end
writetable(T, 'X.xlsx');
  2 comentarios
BN
BN el 9 de Abr. de 2020
+1
parham kianian
parham kianian el 10 de Abr. de 2020
It works well.

Iniciar sesión para comentar.

Más respuestas (2)

BN
BN el 9 de Abr. de 2020
Editada: BN el 9 de Abr. de 2020
Try this:
writecell(X, 'X.xlsx')
  2 comentarios
Walter Roberson
Walter Roberson el 9 de Abr. de 2020
The result of that would be a single row with numel(a)+numel(b)+numel(c ) columns.
parham kianian
parham kianian el 10 de Abr. de 2020
It does not work. Walter is right.

Iniciar sesión para comentar.


Qiang Lei
Qiang Lei el 20 de Mayo de 2022
writetable(cell2table(X), 'X.xlsx')

Community Treasure Hunt

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

Start Hunting!

Translated by