Output in defined sheet position

Hi everyone,

I have a workflow as a sample attached. I just want to get output in the position of sheet 2 in an excel file. Means, I want to set an order in the excel file which I am getting from output in this workflow where Sheet1 should be empty and my output excel file should be at the 2nd position.

What should I do in the attached workflow to get the attached sample output.

Thanks!

Sample workflow.yxmd

Sample_Input file.xlsx

Avnish Score-Sample Output.xlsx

Geeta Score-Sample Output.xlsx

Output

Accepted answers

Emil_Kos

Hi @Rahul_Analyst,

As per request, this is a workflow that should help you with your problem.

Workflow For Rahul.yxzp

All comments

danilang

Hi @Rahul_Analyst

Here's how you can ensure the order of the sheet in your workbook

The top part of the workflow writes an (almost) empty sheet as sheet1. It's not completely empty, since you have to pass something to get the sheet created. In this case there is a single space in cell A1. The bottom part is your workflow with a synchronizer block added to ensure that the empty sheet1 is finished and the file is closed before sheet 2 starts writing. The Sync block summarizes the output of the top part into a single row, which is unioned with the data from your workflow. The filter and select tool remove the added row and then the added column to pass your data unchanged to the output.

Dan

Sample workflow.yxzp

Rahul_Analyst

@danilang ,

Thank you so much for the response. However, it is giving me one excel file only as an output.

How can I get separated files as mentioned in the path group (name) ?

Thanks!

gabrielvilella

@Rahul_Analyst if you want multiple Excel files you need to have a field with the full path, then use this field in the output data tool. Example: C:\Users\username\Downloads\File1.xlsx|||Sheet1.