How do I send data to excel formula input cell , and receive the output cell data back to Matlab command window. Any examples please help thanks ?
3 views (last 30 days)
Jon on 6 Jun 2022
Edited: Jon on 6 Jun 2022
Assuming it is really required that you go back and forth between Excel and MATLAB you can use MATLAB's spreadsheet link product https://www.mathworks.com/products/spreadsheet-link.html
Often however as @dpb points out you can just read the data in from the spreadsheet perform what ever math you want with this data and then finally write it back to some other cells, using readtable, writetable (or even readmatrix, writematrix).
The former approach (using Spreadsheet Link) is probably only needed if you have users that work exclusively with Excel (not MATLAB) and you want to provide some nice functionality in the background using the power of MATLAB