- You need to make sure the size and format (cell array or data array) match
- You probably need to decide which column to write based on the current selected cell in the uitable.
paste data in uitable one col at a time
9 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
采纳的回答
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:
2 个评论
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 中查找有关 Environment and Settings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!