How can i access to a xlsx file including both numbers and string to process data ?
8 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Dung Le
am 18 Jan. 2016
Kommentiert: Dung Le
am 18 Jan. 2016
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!
0 Kommentare
Akzeptierte Antwort
Stalin Samuel
am 18 Jan. 2016
[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
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Workspace Variables and MAT-Files finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!