XLS Import tool

버전 1.1.0.0 (3.03 KB) 작성자: Findlay Yeates
XLS importing tool for variable datasets
다운로드 수: 374
업데이트 날짜: 2011/6/9

라이선스 보기

This was written after i couldn't find a suitable method of importing my Databases from Excel into Matlab.

Call this function with DBDump('filename') and it will import any N x M size Excel table (Remove Headers of the Tables) with any number of Numerical and Date fields,

Restrictions that it can only read dates that are in dd/mm/yyyy format, and all other text will either be ignored or thrown up as an error (So remove any text columns or convert them to numerical entries first)

Update to Ver 2.1 -

Can handle files with any text / headers, will still only read dates in dd/mm/yyyy format, but will record non-date test as NaN.

인용 양식

Findlay Yeates (2024). XLS Import tool (https://www.mathworks.com/matlabcentral/fileexchange/31728-xls-import-tool), MATLAB Central File Exchange. 검색됨 .

MATLAB 릴리스 호환 정보
개발 환경: R2009a
모든 릴리스와 호환
플랫폼 호환성
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.1.0.0

Update to Ver 2.1 -

Can handle files with any text / headers, will still only read dates in dd/mm/yyyy format, but will record non-date test as NaN.

1.0.0.0