To correctly plot result using xlswrite1
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Fadzli
am 21 Feb. 2017
Beantwortet: Fadzli
am 23 Feb. 2017
Hi,
I'm using xlswrite1 to plot my 500 results in excel file. This is the code;
header_result_file_name={'CA','x','y','z'};
xlswrite1(result_file_name,header_result_file_name,ww,'A1');
xlswrite1(result_file_name,AAA,ww,'A2');
Excelworkbook.Worksheets.Item(ww).Range('A1:D1').Interior.ColorIndex = 40;
xlswrite1(result_file_name,CA,ww,'A2');
xlswrite1(result_file_name,x_new,ww,'B2');
xlswrite1(result_file_name,y_new,ww,'C2');
xlswrite1(result_file_name,z_new,ww,'D2');
Everything going just fine, except the last result (500th) is going up to overwrite the first result. So instead of 500 results, I just have 499 results (500,2,3,....499) which I lost my first result. Maybe there is an error in my xlswrite1 command? Anyone can help? Thanks.
p/s: AAA is my matrice results, ww is the loop number
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 21 Feb. 2017
You have
xlswrite1(result_file_name,AAA,ww,'A2');
and
xlswrite1(result_file_name,CA,ww,'A2');
so you are writing two different things at A2.
0 Kommentare
Weitere Antworten (1)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!