Creating multiple sheets

Get Help & Discuss
1

How to create multiple sheets in single excel workbook?

1 Like
2

Hi Sbhubham,
As workflow executes in a parallel manner, we cannot create multiple sheets simultaneously in one excel workbook.
In this case, we need to use “Block the step until steps finish” step to serialize the generation of sheets in one excel workbook like shown in the attached screenshots.

1. WorkflowScreenshot
1. WorkflowScreenshot806Ă—441 13.5 KB
2. ExcelSheet1_Screenshot
2. ExcelSheet1_Screenshot1263Ă—854 73 KB
3. ExcelSheet2_Screenshot
3. ExcelSheet2_Screenshot1260Ă—855 72.7 KB
4. ExcelSheet_Screenshot
4. ExcelSheet_Screenshot1260Ă—858 71.2 KB

1 Like
3

How to merge multipe sheets data into one sheet?

4

Do you have same fields/columns in all the sheets.

1 Like
5

Yes, All fields are same in all sheets

6

Please refer below workflow.

WF_MultipleSheetsInput.psw (19.9 KB)

2 Likes
7

Thank you, successfully executed.

8

Ok ma’am ,i got this with different excel input but “if we are having single excel input file” with 30 rows in it and we want to split it in 3 different sheet with single sheet should consist maximum 10 rows ?

9

Directly go for using step Microsoft Excel Input(get its all sheets while configuring ) and Microsoft Excel Writer