Manipulate Excel from Matlab

2013 6 23
1 个回答
回答已采纳
4 次查看（30 天）

0 个投票

Hi, I want to know how can develope a code so it open phisically an Excel file, and then save the selected cell range that I'll selected with the mouse as a matrix in Matlab

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

 采纳的回答

Tom
Tom 2013-6-23

0 个投票

The -1 field allows you to use Excel interactively.
[num txt raw] = xlsread(fileName,-1);

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Virginia
Virginia 2013-6-23
编辑：Virginia 2013-6-23
Sorry, as I said, I'm new at this, I want to convert the answer this gives me to a matrix, right now it shows like this with your suggestion
[ 5.2343e+04] [-2.7790e+04] [ 3.1647e+03] [ -193.0416]
[-2.7790e+04] [ 4.9210e+04] [-2.7469e+04] [ 2.8949e+03]
[ 3.1647e+03] [-2.7469e+04] [ 4.8519e+04] [-2.3946e+04]
[ -193.0416] [ 2.8949e+03] [-2.3946e+04] [ 2.1198e+04]
And I want it to be showed as a Matrix for example
1.0e+04 *
5.2343 -2.7790 0.3165 -0.0193
-2.7790 4.9210 -2.7469 0.2895
0.3165 -2.7469 4.8519 -2.3946
-0.0193 0.2895 -2.3946 2.1198
Is there a command to convert this? or any other way to do it?
Tom
Tom 2013-6-23
I think you're looking at the raw data, rather than the numeric data (see the three outputs you get from XLSREAD)?
Otherwise, try:
cell2mat(data)
Virginia
Virginia 2013-6-23
I just did it, I just had to set the name of the variable for example
[K] = xlsread(comp,-1)
And that will save the range cell in matlab.
Thanks Tom!

请先登录，再进行评论。

更多回答（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