How to use a data table to update an Excel worksheet

Help Activities
, ,
1

I have a populated data table with keys and values to update a worksheet. Inside an “Excel Process Scope” I have a “Use Excel File” activity. I have a “For Each Row in Data Table” activity to iterate the data table as an outer loop. I am attempting to filter the worksheet based on the keys from currentrow of the data table so I can update the worksheet with values from the data table. But, the process simply freezes upon entering the outer loop of the data table. At present, I would not even be able to read a range from the worksheet to update. I have tried ODBC update dml but it seems to have issues too.

Is there a better way to update a worksheet?

2

It appears the solution is the place the outer loop of the data table inside the Excel Process Scope but the “Use Excel File” inside the outer loop

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.