C#操作EXCEL 删除列如何实现

Excel.Application ExlApp = new Excel.Application(); ExlApp.Visible = true; object oMissiong = System.Reflection.Missing.Value; ExlApp.Workbooks._Open(filename1, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong);//, oMissiong);//, oMissiong); Excel.Workbook Workbook1 = null; Excel.Worksheet Worksheet1 = null; Workbook1 = ExlApp.Workbooks[1]; Worksheet1 = (Excel.Worksheet)Workbook1.Worksheets[1]; Worksheet1.Columns.Delete(1);这个把所有的列都删除了谁能告诉我删除第一列或者第n列怎么做呢？Worksheet1.Columns[1].Delete();Worksheet1.Columns(1).Delete();我都试过不行

2026年09月24日 11:09

有1个网友回答

网友（1）：

protected bool DeleteCol(int ColNum)
{
((Excel.Range) m_objSheet.Cells[1,ColNum]).Select();
((Excel.Range) m_objSheet.Cells[1,ColNum]).EntireColumn.Delete(0);

//this.m_objSheet.UsedRange.Columns.Delete(ColNum);
return true;
}