Save an output file which is a cell

2 visualizaciones (últimos 30 días)
Lavanya S
Lavanya S el 11 de Oct. de 2018
Respondida: OCDER el 11 de Oct. de 2018
How to write a cell to excel sheet (or in any format). The cell contains strings as well as doubles. Thanks in advance

Respuestas (1)

OCDER
OCDER el 11 de Oct. de 2018
Data = {'string', 1, [1 2 3 4]};
%Make sure there is no multi-element entity in each cell (like the matrix)
MatLoc = cellfun(@(x) isnumeric(x) && numel(x) > 1, Data);
Data(MatLoc) = cellfun(@mat2str, Data(MatLoc), 'un', 0);
xlswrite('MyFile.xlsx', Data);
%OR
writetable(cell2table(Data), 'MyFile2.xlsx'); %Use (..., 'WriteVariableNames', 0) inputs if
%you don't want "Data1, Data2, Data3" as the first row

Categorías

Más información sobre Cell Arrays en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by