使用替换功能就可以删除指定的关键字。 软件工具:excel2013 1、在excel表格中,按win+H打开替换对话框。
using Excel = Microsoft.Office.Interop.Excel;
using Microsoft.Office.Interop.Excel;
_Workbook n_wb = nwb.Add(strPath);
Sheets sh = n_wb.Sheets;
_Worksheet _wshGL = (_Worksheet)sh.get_Item(1);
Excel.Range rng;
rng = (Excel.Range)_wshGL.Rows["1:1", Type.Missing];
rng.EntireRow.Delete(XlDeleteShiftDirection.xlShiftUp);
//删除第一行