Question

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();我都试过不行

Answer 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;
}