public void btnExperimental_Click(IRibbonControl e)
{
ChartBuilder cb = new ChartBuilder();
Tools.Worksheet worksheet = ObjModel.GetActiveSheet();
Excel.Range cells = worksheet.Range["A1", "J20"];
cb.AddChart(worksheet, cells, ChartBuilder.Template.Chart1);
}
//============= KEYBINDS =============
//=============== FORMATTING =========
public static void CopyFormats()
{
Worksheet localSheet = ObjModel.GetActiveSheet();
Excel.Workbook formatBook = Utilities.ObjectModel.OpenWorkbook(@"C:\Users\grins\source\repos\HelloWorld\HelloWorld\format_test.xlsx", ThisAddIn.MyApp, false);
Excel.Worksheet formatSheet = formatBook.Worksheets["Sheet1"];
Excel.Range formatRange = formatSheet.Range["A1:C2"];
//range.Copy;
foreach (dynamic win in formatBook.Windows)
{
win.Visible = false;
}
//formatBook.Windows[1].Visible = false;
Excel.Range localRange = ObjModel.GetSheetRange(localSheet, "A1:C2");
formatRange.Copy();
localRange.PasteSpecial(Excel.XlPasteType.xlPasteAll);
//formatBook.Close();
}
public static void ResetSheet()
{
ObjModel.GetActiveSheet().Cells.Clear();
}
public static void AddFormula(string formula)
{
var sheet = ObjModel.GetActiveSheet();
sheet.Cells[1, 1].Formula = formula;
}