division of uploaded excel file

2014 8 22
1 个回答
回答已采纳
更新时间：2014 8 22
3 次查看（30 天）

0 个投票

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 个评论
显示 2更早的评论 隐藏 2更早的评论

Hikaru
Hikaru 2014-8-22
The filename has to contain the file extension as well. Something like this:
xlsread('Book2.xlsx','Yield')
Giorgi
Giorgi 2014-8-22
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
Hikaru 2014-8-22
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
Giorgi 2014-8-22
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.

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Hikaru
Hikaru 2014-8-22

0 个投票

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

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by