How to copy cells from one excel sheet to another
17 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
pradeep kumar
le 8 Nov 2014
Commenté : pradeep kumar
le 8 Nov 2014
Hellow everyone . I have one excel sheet like this
excelsheet1.xlsx =
Name Age
Tom 20
Dick 15
Harry 25
Now i want to copy the column A from excelsheet1.xlsx and make another excel file like this
excelsheet2.xlsx =
Name Age_after_5_years
Tom 25
dick 20
Harry 30
Please help me . Thanks in advance
0 commentaires
Réponse acceptée
Image Analyst
le 8 Nov 2014
Try something like this
[numbers, strings, raw] = xlsread('excelsheet1.xlsx');
columnA = raw(:, 1);
xlswrite('excelsheet2.xlsx', columnA);
From your example though, it looks like you might want both column A (the row headers) and column B (the numbers).
Plus de réponses (0)
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!