How to write all cells of structure in excel sheet ?
Hello all,
I have variable which has 1×1 structure, and this structure has many field (it can be reached to 200). each field has has diffrent size of cells as explained in the images.
I want to write the results in excel sheel. like in the uploaded image:
my code is:
writematrix (‘Day’,’Results_Theta.xlsx’,’WriteMode’,’replacefile’,’Sheet’,’Theta’,’Range’,’A1′);
writematrix (‘Theta 1′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’B1′);
writematrix (‘Theta 2′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’C1′);
writematrix (‘Theta 3′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’D1′);
writematrix (‘Theta 4′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’E1′);
writematrix (‘Theta 5′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’F1′);
writematrix (‘Theta 6′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’G1′);
writematrix (‘Theta 7′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’H1′);
So, how can I write the results?Hello all,
I have variable which has 1×1 structure, and this structure has many field (it can be reached to 200). each field has has diffrent size of cells as explained in the images.
I want to write the results in excel sheel. like in the uploaded image:
my code is:
writematrix (‘Day’,’Results_Theta.xlsx’,’WriteMode’,’replacefile’,’Sheet’,’Theta’,’Range’,’A1′);
writematrix (‘Theta 1′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’B1′);
writematrix (‘Theta 2′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’C1′);
writematrix (‘Theta 3′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’D1′);
writematrix (‘Theta 4′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’E1′);
writematrix (‘Theta 5′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’F1′);
writematrix (‘Theta 6′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’G1′);
writematrix (‘Theta 7′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’H1′);
So, how can I write the results? Hello all,
I have variable which has 1×1 structure, and this structure has many field (it can be reached to 200). each field has has diffrent size of cells as explained in the images.
I want to write the results in excel sheel. like in the uploaded image:
my code is:
writematrix (‘Day’,’Results_Theta.xlsx’,’WriteMode’,’replacefile’,’Sheet’,’Theta’,’Range’,’A1′);
writematrix (‘Theta 1′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’B1′);
writematrix (‘Theta 2′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’C1′);
writematrix (‘Theta 3′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’D1′);
writematrix (‘Theta 4′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’E1′);
writematrix (‘Theta 5′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’F1′);
writematrix (‘Theta 6′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’G1′);
writematrix (‘Theta 7′,’Results_Theta.xlsx’,’Sheet’,’Theta’,’Range’,’H1′);
So, how can I write the results? writematrix MATLAB Answers — New Questions