extract values from specific cells in excel
조회 수: 37 (최근 30일)
이전 댓글 표시
Hi, I would like to values from specific cells in excel file>>>>>>. Please help me with script to do that. for example, I would like to copy values from cells A1, A6, A11,..A1501....and cells B1, B6, B11,.....B1501 ( as shown in the attached file) into another excel file format. Please note that the reoccurence could be more than the 5 cells in this example. That is it could be A1, A11, A21 (10 cells jump)...or A1, A33, A65,..(32 cells jump) etc. but in all cases reoccurence is always constant.
Thanks for helping
댓글 수: 0
채택된 답변
Caroline
2013년 8월 1일
You can use xlsread:
For example: num = xlsread(filename,sheet,xlRange) and you can specify xlRange to be whatever columns you want to read and it will save all of the values in the cell array num. Then you could possibly index into that cell array and get the values that you need and save those values in a new array.
The you can use xlswrite:
xlswrite(filename,A,sheet,xlRange)
where A would be the array that you created
댓글 수: 4
C G
2018년 4월 5일
How do I combine the values from columns A and B? For example, I would like a new variable with the values from A1 and B1 in the same variable? Then have a new variable containing the values of A2 and B2 in the new variable... and so on.
추가 답변 (1개)
Prakash Adhikari
2020년 9월 15일
편집: Prakash Adhikari
2020년 9월 15일
How do I find the row and column number of a specific data of excel file in matlab?
댓글 수: 1
Carlos GU
2022년 7월 30일
편집: Carlos GU
2022년 7월 30일
Hi
you can xlsread the file and then use 'find' to get row and column number as below script:
File=xlsread(filename);
[rowlist, collist]=find(File=='specific data');
If you want to get the column letters instead of column number, below link may help you:
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!