Excel - Clearing Sheet Content
20 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello I have created fle name 'MAT.XLS'
I need to clear the content of 'sheet1' in MAT.XLS fle through matlab, I used ActiveXSERVER command
Excel = actxserver('Excel.Application');
Workbook = Excel.Workbooks.Open(strcat(pwd,'\MAT.xls'));
% Make the application invisible
set(Excel, 'Visible', 0);
% Make excel not display alerts
set(Excel,'DisplayAlerts',0);
% Get a handle to Excel's Workbooks
Workbooks = Excel.Workbooks;
Sheets = Excel.ActiveWorkBook.Sheets;
[type, sheet_names] = xlsfinfo(strcat(pwd,'\MAT.xls'));
current_sheet = get(Sheets, 'Item', 1);
invoke (current_sheet, 'Activate');
How do I clear the contents of the sheet1
Can somebody help me.
0 commentaires
Réponse acceptée
Image Analyst
le 28 Juin 2012
Here's a snippet of code I used to clear the comments.
thisSheet = Excel.ActiveSheet;
% Get a reference to the cell at this row in column A.
cellReference = sprintf('%s%d', columnLetterCode, startingRow);
theCell = thisSheet.Range(cellReference);
% You need to clear any existing comment or else the AddComment method will throw an exception.
theCell.ClearComments();
I imagine it would be
theCell.Clear();
or something similar. Give it a try.
1 commentaire
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!