division of uploaded excel file

Hi all, well i want to upload excel file and then divided it in parts, the excel file contains text and numerical data, i wrote a code but it doesn't work so any idea would be great.

[Yield,txt,alldata]=xlsread('Book2','Yield'); a=length(txt(1,:)) i=1;

while(i<=a) txt(1,i)=Yield(:,i+1); i=i+1; end

[Hikaru]

The filename has to contain the file extension as well. Something like this:

xlsread('Book2.xlsx','Yield')

[Giorgi]

The problem is not that, that's ok, the problem is that in this code txt(1,i)=Yield(:,i+1);. For example txt(1,;)='first' and Yield(:,i+1)=[3.4;4.6;2.7] well it says that it can't be create variable called as first that contains [3.4;4.6;2.7].

[Hikaru]

I am not sure I understood your problem. How about providing us with sample values of Yield, txt, and alldata for a starter?

And tell us what kind of error does matlab give?

[Giorgi]

I uploaded excel file for you and now i want to upload it and divide it into three variables called as first second and third and assign them the data that is below them in the excel file.

Answer 1

[Hikaru]

    [Yield,txt,alldata]=xlsread('Book2','Yield');
    a=length(txt(1,:))
    for i=1:a
      assignin('base',[txt{i}],Yield(:,i));
    end

[Giorgi]

Well that works thanks a lot