i would also like to be able to sync my excel file so that when someone else opens it the matlab code will run. The final product should have something where I generate a GUI in excel someone else opens the excel sheet inputs variables. Then matlab runs the calculations through the code that I have generated on my computer, then that is spit out into a excel table. The people that I work with don't know how to do use matlab, and I am trying to help improve out analysis with and know that matlab would be the proper tool to do so.
How to convert excel spreadsheets to matlab for numerical analysis and then export results back to excel
7 views (last 30 days)
Show older comments
Hello fellow Matlab enthusiasts,
This is not just a question on how to import and export spreadsheets.It is more complicated than that....
I have a large quantity of spreadsheets that other people have created with excel. These spreadsheets contain formulas references, and all of the other bells and whistles that most excel users apply. The spreadsheets all include a general row and column form. What I want to be able to do is pull the infomation in excel and perform optimization on the transpose of the array that is in excel. That would be easy if it was not for the calculations imbedded in each of these sheets. There are multiple workbooks with multiple sheets. They all contain the same number of rows and columns, but the formulas change from sheet to sheet. It is my understanding that if I just imported the sheet into Matlab it would read the current values of the formulas. Since the optimization is going to run simulations by altering the independent variables, then I will need the dependent variable to also change.
I would like to avoid the following issue: -having to retype each formula as it is written in excel into matlab manually. Meaning I don't want to take a formula like K11+K13/k14+4 and change that to something like A(1,1)+A(3,1)/a(4,1).
Thanks for your assistance on this issue.
2 Comments
Joseph Cheng
on 4 Mar 2015
I'd start by taking a look at the file exchange submission http://www.mathworks.com/matlabcentral/fileexchange/9629-analyseexcelformulas which will grab all the fomulas, data, and their location into matlab. Then by parsing out the result you can then recreate and write back to the spreadsheet.
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!