Split an excel sheet into multiple based on a column value

Help
, , ,
1

Dear developers, i have a question regarding splitting an excel sheet into multiple sheets based on column value. hereby attached the desired work.

doc-split-data-by-columns-1
doc-split-data-by-columns-1750Ă—807 43.9 KB

kindly advise if anyone knows. your help is much appreciated. thank you.

1 Like
2

Hi,

The following image might help you.

img20191211-3

Regards,

3

Dear @Yoichi , thank you for your response. could you please share the sample workflow? because it does not work in my case. is there any way without hard coding names into a variable… because names might vary, can we assign the names using row(“names”).tostring in this case?

4

Hi @Yusuf_Rahmaniac

It will work based on string variable like strvar= row(“Name”). ToString

Thanks
Ashwin.S

2 Likes
5

@Yusuf_Rahmaniac

Take a look at the attached xaml, it will help you
Main.xaml (7.4 KB)

3 Likes
6

Hello @Yusuf_Rahmaniac

I wrote a simple Linq query for a case similar like yours check this link

Let me know if you didnt get any part !!

1 Like
7

Hi,

It’s difficult to share the workflow right now, because i’m out.

You can get array of name dynamically, using the following sentence in Excel Application Scope.

arrNames=dtMaster.AsEnumerable.Select(function(r) r("Name").ToString).Distinct().ToArray()

Regards,

1 Like
8

Hi @Yusuf_Rahmaniac,

  • Inside the Excel Application Scope - Read the complete data using ReadRange Activity (dtExcel).
  • Use Filter table (dtResult) to filter the which has name only Lucky.
  • Use WriteRange to new sheet with dtResult . Do the same for all .

Regards
Balamurugan.S

1 Like
9

Thank you so much, it works like a charm

2 Likes
10

You’re welcome @Yusuf_Rahmaniac, Happy coding :slightly_smiling_face:

2 Likes
11

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