PCXML XLSXOutput Error

[mcha54]

Hi there, we have a workflow that outputs a PCXML file on the gallery. We are on Server 2018.4

It renders and displays on the screen correctly, but when people click on the File Format buttons, an error appears when clicking on the XLSX button.

The output has 42 columns, I don't know if that's an issue?

{"data":null,"exceptionName":"AlteryxServiceException","innerExceptionMessage":"","message":"Unknown error from: XLSXOutput::StartFormatOutput"}

[MichalM]

@mcha54 

Can you test rendering into Excel in your Designer to see whether it throws an error as well and if so what the error is?

[mcha54]

@MichalM I switched the output in Render to "Temporary Excel 2007 Spreadsheet" and it runs fine on Designer (run as Analytic app). Some of the column header text is cutoff, but no errors or issues.

I saved this to the Gallery and ran it -- no error, but nothing is displayed. No toolbar with an Excel button or any data. Is that expected behavior for "Temporary Excel 2007 Spreadsheet"? We're not that used to Gallery yet.

[MichalM]

Temporary files are not supported in the Gallery context. If you change the output to Choose a specific file and only specify a file name (eg Output.xlsx), this will give you an option to download an excel file.

[mcha54]

Ok gotcha! I switched to Specific Output with filename "output.xlsx". It runs fine in Designer and the Gallery - the XLSX button downloads the file without errors.

We are looking to use PCXML though since it has options of different file formats and also displays the results on the screen when they run the app. PDF, Word, HTML, ZIP all render correctly and downloads. It's just the XLSX button in PCXML that doesn't work.

[MichalM]

That is strange. Could you maybe share the Alteryx Service log from around the time the error happens? You can normally find it under C:\ProgramData\Alteryx\Service

[MichalM]

It might also be worth raising this via support@alteryx.com. Thanks!