To correctly plot result using xlswrite1
조회 수: 1 (최근 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!