MATLAB: Reading tooltip comments from an excel sheet

MATLAB

Hello everyone,
I have an Excel file with multiple sheets, that I open in MATLAB via an active X server. I then go through the sheets via a for-loop to extract the data:
[file,path] = uigetfile('*.xlsm');
Excel = actxserver ('Excel.Application');
Excel.Workbooks.Open([path,file]);
Workbook = Excel.ActiveWorkbook;
Worksheets = Workbook.sheets;
numberOfSourceSheets = Worksheets.Count;
for i = 1:numberOfSourceSheets
  sheetIndex = i;
  Worksheets.Item(sheetIndex).Activate;
  caExcelCellInfo = get(Excel.ActiveSheet);
  MyData{i,1} = caExcelCellInfo.UsedRange.Value;
end
So far, my code ignores the tooltip-comments that appear when hovering over a cell. Using
caExcelCellInfo.Comments.Count
I can actually count them so they must be there somewhere, but I haven't found a way to actually read them. Can you guys help me?

Best Answer

Getting each cell, and then using the Comment.Text property as follows, worked for me:
comments = caExcelCellInfo.Comments
cellitem = comments.Item(1)%for the first cell- need to iterate using a loop here for each cell
cellitem .Text
I hope that helps.
Related Question