Read Row then assign variables to each column in the row

[Jonathan_Glover]

Hi I have a read cell, then write to multiple other workbooks using variables. Whilst this works welI I would prefer to read the entire row of a filtered excel sheet (which is also working fine) and assign a variable to all of the column data to use in the other workbooks.

Currently i have 4 excel application scopes, the original filter application, the 2nd read cell, and then 2 further to write cell in the 2 new workbooks.

I would also like to save as these new files if its possible.

[Shiva_Nikhil]

@Jonathan_Glover
hi welcome to the community

can you provide any sample input and expected output
i am not able to understand your scenario

cheers

[Jonathan_Glover]

the top part of the image is where I take the data from and the lower part is where the data is input.

I have also got 2 more worksheets like the bottom one to write to.

Thanks

[Yoichi]

Hi,

How about using Modern Excel (Use Excel file) instead of ExcelApplicationScope?
There is SaveExcelFileAs activity and we can easily save it as different name.

Regards,