Repair Error Message on opening Excel File with Multiple sheets Output from Alteryx

Question

Hi Team,

Kindly note I created a merge Excel output with multiple sheets from 3 different Excel files having multiple sheets.

On opening the merge Excel I am first getting mesage "We found problem with some content in..." with a Yes or No button. On Clicking "Yes" then I get a second message as repaired records with a "Recovered_Sheet1" in the output.

See attached Error screenshots for your reference.

Can anyone advise why I am getting these errors or messages?

Excel Error.JPG

Excel Repair Error.JPG

apathetichell · Answer

As hinted at by @ChrisTX - your excel file name/sheet combo should be {{filename}}|||`sheetname` the ` is critical here - it is not the '. this can work as {{filenaem}}|||sheetname - when sheetname has no special characters. You can also use one | instead of ||| - and some versions of Server internally used | - and woud not accept ||| for reasons.

You also cannot use output data and render with the same file in the same workflow - unless you create the sheet first with render and then output data over it.

ChrisTX · Answer

In the second screenshot, send the information from the link "Click to view log..."

Agree with @apathetichell we'll need more details from your workflow.  Does your XLSX file name or Sheet name contain any unusual characters?

apathetichell · Answer

That file wont work. this is something wrong with your alteryx workflow - and the file you are creating is broken. You'll need to share more information on your workflow - and how you are creating your filenames with sheet/range etc.