private void add_ListColumn(object sender, RibbonControlEventArgs e, string ColName) { Excel.Worksheet thisSheet = Globals.ThisAddIn.Application.ActiveSheet as Excel.Worksheet; Excel.ListObject thisList = ExcelHelpers.GetListObject(thisSheet); ExcelHelpers.AddListColumn(thisList, ColName, 0); }
private void updateCalenderYear(Excel.ListObject LO, Excel.ListColumn LC, int rowStart) { Excel.Range LCDate = ExcelHelpers.GetListColumn(LO, "Date").Range; if (LCDate == null) { LCDate = ExcelHelpers.AddListColumn(LO, "Date", 1).Range; } updateRowCYFormula(LO, LC, rowStart); }