http://topic.csdn.net/t/20050919/17/4279898.html/// <summary>
/// 插行(在指定WorkSheet指定行上面插入指定数量行)
/// </summary>
/// <param name="sheetIndex"></param>
/// <param name="rowIndex"></param>
/// <param name="count"></param>
public void InsertRows(int sheetIndex, int rowIndex, int count) {
if (sheetIndex > this.WorkSheetCount) {
this.KillExcelProcess();
throw new Exception("索引超出范围,WorkSheet索引不能大于WorkSheet数量!");
} try {
workSheet = (Excel.Worksheet) workBook.Worksheets[sheetIndex];
range = (Excel.Range) workSheet.Rows[rowIndex, this.missing]; for (int i = 0; i < count; i++) {
range.Insert(Excel.XlDirection.xlDown);
}
} catch (Exception e) {
this.KillExcelProcess();
throw e;
}
}
/// 插行(在指定WorkSheet指定行上面插入指定数量行)
/// </summary>
/// <param name="sheetIndex"></param>
/// <param name="rowIndex"></param>
/// <param name="count"></param>
public void InsertRows(int sheetIndex, int rowIndex, int count) {
if (sheetIndex > this.WorkSheetCount) {
this.KillExcelProcess();
throw new Exception("索引超出范围,WorkSheet索引不能大于WorkSheet数量!");
} try {
workSheet = (Excel.Worksheet) workBook.Worksheets[sheetIndex];
range = (Excel.Range) workSheet.Rows[rowIndex, this.missing]; for (int i = 0; i < count; i++) {
range.Insert(Excel.XlDirection.xlDown);
}
} catch (Exception e) {
this.KillExcelProcess();
throw e;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货