Converting Excel columns to a vector
23 次查看(过去 30 天)
显示 更早的评论
I am trying to access a specific column from different files and convert them into a matrix to be used later but I am running into problems and I'm not sure what I am doing wrong. Here is the part of my code I am trying to do it in, if anyone can tell me what I'm doing wrong I would greatly appreciate it.
for i = 1:3 % Loop over the files
a = xlsread(dataFiles{i}); % Load the data
c = a(:,3); % takes the third column from the file
hf(:,i) = c*(100^2); % converts the values and makes a matrix
end
Is it that I need to convert the cells to a matrix using cell2mat?
3 个评论
Nirmal
2012-7-13
it means that the size of hf and size of c are not same. See the size of both hf and c using size() function.
采纳的回答
Nirmal
2012-7-13
hf=[];
for i = 1:3 % Loop over the files
a = xlsread(dataFiles{i}); % Load the data
c = a(:,3); % takes the third column from the file
hf =[hf c*(100^2)]; % converts the values and makes a matrix
end
This should work for you.
3 个评论
更多回答(4 个)
nanren888
2012-7-13
Are the columns always the same length?
If the dimensions, length of hf(:,i) & c are different you may need to consider
hf(ran,k) = c....
Like Conrad said, can you post the error message?
Sidra Khalid
2018-12-22
![IMG-20181211-WA0001.jpg](https://www.mathworks.com/matlabcentral/answers/uploaded_files/199630/IMG-20181211-WA0001.jpeg)
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!