Excel - Clearing Sheet Content
14 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
Image Analyst
on 28 Jun 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.
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!