IO package: Difference between revisions
Jump to navigation
Jump to search
→Matlab compatibility
| Line 314: | Line 314: | ||
=== Matlab compatibility === | === Matlab compatibility === | ||
'''xlsread''', '''xlswrite''' and '''xlsfinfo''' are for the most part Matlab-compatible. Some small differences are mentioned below | '''xlsread''', '''xlswrite''' and '''xlsfinfo''' are for the most part Matlab-compatible. Some small differences are mentioned below. | ||
* xlsread | * xlsread | ||
| Line 326: | Line 326: | ||
** Matlab's xlsread returns strings for cells containing date values. This makes for endless if-then-elseif-else-end constructs to catch all expected date formats. Octave returns numerical data (where 0 = 1/1/1900 – you can easily transfer them into proper octave date values yourself using e.g. datestr(), see bottom of this document for more info). For dates before 1/1/1900, Octave returns dates as text strings. | ** Matlab's xlsread returns strings for cells containing date values. This makes for endless if-then-elseif-else-end constructs to catch all expected date formats. Octave returns numerical data (where 0 = 1/1/1900 – you can easily transfer them into proper octave date values yourself using e.g. datestr(), see bottom of this document for more info). For dates before 1/1/1900, Octave returns dates as text strings. | ||
** Matlab's xlsread invokes csvread if no Excel interface is present. Octave-forge's xlsread doesn't. | ** Matlab's xlsread invokes csvread if no Excel interface is present. Octave-forge's xlsread doesn't. | ||
** Octave can read either formula results (evaluated formulas) or the formula text strings; Matlab can't. | |||
* xlswrite | * xlswrite | ||