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

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!

Reporting

Interface Tools

Accepted answers

FinnCharlton

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

All comments

FinnCharlton

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

binu_acs

@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?

Render_Sample_060623.yxwz

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703