Excel - Clearing Sheet Content
14 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuesta aceptada
Image Analyst
el 28 de Jun. de 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 comentario
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!