Excel Link

Data Types

• Excel Link handles only MATLAB two-dimensional numeric arrays, one-dimensional character arrays (strings), and two-dimensional cell arrays containing only strings. It does not work with MATLAB multidimensional arrays, structures, or cell arrays except those containing only strings.

Dates

• Default Excel date numbers start from January 1, 1900, while MATLAB date numbers start from January 1, 0000. Thus May 15, 1996 is 35200 in Excel and 729160 in MATLAB, a difference of 693960. If you use date numbers in MATLAB calculations, apply the 693960 constant: add it to Excel date numbers going into MATLAB, or subtract it from MATLAB date numbers coming into Excel. If you use the optional Excel 1904 date system, the constant is 695422.

Macros

Saved Worksheets