Azzera filtri
Azzera filtri

Save an output file which is a cell

1 visualizzazione (ultimi 30 giorni)
Lavanya S
Lavanya S il 11 Ott 2018
Risposto: OCDER il 11 Ott 2018
How to write a cell to excel sheet (or in any format). The cell contains strings as well as doubles. Thanks in advance

Risposte (1)

OCDER
OCDER il 11 Ott 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

Categorie

Scopri di più su Cell Arrays in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by