Transpose a cell matrix and copy it in excel
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Dear all,
I have a problem. I read a series of files in a for cycle and copy them in excel like this:
T=(importdata(fullfile(pathLS,'\References\','allglom.dat'));
xlswrite('E:\Functional Data\dHex_vs_Hex\filename1.xls', T, 1, sprintf('A%d',offset));
However, I have found a way only to copy them one below the other by increasing the "offset" paramenter at every cycle (which I dont want). Is there a way to copy them one aside to the other instead?
As an alternative, I thought about transposing the cell matrix T (in this way i could copy all them one below the others)
Trasp=T.';
But when I do the same operation and write in excel the new cell matrix "Transp" the script gives me the following error. Anyone has a solution for my problem (either how to paste arrays one next to the others in excel or how to paste transposed cell matrices one below the other)?
Error using xlswrite (line 220) Excel returned: Error: Object returned error code: 0x800A03EC.
Error in concatenate_mp090114 (line 32) xlswrite('E:\Functional Data\dHex_vs_Hex\filename1.xls', t, 1, sprintf('A%d',offset));** *
0 commentaires
Réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!