image thumbnail

Spreadsheet2Structu​re

version 1.0.0.0 (1.04 KB) by Michael Robbins
Reads in a spreadsheet and converts it into a structure whos field names are taken from the column h

2.3K Downloads

Updated 27 Jul 2005

No License

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

Cite As

Michael Robbins (2022). Spreadsheet2Structure (https://www.mathworks.com/matlabcentral/fileexchange/8127-spreadsheet2structure), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R14SP1
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!