Extracting the whole column from excel file and putting it in a new excel file?
조회 수: 1 (최근 30일)
이전 댓글 표시
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
per isakson
2015년 3월 1일
편집: per isakson
2015년 3월 1일
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?
채택된 답변
Image Analyst
2015년 3월 1일
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
Image Analyst
2015년 3월 2일
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)
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!