I have an excel file consisting all data. I wanted to split them into different files. for example: [image] In the above case, there should be 3 Files (Output) Team A.xlsx Team B.xlsx Team C.xlsx Note that the header should be retained.

Hi @raisonne , Could you Check with the below Steps : Create and Initialise a Dictionary variable in the below way using an Assign Activity : TeamDict = new Dictionary(Of String,Datatable) Get the Team Set as Groups, convert to Datatable and add to Dictionary using an Assign Activity like belo…

Hey please refer from this example Just add the file creation Main.xaml (14.9 KB) Regards

Hey it was just an example how it would work, you have to add the create file activity for reach row and the write range in the created file, you will to change properties as yours needs Regards

[image] supermanPunch: new Dictionary(Of String,Datatable) [image] Please note that I am a beginner :slight_smile:

[image] raisonne: Please note that I am a beginner :slight_smile: @raisonne , Selecting the Required Dictionary Key Value Types can be done as shown below : Click on Browse For Types. [image] Type Dictionary and Select the Highlighted Type from the List : [image] Next, Specify th…

@raisonne , Could you let us know if you were able to implement it ? Is there any issue or errors you are facing?

Still trying to understand the instruction. . .getting a lot of errors

[image] raisonne: .getting a lot of errors @raisonne , Let us know the Errors that you receive, so that we can help you further in correcting it. Additionally, You could also show us the Screenshot of your completed Implementation.

How to split excel data using a specific column using Studio

Help Studio

raisonne (DEJ Raisonne) February 3, 2023, 6:41am 7

Please note that I am a beginner

Topic		Replies	Views
Split data from multiple column in Dynamic way Activities excel , activities , question	2	56	July 30, 2024
Split one excel file to multiple ones Activities excel , question	5	62	October 31, 2025
How to split an excel file into 2 files based on a list, Forum question	14	2868	September 13, 2021
How to separate/split/ group data from excel on basis of specific row content and store it in separate datatable Studio excel	3	1569	March 18, 2020
About spliting the excel sheet based on different types of data / Studio	4	288	February 14, 2024

How to split excel data using a specific column using Studio

Related topics