Data Import fromMATLAB
After you finish analyzing data in MATLAB, you can import the results into aMicrosoft Excel传播sheet. For example, you can import MATLAB figures and data. For details about various import methods, seeExecute Spreadsheet Link Functions.
Functions
MLGetFigure |
Import currentMATLABfigure intoMicrosoftExcelworksheet |
MLGetMatrix |
Write contents ofMATLABmatrix toMicrosoftExcelworksheet |
MLGetVar |
Write contents ofMATLABmatrix inMicrosoftExcelVBA 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.