I need to extract the zip files .Inside the zip files there will be excel file . I need to merge all the excel file into one excel file from all the zip files. Kindly help me with the workflow

Help Activities
, ,
1

AR Ageing Report 2.ZIP (386.0 KB)
AR Ageing Report.ZIP (26.9 KB)
AR Ageing Report1.ZIP (386.0 KB)

I have attached the Zip files as well.

2

@sathish_moorthy

check the reference

3

@sathish_moorthy

Can you try this below approach
Sequence27.zip (2.4 KB)

4

Unable to open the file

5

Hi @sathish_moorthy

Can you try the below

image
image1058Γ—3285 301 KB

BlankProcess20.zip (4.9 MB)

Cheers!!

6

Thanks but i need to merge all the data into a single sheet and i need to delete the first column and first two rows of each excel file before merging. Can you help me on this

7

@sathish_moorthy

Can you try the below

image
image1164Γ—4864 503 KB

BlankProcess20.zip (4.9 MB)

Final.xlsx (3.5 MB)

Cheers!!

1 Like
8

@sathish_moorthy

Try this

image
image1164Γ—4864 322 KB

9

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