MATLAB Answers

division of uploaded excel file

3 views (last 30 days)
Giorgi
Giorgi on 22 Aug 2014
Commented: Giorgi on 22 Aug 2014
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
  4 Comments
Giorgi
Giorgi on 22 Aug 2014
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.

Sign in to comment.

Accepted Answer

Hikaru
Hikaru on 22 Aug 2014
[Yield,txt,alldata]=xlsread('Book2','Yield');
a=length(txt(1,:))
for i=1:a
assignin('base',[txt{i}],Yield(:,i));
end
  1 Comment
Giorgi
Giorgi on 22 Aug 2014
Well that works thanks a lot

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by