public void insert() { Excel.Worksheet ws = (Excel.Worksheet)ThisApplication.Sheets[1]; Excel.Range rng = (Excel.Range)ws.Cells[2, 2]; Excel.Range row = rng.EntireRow; row.Insert(Excel.XlInsertShiftDirection.xlShiftDown, false); }
/// <summary> /// 插入新行 /// </summary> /// <param name="y">模板行号</param> public void insertRow(int row) { Excel.Range range = m_objSheet.get_Range("A" + row.ToString(), "IV" + row.ToString()); range.Copy(miss); range.Insert(Excel.XlDirection.xlDown, miss); //range.get_Range(GetAix(1, row), GetAix(256, row)); //range.Select(); //m_objSheet.Paste(miss, miss); }
/// <summary> /// 插列(在指定WorkSheet指定列右边插入指定数量列) /// </summary> /// <param name="sheetIndex"></param> /// <param name="columnIndex"></param> /// <param name="count"></param> public void InsertColumns(int sheetIndex, int columnIndex, int count) { if (sheetIndex > this.WorkSheetCount) { this.KillExcelProcess(); throw new Exception("索引超出范围,WorkSheet索引不能大于WorkSheet数量!"); } try { workSheet = (Excel.Worksheet)workBook.Worksheets[sheetIndex]; range = (Excel.Range)workSheet.Columns[this.missing, columnIndex]; for (int i = 0; i < count; i++) { range.Insert(Excel.XlDirection.xlDown); } } catch (Exception e) { this.KillExcelProcess(); throw e; } }
/// <summary> /// 插列(在指定列右边插入指定数量列) /// </summary> /// <param name="columnIndex"></param> /// <param name="count"></param> public void InsertColumns(int columnIndex, int count) { try { for (int n = 1; n <= this.WorkSheetCount; n++) { workSheet = (Excel.Worksheet)workBook.Worksheets[n]; range = (Excel.Range)workSheet.Columns[this.missing, columnIndex]; for (int i = 0; i < count; i++) { range.Insert(Excel.XlDirection.xlDown); } } } catch (Exception e) { this.KillExcelProcess(); throw e; } }