Excel automation: Splitting into multiple new excel sheet depend on column A

Learn Academy Feedback
1

Dear All,

What I want to do is, splitting into multiple excel csv sheet by reading main purchase order.csv.

image
image874×200 6.43 KB

My criteria is that: By reading the main file, excel files are splitted into multiple csv files which also seperate as in following image
header
image
image1617×423 18.5 KB

detail
image
image840×323 5.86 KB

let me know any suggestion how can i achieve that one. many thanks

2

Hi
you can use default view concept
in assign activity

assign below code to respective datatable variable.

DataTable.DefaultView.ToTable(false,{“Column1”,“column2”})

you can pass column name from main datatable as require in new table

true return distinct records
false return all the records

:+1:

3

Hi Mahanta,

i am still not very clear on your idea, can you please provide me sample xaml if you are available?

4

2106ExcelTask.xlsx (14.4 KB) Main.xaml (7.1 KB)

.here i spited data from sheet 1 to sheet 2 and sheet 3

5

Hi Mahanta,

Thanks for your solution, btw do you know how to create new excel files for write range in these splited excels.

6

No need to create excel manually, its automatically create in default project path if you are use write range activity .

7

Hi Mahanta,

thanks for your solution.=, however, i need to split to new excel files if PO Number is changed.
Can you please suggest more?
Here is my xml and data .

image
image944×243 24.9 KB

Split_Excel.xaml (17.6 KB)