How to generate the different sheets in 1 excel file. For eg. I have some data that is consolidated in 1 excel file and now I need to split the data in different sheets in the same excel file. How can that be achieved in PS. [Excel_Formatting]

Hi Team, I tried the same but getting an error message as “There should be atleast 1 input row”

Generation of sheets in 1 excel file

AE_Support August 12, 2020, 9:31am 2

Hello Sonam,

Use Block this step until steps finish Step to achieve this scenario.

Topic		Replies	Views
Creating multiple sheets Get Help & Discuss	8	1663	June 3, 2021
Break row data and store it into multiple sheets in single excel file Get Help & Discuss	3	703	July 13, 2020
Take 3 different input excels and write these excels in one excel using different sheets Get Help & Discuss	1	611	May 11, 2021
Take 1 input file with 3 different sheets (same header different data) Process Studio	1	491	April 11, 2022
Web excel how to create three sheet with diffrent data Process Studio rpa , process-studio	1	465	April 10, 2022