paste data in uitable one col at a time

4 次查看（过去 30 天）
Nuno
Nuno 2011-11-9
Hi,
I managed to paste data from excel into matlab uitable thanks to Roland's solution in KeyPressFcn. Here is how i do it:
import = importdata('-pastespecial');
set(handles.uitable1,'Data',import);
But this only works if i copy all data from excel at same time.
What I want is to be able to paste one column at a time from different excel files without overwriting the already pasted data on uitable and without having the work of pasting all data to a temporary excel file and then to the uitable... any assistance will be appreciated
Thanks

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-11-9
It can be done. But you've known that when you set the data of the uitable, you have to set the whole table data, not just a particular column.
So, in your function, you'll have to read in the uitable data first, and then set a particular column, and then write the data back.
data=get(handles.uitable1,'Data');
data(:,3)=importdata('-pastespecial');
set(handles.uitable1,'Data',data);
A couple of things:
  1. You need to make sure the size and format (cell array or data array) match
  2. You probably need to decide which column to write based on the current selected cell in the uitable.
  2 个评论
Nuno
Nuno 2011-11-9
The problem is that when you paste into a specific column (in this case col 3) the uitable replaces previous data (columns 1 and 2) with zeros.
if there was a way to append data instead of replacing...
Fangjun Jiang
Fangjun Jiang 2011-11-17
Then read the old table data, read the data from clipboard and do the insertion.
OldData=magic(5);
PasteData=rand(5,1);
NewData=[OldData(:,1:2),PasteData,OldData(:,3:5)]

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by