A book suggestion on using Excel & Matlab together

zzytds · August 31st, 2011, 6:18 pm

Hi there,As my internship requires me to prepare some excel files in order to make complex calculations, I need to deploy some Matlab concepts into Excel. Is there any good tutorial on how to use both together?

Hansi · August 31st, 2011, 7:08 pm

What do you need from Matlab? Books are pointless for this, check examples on mathworks instead.What does the code look like? Is it toolbox heavy? If not rewrite it in VBA or an add-in language.

piterdias · September 1st, 2011, 12:03 pm

QuoteI need to deploy some Matlab concepts into Excel.A life ago (long, long time) someone told that although Matlab is pretty fast, moving data from Excel to Matlab and vice-versa was a performance killer for pratical purposes. Is it true yet?

Hansi · September 1st, 2011, 12:14 pm

Depends on when it was, csv and xls(x) import/export is faster then it used to be in both but still slow for data in spreadsheet range to Matlab and back.. Excel Add-in data in C++ -> Matlab obj or binary data is okay but that's not really dependent on Excel for anything other than control.

eh · September 1st, 2011, 2:04 pm

QuoteOriginally posted by: HansiDepends on when it was, csv and xls(x) import/export is faster then it used to be in both but still slow for data in spreadsheet range to Matlab and back.. Excel Add-in data in C++ -> Matlab obj or binary data is okay but that's not really dependent on Excel for anything other than control.CSV->Matlab using the low-level text-scanning functions can be fast, but reading directly from Excel sheets is slow.

Cuchulainn · September 1st, 2011, 4:47 pm

What would be the business or technical rationale to even want to Excel+Matlab?

Hansi · September 1st, 2011, 5:14 pm

QuoteOriginally posted by: CuchulainnWhat would be the business or technical rationale to even want to Excel+Matlab?Excel - Viewer, data input, data explorerExcel AddIn - Data sourceMatlab + Tool boxes - ModelExcel [User input + Data from Data Source] -> Matlab [Run model] -> Excel [View/check results]Pretty common setup that I've seen. There are multiple additional variation with more or fewer components.