Split one excel file to multiple ones

[neal.wang]

Hello Team,

I’ve blocked by an Excel issue that I want to split one excel to multiple ones according to values of one column.

I’ve tried to copy one sample but failed:

Dist in left pic is a variable defined in my process and its type is dictionary<string, datatbale> as same as dist in right pic which is from a sample.

but when I tried to write range workbook, currentItem doesn’t have the option “Key” while sample has the one.

anyone can help take a look on my question pls?

Thanks!

[ashokkarale]

@neal.wang,

Change For Each - Argument Type to the below highlighted

[AkshaySandhu (AkshaySingh Sandhu)]

There are 2 ways with which you can get your desired result
Method 1:

For each dt in dict.keys (Argument type String)
    WriteRange> dict(dt)
Next dt

Method 2:

For each ky in dict (Argument type system.collection.genericKeyValuePair<system.string, system.data.datatable>)
    WriteRange > ky.Value
Next ky

[neal.wang]

@ashokkarale Thanks Bro.
your method solved my issue, it worked well.

Appreciate!

[neal.wang]

@AkshaySandhu Thanks friend.
I’ve gone with 2nd method and it worked well as desired.

Really appreciate for your guidance.