I’m looking for a way to get the target value in the row and column values of a matrix like the one below, if it is described in Excel.
Example
If ColumnA and RowA are specified: 1
If ColumnB and RowD are specified: 20
If ColumnF and RowF are specified: 36
At first, I tried to use the Filter Data Table activity to narrow down the matrix, but I found that I had to set the row and column values in advance, so I gave up.
Is there any way to get the target values by specifying the rows and columns?
@Kirigirisu_Coin
Maybe you are interested on an mediate datastructure for quick access - done with a dictionary
when we readin the excel by activated add headers we would get following datatable (reduced sample data set was used):
With the help of LINQ we can bring it into a Dictionary(Of String, Dictionary(Of String, Int32))
(From d In dtData.AsEnumerable
Let dc = Enumerable.Range(1, d.Table.Columns.Count - 1).ToDictionary(Function (x) d.Table.Columns(x).ColumnName, Function (x) CInt(d(x).toString))
Let t = Tuple.Create(d(0).toString, dc)
Select v=t).ToDictionary(Function (x) x.Item1,Function (x) x.Item2)