Import Data from excel sheet
Import Data from excel sheet
(OP)
I have a .xls sheet which consists of strings and numerics. I want to load it into a matrix in order to do further calculations etc. The xlsread function in matlab works only if the strings are placed in the header. In my case however it does not work since the strings are placed in several columns. Please help.
Thanks
Thanks





RE: Import Data from excel sheet
RE: Import Data from excel sheet
I have attached a sample file to show the kind of data I have in it. I want to import this data into a matrix in matlab. Once imported into a matrix say A, I would like to access the elements of this matrix irrespective of it being a number or a string. I hope that is clearer now. Thanks
RE: Import Data from excel sheet
A(:,size(num,2)+1:end)=[]; % You have some extra crap in there. Delete it.
A{2,2} % Use curly braces for addressing cell contents
A{end,end} % make sure we got it.
isnumeric(A{1,1}) % checks before dealing with contents
ischar(A{4,2})