Spreadsheet2Structure

Reads in a spreadsheet and converts it into a structure whos field names are taken from the column h

Description

SPREADSHEET2STRUCTURE Reads in a spreadsheet and converts it into a structure whos field names are taken from the column headers in the spreadsheet.
 
  USAGE:
  1. Read in the file with XLSREAD
  2. Pass the text component to
     SPREADSHEET2STRUCTURE along
     with the first column header
  3. SPREADSHEET2STRUCTURE will
     return the strucuture, the row
     number of the header strings
     and the header strings
 
  EXAMPLE
 
  [num,TXT,raw]=xlsread(yourfile);
  [IV,HeaderRow,Headers] = ...
     Spreadsheet2structure(TXT,'customer')
 
  Will take an excel file that looks
  like this:
 
        A B C D
    +--------------------------------
  1 |
  2 | customer amount price
  3 | Smith 10 100
  4 | Jones 4 9.2
 
  It will skip column A and rows 1 and 2,
  because 'customer' doesn't appear until
  cell B2, and returns:
 
  IV.customer = {'Smith','Jones'};
  IV.amount = {'10','4'}
  IV.price = {'100','9.2'}
  HeaderRow = 2
  Headers = {'customer','amount','price'}
 
  It's not fancy, but it works

• MATLAB release: MATLAB 7.0.1 (R14SP1)

[Jeff Evans]

Just what i was looking for. I modified the file a little so xlsread is called within it, rather than needing to be called sepearately. So now the only inputs it needs are ULHeaderValue and filename. I also added a clear statement to get rid of the raw, num, and TXT variables created during the load.

thanks for this useful tool!