XLS2STRUCT

版本 1.0.0.0 (3.5 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.