I load an xls file in Matlab, and I need not only the numeric values but the formulas also. Do you have any idea?
A:
If you want to generate a formula from the data values in the xls file, perhaps the Curve Fitting Toolbox is what you need.
Jim Lewis
2010-07-15 23:18:23
I get an error. I think, it work only in Windows, and not on Mac. >> AnalyseExcelFormulas('ADYAN.xls') ??? Undefined function or method 'actxserver' for input arguments of type 'char'. Error in ==> AnalyseExcelFormulas at 90 h.activex1 = actxserver('Excel.Application'); –
Kukoda János
2010-07-16 06:29:30
You are right. It's using COM, which is available only on Windows, to access Excel files. But you didn't specify the OS in the question.
yuk
2010-07-16 15:42:54