Converting Excel columns to a vector

70 views (last 30 days)
Daniel Jednorozec on 13 Jul 2012
Answered: Sidra Khalid on 22 Dec 2018
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
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?
Nirmal on 13 Jul 2012
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 on 13 Jul 2012
hf=[];
for i = 1:3 % Loop over the files
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.
Daniel Jednorozec on 16 Jul 2012
Generally speaking there seems to tend to be 328 rows, but I recently had a file that went for double the time (the rows represent half second data marks), so it can go longer sometimes.

nanren888 on 13 Jul 2012
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?
Daniel Jednorozec on 13 Jul 2012
Columns are always the same length in this case.

Daniel Jednorozec on 17 Jul 2012
Ok, I figured out the problem. Apparently the first file is being treated as if it is somehow a different length than the other two files, so when I went from file 2 to file 3 it worked perfectly and printed to the excel file exactly as I wanted. So now I just need to see what exactly is different about the first file and I should have what I was looking for. Thank you everyone for your help.

Sidra Khalid on 22 Dec 2018
how i write this program

Sidra Khalid on 22 Dec 2018
this is the remaining part..anyone help me please..is convert it from excel to matlab or matlab to exicel?