MATLAB: How can i access to a xlsx file including both numbers and string to process data

Question

Hi!

I would like to import a xlsx file into matlab in order to process data more easily. This file (a matrix) contains both numbers and strings.

When i read on forum, i found that we can use this syntax : [num,txt,raw] = xlsread('file.xls'); . But i don't know how to access to this file ( I don't see the name in this syntax to call it in function).

For example, I often use the simple syntax: A = xlsread('file.xlsx'); . In this syntax when i want to process data, i use syntax A(i,j). This means I have a specific name A to call.

But in the syntax [num,txt,raw] = xlsread('file.xls') I don't see any name. Can somebody help me?

Thank you for your support!

Answer 1

 [num,txt,raw] = xlsread('file.xls') 
 here you have 3 names
 1.num-->numeric data in a matrix. 
 2.txt-->text fields in cell array 
 3.raw-->both numeric and text data in cell array

reference