Deletion of selected rows of excel from Matlab GUI

3 次查看（过去 30 天）
raghavendra kandukuri
评论： raghavendra kandukuri 2018-8-21
HI, I am new to MATLAB and I am trying to delete all rows except 1st and 2nd where I gave headers. But the way, for example if there are 100 rows, this code is deleting 50 rows, and then if I save that file and try to delete again from MATLAB GUI, it will delete 25 out of those 50 and so on. can any one help me out in understanding what am I doing wrong here.
file = 'C:\Users\rk49845\Documents\MR\experimental TCC\exp2.xlsx';
sheet = 'Sheet1';
Excel = actxserver('Excel.Application');
Workbook = Excel.Workbooks.Open(file);
Worksheet = Workbook.Worksheets.Item(sheet);
for row = 3:100;
Worksheet.Rows.Item(row).Delete;
end
Workbook.Save;
Workbook.Close;
  2 个评论
Adam
Adam 2018-8-17
编辑：Adam 2018-8-17
Never delete things in a loop from start to end. If you must delete in a loop then do it from end to start, otherwise you are pulling the rug out from under your feet with your deletions.
Better still is to do all deletions at once based on a set of indices but I don't know if that is possible with what you are doing as I don't interact with Excel in Matlab.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Image Analyst
Image Analyst 2018-8-21
Like Adam said in the comment above, reverse the order:
for row = 100 : -1 : 3
Worksheet.Rows.Item(row).Delete;
end
  3 个评论
显示 1更早的评论
Image Analyst
Image Analyst 2018-8-21
You could also delete them all in one shot:
% Select the range
Excel.Range(cellReference).Select;
% Clear the cell contents.
Excel.Selection.Clear;
% Put "cursor" or active cell at A1, the upper left cell.
Excel.Range('A1').Select;
cellReference would be something like 'A3:Z100'.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 ActiveX 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by