How can i access to a xlsx file including both numbers and string to process data ?
7 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
Stalin Samuel
on 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
More Answers (0)
See Also
Categories
Find more on Workspace Variables and MAT-Files in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!