# Generation of sheets in 1 excel file

**URL:** https://community.automationedge.com/t/generation-of-sheets-in-1-excel-file/2471
**Category:** Get Help & Discuss
**Created:** [August 12, 2020, 5:32am UTC](https://community.automationedge.com/t/generation-of-sheets-in-1-excel-file/2471 "2020-08-12T05:32:05Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![sonam](https://avatars.discourse-cdn.com/v4/letter/s/5fc32e/32.png) [@sonam](https://community.automationedge.com/u/sonam)
#### Post date: [August 12, 2020, 5:32am UTC](https://community.automationedge.com/t/generation-of-sheets-in-1-excel-file/2471/1 "2020-08-12T05:32:05Z")

</div>

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](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/8e4a291e32d68ee85e88c0c67564ba44750dc628.png)

---

<div class="post-metadata">

### Author: ![AE\_Support](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/ae_support/32/354_2.png) [@AE\_Support](https://community.automationedge.com/u/AE_Support)
#### Post date: [August 12, 2020, 9:31am UTC](https://community.automationedge.com/t/generation-of-sheets-in-1-excel-file/2471/2 "2020-08-12T09:31:01Z")

</div>

Hello Sonam,

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

---

<div class="post-metadata">

### Author: ![sonam](https://avatars.discourse-cdn.com/v4/letter/s/5fc32e/32.png) [@sonam](https://community.automationedge.com/u/sonam)
#### Post date: [August 12, 2020, 11:19am UTC](https://community.automationedge.com/t/generation-of-sheets-in-1-excel-file/2471/3 "2020-08-12T11:19:33Z")

</div>

Hi Team,

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