XLS2STRUCT

버전 1.0.0.0 (3.48 KB) 작성자: Andreas
Reads xls-file and converts table into a structure.
다운로드 수: 3.7K
업데이트 날짜: 2005/1/28

라이선스 보기

[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 (2024). XLS2STRUCT (https://www.mathworks.com/matlabcentral/fileexchange/4104-xls2struct), MATLAB Central File Exchange. 검색됨 .

MATLAB 릴리스 호환 정보
개발 환경: R14SP1
모든 릴리스와 호환
플랫폼 호환성
Windows macOS Linux
카테고리
Help CenterMATLAB Answers에서 Spreadsheets에 대해 자세히 알아보기
도움

줌: xls2mat

Community Treasure Hunt

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

Start Hunting!
버전 게시됨 릴리스 정보
1.0.0.0

A major bug in the last update.