How to write data into single excel file different sheets

Get Help & Discuss Process Studio
,
1

I have two excel files with one sheet in both files and i want to put both the sheet in one excel file how do i do it? i’m using excel writer but im not able to do the configuration

2

Assuming you want to keep the data on two separate sheets within the new destination file (which is the standard approach regardless of whether the headers match), here is the step-by-step configuration.

1.Read the Files:

Add two separate Microsoft Excel Input steps, configuring each to read one of your source files. Verify by previewing the data.

2.Add Writer Steps:

Connect each Input step to its own separate Microsoft Excel Writer step.

3.Target the Same File:

In both Writer steps, specify the exact same destination path in the Filename field and select the .xlsx Extension. Verify the paths match perfectly.

4.Define Sheet Names:

Set a unique Sheet Name in each Writer step (e.g., “Sheet1” for the first, “Sheet2” for the second). Run the workflow to verify.

Alternative: Merging into a Single Sheet

If both source files have the exact same headers and you want to append the data together into one single sheet:

  • Route both Input steps into a single Microsoft Excel Writer step.

  • Define a single Sheet Name.

  • Set If sheet exists in output file to Write to existing so it appends the rows.

Does this assumption align with what you’re trying to achieve, or were you looking to merge the data differently?