Output 2 sheets of input file as it is in the output file (Contains images etc.)

[ShantanuDagar]

Hey all,

I have a workflow of reconciliation and updation of certain data sets extracted from multiple input files and sheets using dynamic input.

Everything is working fine, except that 1 main input file has 2 sheets which contain images, links etc. and I want to output those 2 sheets as it is in final output which is created in process.

The final output is created using table, formula, union, layout and render tool of 5 different processes to write in 5 different sheets. All the sheets contain only data tables.

Now I want 2 more sheets to be created in that output which is the 2 sheets of one of the input files and created as it is. (Containing images, links etc.)

Thanks

[ChrisTX]

If you import the Sheets, you lose the images and hyperlinks.  The BLOB tools can't import a Sheet, only an entire file.

So you may be forced to use Python.  See this example to copy a sheet from one Excel file to another:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Duplicate-and-Rename-Excel-Sheet-while...

Then you may need to fix the order of the sheet names.  A Google search "python reorder sheets in excel" mentions:  for an existing workbook, you can only use openpyxl

Chris