Data Export to MATLAB

Export, delete, or modify data in MATLAB^® workspace without leaving Microsoft^® Excel^® environment

When you have data in a Microsoft Excel spreadsheet, you can export the data into the MATLAB workspace for further analysis. For example, export matrices, named ranges, and VBA variables into MATLAB. For details about various export methods, see Execute Spreadsheet Link Functions.

Functions

`MLAppendMatrix`	Create or append MATLAB matrix with data from Microsoft Excel worksheet
`MLDeleteMatrix`	Delete MATLAB matrix
`MLPutMatrix`	Create or overwrite MATLAB matrix with data from Microsoft Excel worksheet
`MLPutRanges`	Send data in Microsoft Excel named ranges to MATLAB
`MLPutVar`	Create or overwrite MATLAB matrix with data from Microsoft Excel VBA variable

Topics

Execute Spreadsheet Link Functions
Learn about different Spreadsheet Link™ function types, execution methods, and how to specify arguments to execute MATLAB functions.
Convert Dates Between Microsoft Excel and MATLAB
Convert between Microsoft Excel and MATLAB date numbers.
Create Diagonal Matrix Using Microsoft Excel Ribbon
Export data in a named range of a worksheet, execute a MATLAB function using the Microsoft Excel ribbon, and import results into Microsoft Excel.
Create Diagonal Matrix Using Microsoft Excel Context Menu
Export data in a named range of a worksheet, execute a MATLAB function using the Microsoft Excel context menu, and import results into Microsoft Excel.
Create Diagonal Matrix Using Worksheet Cells
Export data in a named range of a worksheet, execute a MATLAB function using Microsoft Excel worksheet cells, and import results into Microsoft Excel.
Create Diagonal Matrix Using VBA Macro
Export data in a named range of a worksheet, execute a MATLAB function using a Microsoft Excel VBA macro, and import results into Microsoft Excel.

Related Information

Exchange Data Between MATLAB and Excel