extract values from specific cells in excel
显示 更早的评论
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
采纳的回答
Caroline
2013-8-1
2 个投票
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 个评论
olu
2013-8-1
Caroline
2013-8-1
To read the excel file and get the values that you want I think I would do something like this:
num1 = xlsread('C:\path_to_filename', 'A:A'); %read in first column
num2 = xlsread('C:\path_to_filename', 'B:B'); %read in second column
len= length(num1);
%length of num1 and num2,assuming there are the same number of values in columns A and B
num1_new = zeros; %creates array of all zeros num2_new = zeros; %creates array of all zeros
ind = 0; %will use this as an index into new array with the extracted values
%if for example you want to get the 1st, 3rd, 5th...
for i= 1:2:len
%go from 1 to length of n in increments of 2 (the step would change depending on which values you want to extract)
ind = ind + 1;
num1_new(ind) = num1(i);
num2_new(ind) = num2(i);
end
num1_new would contain all of the relevant values from column A, and num2_new would contain all of the relevant values from column B
olu
2013-8-1
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
0 个投票
How do I find the row and column number of a specific data of excel file in matlab?
1 个评论
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:
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Translated by 
