Merging of four Excel spreadsheets of varying size with StudioX only

Help StudioX
,
1

Hi,
I have four Excel spreadsheets each with the same 7 column headers but varying number of rows (e.g. one spreadsheet has 20 rows, while the others have may 50, 12 or 100 rows). How do I merge these files into one large Excel file ? I know how to merge it in Studio but can somebody please tell how to merge these four files into one file in STUDIOX ? Thank you !

2

@Prinal_C - You can try like…Here I have merged 4 files into my output.xlsx

All my input files have 7 rows, File 1=25 rows, File2=50, File3=100, File4=100

image
image833×582 50.7 KB

3

Thank you @prasath17 . The third block is not clear to me (1.1.1 Use Excel File). What does it do ? What is Full Path ? When I tried it, it asked for a particular Excel file. Which of the four files is in this block ?

4

@Prinal_C …that is your input files …

Idea is …first I read my output file and then in the for each loop I am reading my input files and merging them to the output file.

I am outside now, once I am back I will share the workflow.

5

Hi @Prinal_C …Here you go Merge_ExcelFiles.zip (155.5 KB)

Run the file as is, you will see output.xlsx has been created from the data from 4 input files.

Hope this helps.

6

@prasath17 thank you ! This is now working.

1 Like
7

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