How can i access to a xlsx file including both numbers and string to process data ?
조회 수: 8 (최근 30일)
이전 댓글 표시
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
채택된 답변
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Workspace Variables and MAT-Files에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!