i am trying to enter data into an excel spreadsheet through matlab by prompting the user to enter string . The next data doesn't go to the next row in the spreadsheet

   for a = 1:(desired_number)
  det_1=[]
      con_1=[]
      disease_1=[]
      det = 'Enter the details for patient ';
      det_1 = input(det,'s')
      con = 'Enter his Condition'
      con_1 = input(con,'s')
      disease = 'enter his diseases'
      disease_1=input(disease,'s')
      %disp(det_1)
      %disp(con_1)
      %disp(disease_1)
      %t = table(det_1,con_1,disease_1)
      patient = 'filename';
      M = {'Patient_No ','Condition','Disease';det_1,con_1,disease_1};
      sheet = 1;
      xlrange = 'A:C';
      xlswrite(patient,M,sheet,xlrange)

[KSSV]

YOu make your cell ready....and write all data at a time..

[Abhijit Bari]

I am writing continuously but after a data in a row is filled , i want it to go to the next row in the sheet, and i don't know how to do that.

Answer 1

[ES]

Your xlrange should contain information regarding row number.

For example instead of

xlrange = 'A:C';

use

xlrange = ['A', num2str(a), ':C', num2str(a)];