How to return a matrix from an automation
Hi,
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?
Accepted Solution
BP3 Global Inc
US
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?
Accepted Solution
BP3 Global Inc
US
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?