How to convert raw cell in [num,txt,raw] = xlsread to ordinary matrix if I have three string columns by using Matlab

조회 수: 2 (최근 30일)
Ahmed
Ahmed 2016년 1월 19일
답변: Walter Roberson 2016년 1월 20일
I have Excel files containing string and numeric data such as...
ID_REF Entrez Gene Gene Symbol SD_cancer 1 SD_cancer 2 SD_cancer 3 SD_cancer 4 SD_cancer 5
221438_s_at 56158 TEX12 2.946576 3.112977 2.968877 3.160022 2.998543
31826_at 23307 FKBP15 7.358873 7.415367 7.260536 7.281535 7.391214
The first three columns are strings and the rest of the columns are numeric. I used [num,txt,raw] = xlsread to read my Excel file. I want to convert raw cell to ordinary matrix to go further with my analysis. I tried to use cell2mat importdata textscan, but it does not work for me. Could you please help me to convert raw to matrix? I will be grateful to you.

이 질문에 답변하려면 로그인하십시오.

답변 (1개)

Walter Roberson
Walter Roberson 2016년 1월 20일
No, it is not possible to create an ordinary matrix that contains both text and numeric values.

카테고리

Help Center 및 File Exchange에서 Standard File Formats에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by