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
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Enayat Ansari
il 16 Dic 2016
Commentato: Walter Roberson
il 16 Dic 2016
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);
Risposta accettata
Damjan Lasic
il 16 Dic 2016
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
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!