How can i write at specific location in excel using loop ? let say i want to write at C in ith index so what wil the correct code ? please its urgent

clear all;
clc
values = 'P';
i=8; %let say iteration value is 8 in a loop
xlRange = 'Ci:Ci'; %it doesn't work
xlswrite('e:/testSheet.xlsx',values,xlRange);

[Walter Roberson]

http://www.mathworks.com/matlabcentral/answers/29922-why-your-question-is-not-urgent-or-an-emergency

Answer 1

[Damjan Lasic]

you need a correct way to transform your numeric values to string. like this:

   xlRange = ['C',num2str(i),':C',num2str(i)];

or modify to your liking

[Enayat Ansari]

Thanks #Damjan Lasic it's working