How to save excel based on customer name


I filtered excel based on vendor name now i have excel sheet with different sheets based vendor name i want to save it each vendor in new excel how to save

Hi @thima
–use excel application scope activity and pass the file path as input
and we can get a output from this activity under workbook property in output and name it out_workbook
–use assign activity and mention like this
out_sheet_path_array = out_workbook.GetSheets
which would give a array of sheet name as string
–now use a for each loop and pass the above variable out_sheet_path_array and change the type argument as string in the for each loop
–inside this for each row loop use a read range and mention the sheet name as item, the variable obtained from the for each loop which actually has the sheet name from array, and get the output variable as a datatable
–then use a write range workbook activity (not excel write range) and mention the new file and mention the sheet name as item and mention the datatable obtained from read range
now this would write the each vendor name in new excel using write range activity from workbook
Hope this would help you
Kindly try this and let know
Cheers @thima

Working fine

1 Like

Thats fantastic
kindly close this topic with right comment marked as solution that could help others as well
Cheers @thima