writing 1*5 char in one cell in excel

조회 수: 6 (최근 30일)
alex
alex 2011년 11월 18일
댓글: Itamar Calderón Osuna 2019년 3월 24일
i have a problem- i have parameter in matlab called patients = 82x5 type char when each row is like 234t1(has both numbers and a letter)
i want to import it to excel so that each patient name will be in one cell and not 5..( a1 = 234t1, a2 = 234t2,...)
how can i do that?

채택된 답변

Fangjun Jiang
Fangjun Jiang 2011년 11월 19일
xlswrite('test.xls',cellstr(patients))
  댓글 수: 2
alex
alex 2011년 11월 19일
thanks!!
i spent so much time on such a little thing...
i works great
Itamar Calderón Osuna
Itamar Calderón Osuna 2019년 3월 24일
Great help! Thank you!
I was sending a date to Excel and, instead of writing the full date in a single Excel cell, it wrote each character in a separate cell. After using cellstr() the problem was solved!

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

추가 답변 (1개)

John
John 2011년 11월 19일
Perhaps the following would work:
xlswrite('test.xls', cellstr(x))
Where "x" is a character array

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by