Running MATLAB script from Excel that uses COM itself by user without MATLAB

3 views (last 30 days)

dpb on 1 Oct 2020

0
Link

Direct link to this question

https://www.mathworks.com/matlabcentral/answers/603331-running-matlab-script-from-excel-that-uses-com-itself-by-user-without-matlab

Commented: dpb on 3 Oct 2020

Have a Matlab function that reads one Excel workbook worksheet and then writes data from it into specific locations after doing some pattern matching to determine where in the sheet the given data go.

This function works fine and dandy from the MATLAB command line and saves a considerable amount of time in updating the second sheet. It uses a FileExchange submission to create only one instance of the Excel COM object and so runs in 10-15 seconds what took 15-20 minutes to write with writetable.

The Q? is, "Can I package this function such that the bookkeeper can run this while in Excel and logged in on her account though I have the MATLAB license?

This is a nonprofit pro-bono job if it matters any regarding what is/isn't allowed; I didn't find anything in any of the doc about what is needed. It doesn't help that I have to get IT involved to even try to put anything on the system if it requires Admin privileges the lack of which along with not having a clue of what would need means I've not really tried anything figuring I'd immediately run into a roadblock.

I've done enough of the update work to be convinced the present function/script does what it should, now if I could pass the work back over to her, it would be ideal; otherwise I've got to be around to log in and run the ML code or she has to revert to the tedious and error-prone manual transfer of data from workbook 1 to workbook 2.