how to add data to the new row
11 views (last 30 days)
Show older comments
I have a code like this when I want to enter data a second, I want to automatically written data on the next line
proses_Callback function (hObject, eventdata, handles)
a = str2num (get (handles.a, 'string'));
b = str2num (get (handles.b, 'string'));
c = str2num (get (handles.c, 'string'));
d = str2num (get (handles.d, 'string'));
e = str2num (get (handles.e, 'string'));
f = str2num (get (handles.f, 'string'));
num = [a, b, c, d, e, f];
mydata = xlswrite ('myfile.xls', num);
0 Comments
Answers (2)
Azzi Abdelmalek
on 22 Jun 2013
num = [a; b; c;d; e; f];
3 Comments
Azzi Abdelmalek
on 22 Jun 2013
Edited: Azzi Abdelmalek
on 22 Jun 2013
In opening function add this:
handles.num=[];
In your proses callback function add:
num=handles.num
num = [num;a, b, c, d, e, f];
handles.num=num;
matlablearner
on 25 Jul 2014
Hi,
Before you set the Data of the uitable, get the previous data and concatenate it with the new data
existingData = get(handles.uitable,'Data'); % Get the existing data
newData = [existingData; newdata]; % Append the data
set(handles.uitable,'Data',newData); % Set the appended data to the table.
Hope it helps.
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!