Extracting the whole column from excel file and putting it in a new excel file?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello I have excel file that contains the things that I need and things that I don't.
text1.xls
Jshgfy Kashs Klaksh Item Khabsd Hsgbana Quantity
1 2 4 1 4 4 1
1 3 4 24 4 2 3
2 2 3 2 1 1 1
Things that I need are the item and quantity column. This is what I tried.
fh = xlswrite('texxt.xls'); % created a new file
[num text raw] = xlsread ['text1.xls];
I took raw and did strcmp(raw, item) to find the position of item on the xls file but I got an error. How do I find the position of item and quantity and extract the whole column and put in the new file?
Thank you.
2 commentaires
per isakson
le 1 Mar 2015
Modifié(e) : per isakson
le 1 Mar 2015
xlsread['text1.xls]; rather than xlsread('text1.xls'); is that a typing mistake? Use copy&paste!
What exactly did you try and what error message did you get?
Réponse acceptée
Image Analyst
le 1 Mar 2015
Do you not know in advance what column number 'item' may be in? Use ismember() to find the column number if you can't use a known, predetermined column number.
4 commentaires
Image Analyst
le 2 Mar 2015
Try this:
ca = {'Jshgfy', 'Kashs', 'Klaksh', 'Item', 'Khabsd', 'Hsgbana', 'Quantity'}
[ia, ib] = ismember(ca, {'Item'})
letter = find(ia) + 'A' - 1
cellReference = sprintf('%c:%c', letter, letter)
Plus de 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!