table to excel code update
Afficher commentaires plus anciens
in matlab 2020 my code was working very good when i update to 2021 my code didn't work any more and it says Error using cellfun
Input #2 expected to be a cell array, was struct instead.
my code was i don't know what is change in matlab 2021a ? and how to correct it
to convert table with struct to excel sheet
if true
n = cellfun(@length,result.bw);
f = repelem(result.fileName,n);
s = vertcat(result.bw{:});
s = struct2table(s);
s.fileName = f;
writetable(s,'myexcel.xlsx');
end
3 commentaires
Image Analyst
le 18 Juil 2021
Not sure what bw is, but if it's an image length(bw) will give you the largest of either (1) the number of columns in the image, or (2) the number of rows in the image. I really don't know what you're after because there are no comments to give example expected results. If you want to write f, just write f. Why are you adding it to a structure and then trying to write the structure???
So edit your original post and
- add comments to your code and
- add result in a .mat file with the paperclip icon
save('answers.mat', 'results');
Then I can work on fixing it.
Walter Roberson
le 18 Juil 2021
https://www.mathworks.com/matlabcentral/answers/795837-how-to-convert-table-with-struct-to-excel-sheet?s_tid=srchtitle appears to be relevant.
So whatever was storing cell array of struct array into the table object is storing something else instead. We would need the code that is creating the bw variable in the table object.
hussain abdelaziz
le 23 Juil 2021
Réponses (0)
Catégories
En savoir plus sur Data Type Conversion dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!