As the name indicates, this feature allows reading of multiple rows into AgilePoint NX process data and writing back process data into multiple rows of the selected Excel. The operations that happen on the Excel, happen on a specified table in the selected Excel.
Prior to this feature being introduced in AgilePoint NX 7.0 SU2, the existing Excel tasks, worked only at cell level i.e. at named field level but if you had to work with table of rows in excel, you had to write some kind of SOAP or REST service wrapper with logic to read such data. Now that you have OOTB activity to deal with rows in Excel, the main benefit, from designer’s perspective is that this approach simplifies the task of reading and writing data to excel tables and significantly improves the development speed. It is easier to maintain. From execution perspective, since the number of operations reduce, the task execution is much faster.
Please refer to the following short video to get familiar with how these new workflow actions work.