Copying the Contents and Format to an Excel with Multiple Sheets

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280

@KamenRider try the blob tools if you are writing your output in a preformatted template like the attached one. The below posts will give you an idea of how the blob tools works with the preformatted template

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

Thanks @binu_acs for the article however, it is possible if you could share me a workflow I can test with so that it would be easy for me to understand it. Is this possible where it will inserted as one of the sheets in the excel created?

Waiting for your response. Thanks.

Kamen

@KamenRider You can find a sample work flow attached in the first post,

HI @binu_acs

I really have a hard time configuring this blob. I have tried creating one however, the desired output is not appearing. The output resulted to no template. But if I close the container 29, the template appears. Can you please help me how I can merge both template and the contents of the file. Below is the snapshots of my workflow.

Hoping to hear you inputs.

Thanks,

Kamen

@KamenRider The workflow from the post was working for you? your template has so many columns that need to be updated, first, create the template and attach a sample input file here

The workflow is working however it doesn't gave me the desired output. The template is not merging with the data. Please see attached sample files.

Looking forward for your response.

Kamen

Template.xlsx

Input File.xlsx

@KamenRider seems to be your input file also in a template, which makes it more complicated, just wondering if your input template and the output template are the same, what is the difference you are going to see if you transfer the data into your output template?

Actually what I wanted is to get same formatted results using Alteryx however, for me, we can't just transfer the formatted copy without converting it into unformatted copy. So what my workflow did as you may view my snapshots, I am converting the formatted input file into unformatted copy and then merge it with the template.

If there is an easy way you know that I can get the formatted results, I am gladly open to know your ideas.

Please let me know if you have any questions.

Kamen

@KamenRider @Using python is an other option in Alteryx, which I never tried, my question is there any differences with your input and output files? Bcoz you are taking the value from the formatted input file and writing to the same formatted output file

Unfortunately, i don't know how to create it from python. Do you have a program of it?

Yes, technically they are the same. It is like copying it using Alteryx. Do you have any easy way of doing it using Alteryx? Note that in my output file, i have several sheet names and the is one to be added in the file.

Looking forward for your response.

Kamen

@KamenRider when you read the pre-formatted input file using the input file tool the data will be in a different format and scattered. Arranging the data in an order requires more effort and more tools which makes the workflow more complicated and complex because each section of the input file needs to be read separately and processed and when you write into the output template again also needs more effort. What I understood was you just need a copy of the template with data which is similar to the save-as option in the Excel file. If that is the case you can write an Excel macro or some script and call it from Alteryx

Thank you for the response. While your ideas is good, unfortunately I am not a programmer to code. Do you know someone who has this kind of process to copy the contents of the file including the format?

Your help is very much appreciated.

Thanks,

Kamen