Reading tooltip comments from an excel sheet
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Daniel Schmidt
il 22 Mag 2018
Modificato: Daniel Schmidt
il 25 Mag 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 Commenti
Risposta accettata
Sangeetha Jayaprakash
il 24 Mag 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.
1 Commento
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!