Split the Excel Summary Report based on Headers into separate sheets

[supermanPunch (Arpan)]

@Zahid1 Check this Workflow:
I had to use Excel Application Scope in order to get the Output needed, as the Workbook activities Read Range resulted in an Error while using it.

Also I had to use one extra Package to make the Workflow work. You should install this Package before executing this workflow as it will throw a Missing Activity Error otherwise.

Check the Summary File, You’ll notice Only one Sheet present. Close the Excel. Execute the workflow.
The Sheets will be created with the header names
SplitDatatableAndCheck.zip (516.3 KB)