to write to a excel file

2 次查看(过去 30 天)
Sajid Afaque
Sajid Afaque 2019-3-26
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

回答(1 个)

Raghunandan V
Raghunandan V 2019-3-27
There cannot be two users editing a file together. In this case you are one user if the excel is open and Matlab is the other user

产品


版本

R2013b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by