How to place text in a single excel cell?
56 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I'm running a series of analyses and exporting information to an Excel file to make it easier to summary, do additional analyses, share with collaborators, etc, and I have run into an issue that is probably very simple (so my aplogies if I have missed an obvious solution).
When I export the data to excel, I would like to export text to multiple cells. For example, if I were adding the value "Connecticut" to five cells in a single columns. The goal is to produce something like this:
I am using something similar to the following:
label = 'Connecticut';
label = repmat(label,5,1);
xlswrite(fid,label,sheet1,'A1');
which produces this:
so the script is importing the individual values (characters) into individual cells, rather than the entire row. Is there a simple way to change this?
Thanks,
Robert
0 commentaires
Réponse acceptée
Walter Roberson
le 21 Fév 2019
label = repmat( {label}, 5, 1)
3 commentaires
Walter Roberson
le 21 Fév 2019
T = 'hello';
label = repmat({T}, 5, 1);
%these next two can only work on MS Windows with Excel installed
xlswrite('testxx.xlsx', label)
xlswrite('testxc.csv', label)
%these will work on any release since tables were introduced
TT = array2table(label);
writetable( TT, 'testtx.xlsx', 'writevariablenames', false)
writetable( TT, 'testtc.csv', 'writevariablenames', false)
Plus de réponses (1)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB 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!