private void btn_SectionInterp_Click(object sender, RibbonControlEventArgs e)
{
Application app = Globals.ThisAddIn.Application;
var slpHdl = new SlopeInfoHandler(app);
slpHdl.Execute(checkBox_ContainsHeader.Checked);
}
// 开始具体的调试操作
private static void DoSomething(Application excelApp)
{
Worksheet sht = excelApp.ActiveSheet;
Workbook wkbk = excelApp.ActiveWorkbook;
//
var slpHdl = new SlopeInfoHandler(excelApp);
slpHdl.Execute(containsHeader: 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)
{
int?lastRow = 0;
lastRow = ExcelFunction.GetRowNum(app, "最后一行数据的行号：");
if (lastRow != null)
{
var sumupRow = rg.Rows[1] as Range;
Range indexColumn = sht.Range[rg.Cells[2, 1], rg.Cells[rg.Rows.Count - 1, 1]] as Range;
var startRow = sumupRow.Row + 1;
var dataRowsCount = indexColumn.Count;
//
SumRowHandler.InsertSumupRow(app, sumupRow: sumupRow, indexColumn: indexColumn,
startRow: startRow, dataRowsCount: dataRowsCount, lastRow: lastRow.Value);
}
else
{
MessageBox.Show(@"请输入一个数值");
}
}
return;
//
SumRowHandler.InsertSumupRow(app, sht.Range["A36:Q36"], sht.Range["A37:A64"], 37, 28, 1010 + 7);
return;
var slpHdl = new SlopeInfoHandler(app);
slpHdl.Execute(containsHeader: true);
}
