headings in excel
9 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I was wondering if anyone knows how to make column headings using xlswrite function. I tried making a string array that would precede the data, but in the .xls file xlswrite function would expand every character in the string into individual cells, rather than the entire string in one cell to act as the column title. If anyone knows how to have the string, act like a number so that they can be added into the excel in one cell, I would really appreciate it.
- thanks
0 commentaires
Réponse acceptée
Plus de réponses (1)
Eamonn
le 19 Juin 2012
The above solution seems a bit excessive. What if you just did something like this:
T = {'Apple', 'Bear', 'Cat', 'Dog'}; xlswrite(filenameA, T, 1, 'A1');
or if it's just a once off set of titles
xlswrite(filenameA, {'Apple', 'Bear', 'Cat', 'Dog'}, 1, 'A1');
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!