Spreadsheet2Structure
라이선스 없음
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
인용 양식
Michael Robbins (2024). Spreadsheet2Structure (https://www.mathworks.com/matlabcentral/fileexchange/8127-spreadsheet2structure), MATLAB Central File Exchange. 검색됨 .
MATLAB 릴리스 호환 정보
플랫폼 호환성
Windows macOS Linux카테고리
태그
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!버전 | 게시됨 | 릴리스 정보 | |
---|---|---|---|
1.0.0.0 |