フィルターのクリア

Export variable Cell data to excel

1 回表示 (過去 30 日間)
Muthukumar Gopalsamy
Muthukumar Gopalsamy 2020 年 12 月 13 日
コメント済み: Muthukumar Gopalsamy 2020 年 12 月 14 日
Hi
My script was like this
export_overlap(k,:) = {'Freq X',i,'Freq Y',ii,'Overlapping',intersect(a, b)}
xlswrite(filename,export_overlap,2,'A1');
i,k,ii are loop indices.
a and b are array of integers of variable length from which common elements has to exported to excel sheet.
since matrix or array has to be of same dimension i have tried cell array method to store in matlab but struct while exporting to excel
when i export the particular cell in excel sheet is empty whenver there is more than one common elements between 'a' and 'b' array
Kindly suggest me how to overcome this
Regards
Muthukumar V G
  2 件のコメント
Matt Gaidica
Matt Gaidica 2020 年 12 月 13 日
Muthukumar, I'm not sure if it will help in the end, but are you aware of the newer functions to generate an XLS in MATLAB 2020? https://www.mathworks.com/help/matlab/ref/xlswrite.html
My guess is your data is formatted in an unpleasant way, can you post the entire function?
Muthukumar Gopalsamy
Muthukumar Gopalsamy 2020 年 12 月 14 日
Matt Gaidica
Attached my full script.
I am using the latest function .Incase the way or inputs provided anything wrong let me know
Regards
Muthukumar

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by