XLS Import tool

Version 1.1.0.0 (3,03 KB) von Findlay Yeates
XLS importing tool for variable datasets
0.0
(0)
374 Downloads
Aktualisiert 9 Jun 2011

Lizenz anzeigen

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.

Zitieren als

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

Kompatibilität der MATLAB-Version
Erstellt mit R2009a
Kompatibel mit allen Versionen
Plattform-Kompatibilität
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!

Version Veröffentlicht Versionshinweise
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