private static Dictionary <string, string[]> GetTablesIndex(ExcelTable table, string inputs, string outputs)
{
var inputsIsNumber = int.TryParse(inputs, out var inputsColumnsCount);
var outputsIsNumber = int.TryParse(outputs, out var outputsColumnsCount);
Dictionary <string, string[]> dictionary = null;
if (inputsIsNumber && outputsIsNumber)
{
dictionary = ExcelConverter.GetColumnRagngeInLeters(table, inputsColumnsCount, outputsColumnsCount);
}
else
{
var inputsIndex = inputs.Split(',').ToArray();
var outputsIndex = outputs.Split(',').ToArray();
if (inputsIndex.Any() && outputsIndex.Any())
{
dictionary = new Dictionary <string, string[]>()
{
{ "inputsIndex", inputsIndex },
{ "outputsIndex", outputsIndex },
{ "anotations", new [] { ExcelConverter.GetColumnLetter(1) } }
};
}
}
return(dictionary);
}