To correctly plot result using xlswrite1

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

Answer 1

[Walter Roberson]

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.

Answer 2

[Fadzli]

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