To correctly plot result using xlswrite1
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
Walter Roberson
on 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 Comments
More Answers (1)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!