XLS2STRUCT 1.0

[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

Requirements:	No special requirements
Platforms:	Matlab
Keyword:	Dallas,  Dallas Tulsa Boise,  Default,  Eitime,  Elementwise,  Notation,  Sheet,  Stemp,  Stime,  Stimei,  Tulsa,  Versus,  Xls Structfilesheet
Users rating:	0/10