Extracting the whole column from excel file and putting it in a new excel file?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
per isakson
il 1 Mar 2015
Modificato: per isakson
il 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?
Risposta accettata
Image Analyst
il 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 Commenti
Image Analyst
il 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)
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!