MATLAB: How to import data from a Text Box in an Excel Spreadsheet into Matlab

excelMATLABtext boxxlsread

I have used an excel template to create many instances of an excel spreadsheet which contains data in a text box. How can I import this data into Matlab? For example, how would I import "Hello World!" in this illustration? I have tried using xlsread to no avail.
HelloWorld.png
Thanks!

Best Answer

Following Walter Roberson's suggestion, I wrote a function which uses actxserver to solve this problem:
function myText=getTextFromExcelTextBox(filename,sheetname,textboxnmbr)
exl=actxserver('excel.application');
exlWkbk=exl.Workbooks;
exlFile=exlWkbk.Open(filename);
myExlSheet = exlFile.Sheets.Item(sheetname);
myText=myExlSheet.Shapes.Item(textboxnmbr).TextFrame.Characters.Text;
end
Related Question