% this is the code but it is attached to a button in gui
filename = 'key_performance1';serial_number = get(handles.sn,'string');head_super = get(handles.hs,'string');task_id = get(handles.t_id,'string');user_sec = get(handles.u_s,'string');tas = get(handles.tsk,'string');solut = get(handles.sol,'string');stat = get(handles.st,'string');complt = get(handles.com,'string');prio = get(handles.pri,'string');date_of_en = get(handles.doe,'string');estim_time = get(handles.es_t,'string');due_day = get(handles.d_d,'string');length_of = get(handles.lof,'string');res_used = get(handles.ru,'string');const = get(handles.con,'string');asst = get(handles.ast,'string');B = {'SERIAL NO','HEAD/SUPERVISOR','TASK ID','USER SECTION','TASK',... 'SOLUTION','STATUS','COMPLETE','PRIORITY','DATE OF ENTRY','ESTIMATED TIME OF RESPONSE',... 'DUE DAY','LENGHT OF RESPONSE','RESOURCES USED','CONSTRAINTS','ASSIGNED TO';serial_number,head_super,... task_id,user_sec,tas,solut,stat,complt,prio,date_of_en,estim_time,due_day,length_of,res_used,const,asst};sheet = 1;xlRange = 'A';row = 1;if isfield(handles,'row') row = handles.row;endxlswrite(filename,B,sheet,[xlRange num2str(row)]);handles.row = row + 1;
MATLAB: Hi. I have an a problem updating the excel file without overwriting the previous datas on the excel sheet. Am using a button to submit the input datas from matlab gui to the excel sheet.
problem updating excel file without overwriting previous datas in gui
Best Answer