Segrigate the Web table data in to multiple sheets of one excel file

Get Help & Discuss Process Studio
1

Can we segregate the rows of the web table data into the multiple sheets of one excel while we are using the Web Loop Table step?

2

The Web Loop Table step is used to iterate through each row of a web table. During this iteration, rows can be segregated into different sheets of the same Excel file by using conditional logic and a child workflow.

  1. Use the Web Loop Table step to loop through each row of the web table.

  2. Inside the loop, apply If/Else or decision logic based on a column value (e.g., Category, Status, Type) to determine the target Sheet Name.

  3. Use a Workflow Executor to call a child workflow for Excel operations.

  4. Pass the following parameters to the child workflow:

    • Row data

    • Sheet Name

    • Excel file path

  5. In the child workflow, use the Excel Writer plugin with the Sheet Name parameter.

    • If the sheet does not exist, it is created automatically.

  6. The row is written to the corresponding sheet in the same Excel file.

  7. Web table data is successfully segregated into multiple Excel sheets within a single file.