/// <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);
}