Render Tool .xslx is not a supported format error when running as analytic app

[dmpope]

Hi everyone,

I have a workflow that a coworker is using to format a report, the render tool functions properly when running on desktop, but when she tries to run it with the analytic app UI, an error pops up that says the file (a .xlsx file) is an unsupported format:

I've tried:

1) Enabling/Disabling AMP Engine

2) Having the full path of the file in the config window per a post on the community suggested

3) Changing the path to %Temp%Flexcard AR.xlsx per a post on the community suggested

None of the above has worked. Could someone help me out with this error?

Thank you!

[FinnCharlton · Accepted solution]

Hi @dmpope , I think you'll have to remove the "|||sheet1" from the File Path

[binuacs]

@dmpope As @FinnCharlton suggested no need to give the sheet name in the full path, I created a sample workflow and attached it. Can you test this one?

[geraldo]

@dmpope 

Try deactivating the render option in the interface view and open the log to check

[dmpope]

Hi @FinnCharlton 

This was the solution - there was an interface tool connected to the Render tool where to you can change the location of where to save the file and when that happens it makes you select a Sheet to export too. Removing that interface tool removed the Sheet1 since I didn't have that in the tool config in the workflow. 

Thank you!