/// <summary>
/// 删除小计行，并将同一Sheet中的多个工程量表进行合并
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_MergeSumRow_Click(object sender, RibbonControlEventArgs e)
{
Application app = Globals.ThisAddIn.Application;
var sht = app.ActiveSheet as Worksheet;
//
var rg = app.InputBox("选择要进行小计行删除的第一页数据，包括小计行。", Type: 8) as Range;
if (rg != null)
{
var sumRows = ExcelFunction.GetMultipleRowNum(app, "选择第一页中的多个小计行：");
if (sumRows.Count == 0)
{
return;
}
//
int?lastRow = ExcelFunction.GetRowNum(app, "选择要处理的最后一行数据：");
if (lastRow == null)
{
return;
}
//
SumRowHandler.DeleteSumupRow(app, page1: rg, sumRows: sumRows, lastRow: lastRow.Value);
}
app.ScreenUpdating = true;
}
// 开始具体的调试操作
private static void DoSomething(Application app)
{
Worksheet sht = app.ActiveSheet;
Workbook wkbk = app.ActiveWorkbook;
var rg = app.InputBox("选择要进行小计行删除的第一页数据，包括小计行。", Type: 8) as Range;
if (rg != null)
{
var sumRows = ExcelFunction.GetMultipleRowNum(app, "选择第一页中的多个小计行：");
if (sumRows.Count == 0)
{
return;
}
//
int?lastRow = ExcelFunction.GetRowNum(app, "选择要处理的最后一行数据的行号：");
if (lastRow == null)
{
return;
}
//
SumRowHandler.DeleteSumupRow(app, page1: rg, sumRows: sumRows, lastRow: lastRow.Value);
}
}
