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

3 次查看（过去 30 天）
Dung Le
Dung Le 2016-1-18
评论： Dung Le 2016-1-18
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!

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

采纳的回答

Stalin Samuel
Stalin Samuel 2016-1-18
[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

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by