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

1 visualizzazione (ultimi 30 giorni)
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.
  4 Commenti
Mario Malic
Mario Malic il 3 Ott 2020
What about Octave, can your code run there without major modifications?
dpb
dpb il 3 Ott 2020
Not unless Octave includes a compatible table class; never tried Octave so don't have it installed...

Accedi per commentare.

Risposte (0)

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Prodotti


Release

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by