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