XLS2STRUCT

Versión 1.0.0.0 (3,48 KB) por Andreas
Reads xls-file and converts table into a structure.
3,7K Descargas
Actualizado 28 ene 2005

Ver licencia

[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

Citar como

Andreas (2026). XLS2STRUCT (https://la.mathworks.com/matlabcentral/fileexchange/4104-xls2struct), MATLAB Central File Exchange. Recuperado .

Compatibilidad con la versión de MATLAB
Se creó con R14SP1
Compatible con cualquier versión
Compatibilidad con las plataformas
Windows macOS Linux
Agradecimientos

Inspiración para: xls2mat

Versión Publicado Notas de la versión
1.0.0.0

A major bug in the last update.