Delete excel row using matlab

Question

Nagham Kabbara 2015-11-12

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/254523-delete-excel-row-using-matlab

评论： Nagham Kabbara 2015-11-16

hi, i am trying to delete one row from a specific excel sheet (i want to delete the whole row i don't want to clear the values)

Excel = actxserver('Excel.Application');
Workbook = Excel.Workbooks.Open(filepath);
sheet1=Excel.Worksheets.get('Item',mysheet);
sheet1.Rows.Item(nbrow).Delete
Workbook.Save;
Workbook.Close;
delete(Excel);

but when i look into the excel the row isn't deleted!! am i missing something here??

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Image Analyst 2015-11-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/254523-delete-excel-row-using-matlab#answer_199598

在 MATLAB Online 中打开

Make Excel visible:

Excel.Visible = true;

Then set a breakpoint on the .delete line and check by looking in Excel itself if the row is deleted when you stop on the delete line.

Or try it this way:

rangeReference = sprintf('A%d..Q200', rowNumber); % Whatever range you want....
Excel.Range(rangeReference).Select;
worksheets.Item(2).Range(rangeReference).Delete;
Excel.Range('A1').Select;  % Set current cell to A1