Data Export toMATLAB

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

When you have data in aMicrosoft Excelspreadsheet, 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, seeExecute Spreadsheet Link Functions.

Functions

`MLAppendMatrix`	Create or appendMATLABmatrix with data fromMicrosoftExcelworksheet
`MLDeleteMatrix`	删除MATLABmatrix
`MLPutMatrix`	Create or overwriteMATLABmatrix with data fromMicrosoftExcelworksheet
`MLPutRanges`	Send data inMicrosoftExcelnamed ranges toMATLAB
`MLPutVar`	Create or overwriteMATLABmatrix with data fromMicrosoftExcelVBA 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 betweenMicrosoft Exceland MATLAB date numbers.
Create Diagonal Matrix Using Microsoft Excel Ribbon
Export data in a named range of a worksheet, execute a MATLAB function using theMicrosoft Excelribbon, and import results intoMicrosoft Excel.
Create Diagonal Matrix Using Microsoft Excel Context Menu
Export data in a named range of a worksheet, execute a MATLAB function using theMicrosoft Excelcontext menu, and import results intoMicrosoft Excel.
Create Diagonal Matrix Using Worksheet Cells
Export data in a named range of a worksheet, execute a MATLAB function usingMicrosoft Excelworksheet cells, and import results intoMicrosoft Excel.
使用VBA宏创建对角矩阵
Export data in a named range of a worksheet, execute a MATLAB function using aMicrosoft ExcelVBA macro, and import results intoMicrosoft Excel.

Related Information

Exchange Data Between MATLAB and Excel