I have an automation that takes as input the coordinates (start/end row, start/end column) of an area in an Excel worksheet, and I want to return that matrix of values. I've seen that the Lookup Table is a way to achieve that, but it seems that the number of columns must be known at design time. However my automation is dynamic in the sense that it will traverse whatever number of rows and columns are specified as input.
Can somebody please advise in how to achieve this?
I actually realized the ExportData would do what I was doing manually (nested for loops). I haven't tested though, but I will. Now my question would probably need a separate thread, but how do I traverse a Data Table?