Manipulate Excel from Matlab

4 次查看（过去 30 天）
Virginia
Virginia 2013-6-23
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
The -1 field allows you to use Excel interactively.
[num txt raw] = xlsread(fileName,-1);
  3 个评论
显示 1更早的评论
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by