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); }
public void GetExcelCellName() { var columnName = ExcelConverter.GetColumnLetter(28); columnName.Should().Be("AB"); }