So i try not to do this and live in one world but these things can be achieved through the ActiveX server.
Say for instance i create a simple excel file called testxlsx.xlsx. column A is just the number 1 through 10. Column B is 2*Column A, Column C is 3*Column A -3, etc. where Column A is a constant and B onward is formula. Then color pattern it with something.
Now if you go.
xl = actxserver('excel.application');
xl.visible = 1;
wb = xl.Workbooks.Open('C:\temps\testxlsx.xlsx');
wbSheet1 = wb.Sheets.Item('Sheet1');
robj = wbSheet1.Columns.End(4);
numrows = robj.row;
dat_range = ['C1'];
rngObj = wbSheet1.Range(dat_range);
CellObj = get(rngObj);
Then if you peek inside CellObj for the line above you'll see that the excel formula is stored in
I do not know how to mass do this without going cell by cell and extracting the data.
oh and finding + extracting the plots is something i never figured out where that is located.