How to seperate an excel file into multiple excel files based on their date

hi good day everyone, I just have a question. I have this excel file with multiple dates in a column. I want to separate the excel file into multiple excel files based on their date. like this: Capture
in this excel file, I have three dates. I have to separate to three excel files renamed to their respective date. thank you so much


Try below steps.

  1. Use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘DT’.

        uniqueDateDT = DT.DefaultView.ToTable(True,"Cycle Date").CopyToDataTable

And then use ForEach Row activity to iterate one by one dates.

        ForEach row in uniqueDateDT
                  filterDT = DT.Select("[Cycle Date] = '"+row("Cycle Date").Tostring+"'").CopyToDataTable

And then use Write Range activity to write into excel file and pass that filterDT into it.

hi sir, thank you for your response but why do I get the error below?

@Yusuf_Rahmaniac - you can directly use Filter data table activity and mention the condition in wizard and then perform write range activity to get that data into excel.

Change as below:

DT.DefaultView.ToTable(True,“Cycle Date”).Copy

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.