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

Help
1

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

2

@Yusuf_Rahmaniac

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.

3

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

Untitled
Untitled1288×316 14.2 KB

4

@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.

5

Change as below:

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

6

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