How to split an excel file into another excel file with multiple sheets using values from the column

Help
, , ,
1

hi good evening dear developers, i have a scenario the excel file is like this
ques1
i want to split this sample table into another excel file with multiple sheets using the index value renaming the sheet with the index. the outcome should be like this

QUES2
QUES2222×748 2.7 KB
QUES3
QUES3258×759 3.33 KB

each worksheet belong to an index from the sample table. thank you so much in advance, hope someone helps me.

2

@Yusuf_Rahmaniac,

Check this one, it has the functionality you are looking.
SplitExcelData2Sheets.xaml (6.4 KB)

1 Like
3

Firstly you want to ready the datatable.

Then you can use a for each loop to create each new sheet (with index name) and write the name / index onto each sheet (use Write Range and add row.item(“Index”).ToString as sheetname)

The range it will be “B1”

For Datatable, you will need to just get the current row.
Table.Select(“Index ='”+row.Item(“Index”).ToString+“'”).copytodatatable

1 Like
4

hi dear timk, thank you so much for response. could you show a sample workflow on how to do this?

1 Like
5

@Yusuf_Rahmaniac,

Kindly check the post and the xaml I have shared in this thread.

2 Likes
6

thank you sir. i will try and get back to you.