How to convert excel spreadsheets to matlab for numerical analysis and then export results back to excel

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.

[keith Runyon]

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.

[Joseph Cheng]

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.