/// <summary> /// Generic method for adding options to the commands page /// </summary> /// <param name="worksheet">Target worksheet</param> /// <param name="name">Name of range being created</param> /// <param name="column">Excel column options are to be placed in, alphabetical named not R1C1 style</param> /// <param name="options">Selectable options from OptionHelper class</param> private void AddOptions(Excel.Workbook workbook, string name, string column, List <string> options) { Excel.Worksheet worksheet = workbook.ActiveSheet; worksheet.Range[$"{column+1}"].Value = name; int i = 2; foreach (var o in options) { worksheet.Range[$"{column + i}"].Value = o; i++; } int optionsCount = options.Count; workbook.CreateNamedRange(name, $"{column + 2}:{column}{1 + optionsCount}"); }
public void CreateNamedRangeTestNullArguments() { InteropExcel.Application excelApp = new InteropExcel.Application(); try { InteropExcel.Workbook workbook = excelApp.Workbooks.Add(); string name = null; Range range = null; Name expected = null; Name actual; actual = workbook.CreateNamedRange(name, range); Assert.AreEqual(expected, actual); } finally { excelApp.Close(); } }
/// <summary> /// Generic method for adding commands to the command table /// </summary> /// <param name="workbook">Target workbook</param> /// <param name="commandName">Name of command range</param> /// <param name="startingInteger">Excel row index where command is to be added</param> /// <param name="commands">List of command items</param> /// <returns></returns> private int AddCommands(Excel.Workbook workbook, string commandName, int startingInteger, List <CommandItem> commands) { Excel.Worksheet worksheet = workbook.ActiveSheet; int i = startingInteger; foreach (var c in commands) { worksheet.Range[$"A{i}"].Value = c.CommandType; worksheet.Range[$"B{i}"].Value = c.Command; worksheet.Range[$"C{i}"].Value = c.Options; worksheet.Range[$"D{i}"].Value = c.Reference; worksheet.Range[$"E{i}"].Value = c.Name; worksheet.Range[$"F{i}"].Value = c.TargetValue; worksheet.Range[$"G{i}"].Value = c.AuxillaryValue; i++; } var commandCount = commands.Count; workbook.CreateNamedRange(commandName, $"B{startingInteger}:B{startingInteger + commandCount - 1}"); return(i + 1); }
public void AddWorkbookNamedRange(Excel.Workbook workbook, string name, string range) { workbook.CreateNamedRange(name, range); }