MATLAB Answers

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

조회 수: 3(최근 30일)
Abhijit Bari
Abhijit Bari 24 May 2018
답변: ES 24 May 2018
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)
  댓글 수: 2
Abhijit Bari
Abhijit Bari 24 May 2018
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.

댓글을 달려면 로그인하십시오.

채택된 답변

ES
ES 24 May 2018
Your xlrange should contain information regarding row number.
For example instead of
xlrange = 'A:C';
use
xlrange = ['A', num2str(a), ':C', num2str(a)];

추가 답변(0개)

Community Treasure Hunt

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

Start Hunting!

Translated by