Reading tooltip comments from an excel sheet
显示 更早的评论
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?
采纳的回答
Sangeetha Jayaprakash
2018-5-24
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.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
