Get data from Excel sheet from running .m scripts

I am using Spreadsheet Link Ex. I know how to push data from Excel to Matlab but not the other way round. When I run a .m script, I want the matlab codes to update the data from Excel before calculation. Any example available.

Answer 1

[Fangjun Jiang]

I have not used Spreadsheet Link for a while. I prefer COM server or using xlsread() and xlswrite(). But here is a link.

http://www.mathworks.com/help/toolbox/exlink/f2-2311.html#bsc9p77-1

[Raymond Cheung]

Hi Fangjun,

Thanks! The function xlsread() works the way I want.

br

raymond