To correctly plot result using xlswrite1
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Walter Roberson
2017-2-21
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 个评论
更多回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!