清空筛选条件
清空筛选条件

To correctly plot result using xlswrite1

1 次查看（过去 30 天）
Fadzli
Fadzli 2017-2-21
回答： Fadzli 2017-2-23
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

请先登录，再回答此问题。

采纳的回答

Walter Roberson
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.

更多回答（1 个）

Fadzli
Fadzli 2017-2-23
Yes, thank you very much Mr Walter Roberson. I just didn't realize about that. Really appreciate it.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by