Import xlsx file in workspace (sheet has strings and numbers)?

I want to import an excel sheet in MATLAB, which has strings on the first row & some subsequent rows as well. I have imported the sheet, but only the numbers are highlighted whereas the string row is indicating as NaN. Kindly help me with this.

Answer 1

[Walter Roberson]

[num, txt, raw] = xlsread('YourSheet.xlsx');

then "num" will contain the fields interpreted as numbers, "txt" will contains fields interpreted as text, and "raw" will contain uninterpreted fields.

[Gabriel Zalles]

this solution did not work for me on R2017a, text empty and raw displays NaN for text.