Split excel sheet into multiple sheets

Hey, I dont think so, something like this is available in plugins. But we can create the code for it. Steps to do:

1) read the excel file and store it into a variable.

2) then use create excel from CDT as an MNI and in that you can use either foreach for the number of rows to insert or toDatasubset function in which you can give paginginfo. Instead of MNI we can prefer XOR functionality to make looping. 

Hope in that way, you can achieve it. please let me know if any clarification required.

Hey, I dont think so, something like this is available in plugins. But we can create the code for it. Steps to do:

1) read the excel file and store it into a variable.

2) then use create excel from CDT as an MNI and in that you can use either foreach for the number of rows to insert or toDatasubset function in which you can give paginginfo. Instead of MNI we can prefer XOR functionality to make looping. 

Hope in that way, you can achieve it. please let me know if any clarification required.

Adding to the point, you can also compress all the output excels in a ZIP folder so you do not have to download it by doing multiple clicks rather just be able to download the ZIp file including all the excel files. 

Thanks Deepak gupta,

we can use the above steps to achieve the same.

Thank you

please mark the comments as answered if it answers your question