XLS2STRUCT

Reads xls-file and converts table into a structure.

Description

[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

• MATLAB release: MATLAB 7.0.1 (R14SP1)
• Other requirements: The new version requires Matlab 7. However an pre 7 version is included.
• Other Files: structrows.m, ; xls2struct.m, ; xls2structpre7.m

[Sergio Lucero]

very useful, works great

[Matt Swann]

Fantastic - my quality of life has improved. Thanks.

[Thomas Dionysopoulos]

XLNT, bravo!

[Matthew Hoffman]

BRILLIANT! Should've thought of it myself. Gets rid of hundreds of lines of interpretive code.

[Mark Bower]

Very helpful and easy to use. It would be nice to have the inverse function, 'struct2xls', too!

[Dmitry Savransky]

Works exactly as advertised - great time saver. Would be nice to have equivalent functionality on *nix systems, but that is the fault of the built-in routines, not the author. Thanks!