| public static GetWorksheetByName ( string name, Microsoft.Office.Interop.Excel sheets ) : Microsoft.Office.Interop.Excel.Worksheet | ||
| name | string | |
| sheets | Microsoft.Office.Interop.Excel | |
| return | Microsoft.Office.Interop.Excel.Worksheet | |
public static Excel.Worksheet GetWorksheetByName(string name, Excel.Sheets sheets)
{
foreach (Excel.Worksheet ws in sheets)
{
if (ws.Name == name)
{
return ws;
}
}
return null;
}
private void ActivateAndCenterOn(AST.Address cell, Excel.Application app)
{
// go to worksheet
RibbonHelper.GetWorksheetByName(cell.A1Worksheet(), _workbook.Worksheets).Activate();
// COM object
var comobj = cell.GetCOMObject(app);
// center screen on cell
var visible_columns = app.ActiveWindow.VisibleRange.Columns.Count;
var visible_rows = app.ActiveWindow.VisibleRange.Rows.Count;
app.Goto(comobj, true);
app.ActiveWindow.SmallScroll(Type.Missing, visible_rows / 2, Type.Missing, visible_columns / 2);
// select highlighted cell
// center on highlighted cell
comobj.Select();
}