Reading tooltip comments from an excel sheet
4 views (last 30 days)
Show older comments
Daniel Schmidt
on 22 May 2018
Edited: Daniel Schmidt
on 25 May 2018
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?
0 Comments
Accepted Answer
Sangeetha Jayaprakash
on 24 May 2018
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.
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!