Read Excel sheet into a structure array

버전 1.0 (7.59 KB) 작성자: Wei-Rong Chen
Read Excel sheet into a structure array
다운로드 수: 816
업데이트 날짜: 2015/4/11

라이선스 보기

% outstruct=xls2struct(xlsFName,sheetnum)
% This function reads the sheet of 'sheetnum' of the input Excel file('xlsFName') and convert it into a
% 1x1 structure array 'outstruct' containing column fields.
% Each field in the output structure containes the data of the
% corresponding column in the input Excel sheet.
% The input Excel sheet MUST content a header row as the first row, which
% will serve as the field name of the output struct.
% 'sheetnum' : the number of the sheet in the input Excel file from which
% the data are read. Default = 1
% Example:
% xls2struct('text.xlsx');
%
% See also 'WriteXlsFromStruct.m'

인용 양식

Wei-Rong Chen (2024). Read Excel sheet into a structure array (https://www.mathworks.com/matlabcentral/fileexchange/50464-read-excel-sheet-into-a-structure-array), MATLAB Central File Exchange. 검색됨 .

MATLAB 릴리스 호환 정보
개발 환경: R2008a
모든 릴리스와 호환
플랫폼 호환성
Windows macOS Linux
카테고리
Help CenterMATLAB Answers에서 Spreadsheets에 대해 자세히 알아보기
태그 태그 추가

Community Treasure Hunt

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

Start Hunting!
버전 게시됨 릴리스 정보
1.0