Get selected range in Excel file using MATLAB

2011 9 9
1 个回答
回答已采纳
5 次查看（30 天）

0 个投票

Hello,
I have seen a MATLAB GUI program that is able to open the Excel file and get the range of the cells that the user have selected. This value is returned to MATLAB.
I have no idea how it is possible since the Excel file is normal without any macro. Additionally, when MATLAB opens an Excel file, it does not run anymore so how possible can we obtain anything from Excel ?
Thank you very much in advance.

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

 采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-9-9

0 个投票

The function is probably uiimport. Type uiimport in Command Window to start.
You can also use xlsread(). Type help xlsread to find out.

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Christophe
Christophe 2011-9-9
Thank you for your answer.
I tried with uiimport, I can select the desired range of the Excel file but when I click "Done", it takes the whole matrix and not the selected range only.
Using xlsread, I can read the file and select the desired range if I input the range data but I would like to able to select the range directly on the Excel file (or a wizard) using the mouse.
Christophe
Christophe 2011-9-9
Sorry, I checked the xlsread function again and it seems that putting the flag to -1, gives the possibility to do so.
Thank you for your help.
Fangjun Jiang
Fangjun Jiang 2011-9-9
That's true. You could open the .xls file outside of MATLAB, select the data and copy it (press Ctrl+C), then at the first dialog of uiimport, Select "Clipboard" instead of "File". I just did it and it works.
Christophe
Christophe 2011-9-9
Thank you very much. It works too but I think the xlsread method is more natural for users.
Anyway I did not know the existence of uiimport, it may help me in the future.

请先登录，再进行评论。

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