MATLAB: Paste data in uitable one col at a time

paste datauitable

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

Best Answer

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.
Related Question