How to separte into multiple excel files from complex main excel

Help Studio
,
1

Hello Experts,

I want to separate into multiple excel files from complex main excel file.
This is my main excel file as below:

image
image894Ă—527 13.3 KB

I just want to separate into multiple excel files as below:

image
image893Ă—190 4.82 KB

image
image

If there is any solutions or workaround for this topic, please let me know and feel free comment on it. Thanks. I will attach the excel file for better understanding.
test.xlsx (12.3 KB)

2

Hello.

The number of lines seems to me that it is not always the same…
Then you can do:

Create a datatable with the names of the columns you need;
Read the entire file using read range.
For each row, look for the value “NTV”… Whenever you find it, you have to save all the rows until the next value “NTV” or until the index of the last row with values + 1 (for the last table).

Hug

3

Hello,

Please try the below attached workflow
forum_splitdatatable.zip (10.0 KB)

4

Hello Venkata, thanks for sharing. It is the solution for my issue. Let me follow on you LinkedIn.

5

Hello,

if it is solved your problem can you mark it as solution

1 Like