Delete excel row using matlab
2 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (1 件)
Image Analyst
2015 年 11 月 12 日
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
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!