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

1 次查看（过去 30 天）

显示更早的评论

Abhijit Bari 2018-5-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/402293-i-am-trying-to-enter-data-into-an-excel-spreadsheet-through-matlab-by-prompting-the-user-to-enter-st

回答： ES 2018-5-24

采纳的回答： ES

在 MATLAB Online 中打开

   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 个评论
显示无隐藏无

KSSV 2018-5-24

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

Abhijit Bari 2018-5-24

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 2018-5-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/402293-i-am-trying-to-enter-data-into-an-excel-spreadsheet-through-matlab-by-prompting-the-user-to-enter-st#answer_321731

在 MATLAB Online 中打开

Your xlrange should contain information regarding row number.

For example instead of

xlrange = 'A:C';

use

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

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

请先登录，再进行评论。

更多回答（0 个）

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

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Translated by