XLS2STRUCT

Reads xls-file and converts table into a structure.

이 제출물을 팔로우합니다

[S,E] = XLS2STRUCT(FILE) reads the Excel-file FILE and converts the columns
into separate fields in the structure S. The first line of the file
must contain unique headers for all of the columns, the rest of the file
is data.

Column names can contain spaces, these are converted to underscores in
order to obtain proper variable names.

S is the plane representation of the table. E is a second structure with
an element-wise representation. I.e. notation S.Time(i) versus E(i).Time.

XLS2STRUCT(FILE,SHEET) reads SHEET instead of the default sheet.

Example:
City Time Temp
Dallas 12 98
Tulsa 13 99
Boise 14 97

converts to
S.City = {'Dallas','Tulsa','Boise'}';
S.Time = [12 13 14]';
S.Temp = [98 99 97]';

E(1)
ans =
City: 'Dallas'
Time: 12
Temp: 98

인용 양식

Andreas (2026). XLS2STRUCT (https://kr.mathworks.com/matlabcentral/fileexchange/4104-xls2struct), MATLAB Central File Exchange. 검색 날짜: .

도움

도움 준 파일: xls2mat

일반 정보

MATLAB 릴리스 호환 정보

  • 모든 릴리스와 호환

플랫폼 호환성

  • Windows
  • macOS
  • Linux
버전 퍼블리시됨 릴리스 정보 Action
1.0.0.0

A major bug in the last update.