Write data into two different sheets in the same Excel.

Hi All,

can someone help me with this Scenario?

I Have an excel (Test) where it has two sheets A and B. where I need to write data like 10 rows into A Sheet and the other 10 rows into B Sheet

Where I use Switch to Sheet with the same session name but it not working as the sheet is switching but the data is written in A Sheet only.

Can someone help with this? Thanks in advance.