to write to a excel file

Question

Sajid Afaque 2019-3-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/452365-to-write-to-a-excel-file

回答： Raghunandan V 2019-3-27

hi ,

i have enclosed my code below. i am able to read and write to excel file, but the problem is i am able to write only when the excel file is closed.i am not able to read or write when the excel file is open.kindly help

d = {getenv('username') , date ,  datestr(now, 'HH:MM PM')};
[~, user_id] = xlsread('C:\Users\AFQ1KOR\Desktop\newfolder\kkr.xlsx','A:A');
access = ismember(getenv('username') , user_id );
if access == 1
     [~, record] = xlsread('C:\Users\AFQ1KOR\Desktop\newfolder\Book11.xlsx','A:A');
     q = size(record, 1); 
     r = q + 1;
    xlswrite('C:\Users\AFQ1KOR\Desktop\newfolder\Book11.xlsx', d,sprintf('A%d:C%d', r, r));
else 
       errordlg(' please contact sajid for more details','Access denied','modal')
       uicontrol(hObject)
end