matlab-use-spreadsheet-link

Use Spreadsheet Link functions inside a VBA macro: export data with MLPutMatrix or MLPutVar, run MATLAB code with MLEvalString, and retrieve results with MLGetVar or MLGetMatrix. End the macro with MatlabRequest if you used MLGetMatrix or MLGetFigure.

MLPutMatrix reads an Excel range directly into a MATLAB variable and works in both VBA and worksheet formulas. MLPutVar exports a VBA variable to MATLAB and is VBA-only, making it better when data needs VBA manipulation before or after MATLAB processing.

MLGetMatrix is queued and does not execute immediately in VBA macros. You must call MatlabRequest as the last statement of the macro to process all pending MLGetMatrix and MLGetFigure commands and write results to the worksheet.

No, Spreadsheet Link is Windows only because it communicates with MATLAB through the MATLAB COM Server. MATLAB must also be running locally before the macros execute.

Select the destination cell with Range(...).Select, then call MLGetFigure with width and height scaling factors, followed by MatlabRequest. For multiple figures, make each figure current with figure(N) in MATLAB before each MLGetFigure call.

Avoid it for MATLAB-only workflows with no Excel involvement, Python or .NET integration where the MATLAB Engine API fits better, and web service deployment where MATLAB Production Server is the appropriate tool.