i have a problem to write to a excel

Question

Sajid Afaque 2019-3-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/451392-i-have-a-problem-to-write-to-a-excel

评论： Sajid Afaque 2019-3-25

hi, i need to write user_id and date in a seperate excel sheet .I want to write it to a new line in my excel document ' instead of overwriting previous lines in my excel document Book11.I just want it to jump a line. Note( I don't know what line I want it to write to, I just want the code to find the previous line in the excel doc and them simply write to the next one). i have a problem with xlswrite in line 8. Please do help i have enclosed the code and the excel sheet.

d = {'usre_id' , date};
[~, user_id] = xlsread('C:\Users\AFQ1KOR\Desktop\newfolder\kkr.xlsx','A:A');
access = ismember('afq1kor' , user_id );
if access == 1
     [~, record] = xlsread('C:\Users\AFQ1KOR\Desktop\newfolder\khan2.xlsx','A:A');
     q = length(record);
     r = q + 1;
     xlswrite('C:\Users\AFQ1KOR\Desktop\newfolder\Book11.xlsx',d,'Ar:Br');
end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan 2019-3-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/451392-i-have-a-problem-to-write-to-a-excel#answer_366574

在 MATLAB Online 中打开

You got it almost:

q = size(record, 1);  % Safer than LENGTH
r = q + 1;
xlswrite('C:\Users\AFQ1KOR\Desktop\newfolder\Book11.xlsx', d, ...
         sprintf('A%d:B%d', r, r);

'Ar:Br' does not insert the contents of the variable r in the char vector. Use sprintf to insert the number to the char vector.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sajid Afaque 2019-3-25

thanks jan

请先登录，再进行评论。

Answer 2

Alex Mcaulley 2019-3-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/451392-i-have-a-problem-to-write-to-a-excel#answer_366573

在 MATLAB Online 中打开

Try this:

d = {'usre_id' , date};
[~, user_id] = xlsread('C:\Users\AFQ1KOR\Desktop\newfolder\kkr.xlsx','A:A');
access = ismember('afq1kor' , user_id );
if access == 1
     [~, record] = xlsread('C:\Users\AFQ1KOR\Desktop\newfolder\Book11.xlsx','A:A');
     if size(d,2)>size(record,2)
        record(:,size(record,2)+1:size(d,2)) = deal({[]});
     else
        d(:,size(d,2)+1:size(record,2)) = deal({[]}); 
     end
     xlswrite('C:\Users\AFQ1KOR\Desktop\newfolder\Book11.xlsx',[record;d]);
end